Uganda mapping with datatype problem

gistfile1.txt

{
  "sector": {
    "description": "Sector of this transaction. Derived from SWG.",
    "taxonomy": "uganda.sector",
    "label": "Sector",
    "facet": true,
    "attributes": {
      "name": {
        "column": "sector",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "sector",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "sector"
  },
  "gou_vote": {
    "description": "GoU Budget Vote Code\u00a0",
    "taxonomy": "uganda.gou_vote",
    "label": "Vote Code",
    "facet": true,
    "attributes": {
      "code": {
        "column": "GOU Vote",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      },
      "name": {
        "column": "Vote Name",
        "datatype": "id",
        "default_value": "undefined",
        "constant": ""
      },
      "label": {
        "column": "Vote Name",
        "datatype": "string",
        "default_value": "(Undefined)",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "gou_vote"
  },
  "project_type": {
    "default_value": "",
    "description": "Limited coverage",
    "label": "Project Type",
    "facet": true,
    "attributes": {
      "name": {
        "column": "Type of Project-Basket",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "Type of Project-Basket",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "project_type"
  },
  "source_table": {
    "default_value": "",
    "description": "Source Table for this data",
    "datatype": "string",
    "label": "Source Table",
    "column": "Source_Table",
    "type": "attribute",
    "dimension": "source_table"
  },
  "donorref": {
    "default_value": "",
    "description": "Donor's project reference number",
    "datatype": "string",
    "label": "Donor project  number",
    "column": "Donorref",
    "type": "attribute",
    "dimension": "donorref"
  },
  "peap_objective": {
    "description": "Poverty Eradication Action Plan",
    "taxonomy": "uganda.peap.objective",
    "label": "PEAP Objective",
    "facet": true,
    "attributes": {
      "name": {
        "column": "PEAP Objective",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "PEAP Objective",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "peap_objective"
  },
  "close_date": {
    "default_value": "",
    "description": null,
    "datatype": "string",
    "label": "Project end date",
    "column": "CLOSE DATE",
    "type": "attribute",
    "dimension": "close_date"
  },
  "sector_objective": {
    "description": "Second-level functional classification",
    "taxonomy": "uganda.swg.sector_objective",
    "label": "Sector Objective",
    "facet": true,
    "attributes": {
      "name": {
        "column": "Sector Objective",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "Sector Objective",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "sector_objective"
  },
  "aid_modality": {
    "default_value": "",
    "description": "Limited coverage",
    "label": "Aid Modality",
    "facet": true,
    "attributes": {
      "name": {
        "column": "Aid Modality",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "Aid Modality",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "aid_modality"
  },
  "aid_programme_code": {
    "default_value": "",
    "description": null,
    "label": "Aid Programme Code",
    "facet": true,
    "attributes": {
      "name": {
        "column": "Aid_Programme_Code",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "Aid_Programme_Code",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "aid_programme_code"
  },
  "donor_coa_code": {
    "default_value": "",
    "description": "Uganda Chart of Accounts code for donor",
    "label": "COA Code of Donor",
    "facet": true,
    "attributes": {
      "name": {
        "column": "DONOR COA CODE",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "DONOR COA CODE",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "donor_coa_code"
  },
  "peap_area": {
    "description": "Poverty Eradication Action Plan",
    "taxonomy": "uganda.peap.objective.area",
    "label": "PEAP Area",
    "facet": true,
    "attributes": {
      "name": {
        "column": "PEAP Area",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "PEAP Area",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "peap_area"
  },
  "from": {
    "description": "Name of the spending source. Either the Government of Uganda, or the specific donor who provided the funds. If the specific donor is not known, then \"Donors\" is provided.",
    "label": "Spender",
    "facet": true,
    "attributes": {
      "code": {
        "column": "spending_source_id",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      },
      "name": {
        "column": "spending_source",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "spending_source",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "from"
  },
  "signed_date": {
    "default_value": "",
    "description": null,
    "datatype": "string",
    "label": "Agreement signed on",
    "column": "SIGNDATE",
    "type": "attribute",
    "dimension": "signed_date"
  },
  "spending_type": {
    "default_value": "",
    "description": "Whether the spending is a commitment (planned) or a disbursement (outturn)",
    "label": "Spending Type",
    "facet": true,
    "attributes": {
      "name": {
        "column": "spending_type",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "spending_type",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "spending_type"
  },
  "aid_programme_name": {
    "default_value": "",
    "description": null,
    "label": "Aid Programme Name",
    "facet": true,
    "attributes": {
      "name": {
        "column": "Aid_Programme_Name",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "Aid_Programme_Name",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "aid_programme_name"
  },
  "swg": {
    "description": "First-level functional classification",
    "taxonomy": "uganda.swg",
    "label": "Sector Working Group",
    "facet": true,
    "attributes": {
      "name": {
        "column": "SWG",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "SWG",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "swg"
  },
  "project_code": {
    "default_value": "",
    "description": "Limited coverage",
    "datatype": "string",
    "label": "GoU Project Code",
    "column": "Project Code",
    "type": "attribute",
    "dimension": "project_code"
  },
  "to": {
    "attributes": {
      "name": {
        "column": "recipient",
        "datatype": "id",
        "default_value": "Society Uganda",
        "constant": ""
      },
      "label": {
        "column": "recipient",
        "datatype": "string",
        "default_value": "Society Uganda",
        "constant": ""
      }
    },
    "label": "Recipient",
    "type": "compound",
    "dimension": "to",
    "description": "the recipient (\"Society (Uganda)\" in all cases)"
  },
  "bs_offset": {
    "default_value": "",
    "description": "A 1 denotes that this entry is a value created to offset budget support from Government of Uganda spending. This is necessary to avoid double-counting when showing aggregations (of Government of Uganda spending, budget support and project aid) at higher levels, but it does not affect the actual amounts in the projects. Budget Support is money given directly to the government which they can spend on their own priorities.",
    "label": "Budget Support offset",
    "facet": true,
    "attributes": {
      "name": {
        "column": "bs_offset",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "bs_offset",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "bs_offset"
  },
  "amount_donor": {
    "default_value": "",
    "description": "Amount committed or disbursed in this year in the donor currency (if available)",
    "datatype": "float",
    "label": "Donor Amount",
    "column": "amount_donor",
    "type": "attribute",
    "dimension": "amount_donor"
  },
  "start_date": {
    "default_value": "",
    "description": null,
    "datatype": "string",
    "label": "Project start date",
    "column": "START DATE",
    "type": "attribute",
    "dimension": "start_date"
  },
  "peap_pillar": {
    "description": "Poverty Eradication Action Plan",
    "taxonomy": "uganda.peap",
    "label": "PEAP Pillar",
    "facet": true,
    "attributes": {
      "name": {
        "column": "PEAP Pillar",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "PEAP Pillar",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "peap_pillar"
  },
  "project_name": {
    "default_value": "",
    "description": "Limited coverage",
    "label": "GoU Project Name",
    "facet": true,
    "attributes": {
      "name": {
        "column": "Project Name",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "Project Name",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "project_name"
  },
  "financecomment": {
    "default_value": "",
    "description": null,
    "datatype": "string",
    "label": "Financial comments",
    "column": "Financecomment",
    "type": "attribute",
    "dimension": "financecomment"
  },
  "grant_loan": {
    "default_value": "",
    "description": "Limited coverage",
    "label": "Grant or Loan",
    "facet": true,
    "attributes": {
      "name": {
        "column": "GRANT-LOAN",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "GRANT-LOAN",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "grant_loan"
  },
  "amount_ugx": {
    "default_value": "",
    "description": "Amount committed or disbursed in this year in Ugandan Shillings",
    "datatype": "float",
    "label": "UGX Amount",
    "column": "amount",
    "type": "attribute",
    "dimension": "amount_ugx"
  },
  "donorcurrency": {
    "default_value": "",
    "description": "Currency in which Donor Amount was provided in (if any)",
    "label": "Donor's currency",
    "facet": true,
    "attributes": {
      "name": {
        "column": "donorcurrency",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "donorcurrency",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "donorcurrency"
  },
  "agency_name": {
    "default_value": "",
    "description": "Relevant Agency",
    "label": "Agency Name",
    "facet": true,
    "attributes": {
      "name": {
        "column": "Agency Name",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "Agency Name",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "agency_name"
  },
  "spending_source_type": {
    "description": "The type of spending source",
    "taxonomy": "uganda.spending_source_type",
    "label": "Spending Source Type",
    "facet": true,
    "attributes": {
      "code": {
        "column": "spending_source_type_id",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      },
      "name": {
        "column": "spending_source_type_label",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "spending_source_type_label",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "spending_source_type"
  },
  "donor_name": {
    "default_value": "",
    "description": null,
    "label": "Donor Name",
    "facet": true,
    "attributes": {
      "name": {
        "column": "Donor name",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "Donor name",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "donor_name"
  },
  "subsector": {
    "description": "Subsector of this transaction. Derived from Sector Objective.",
    "taxonomy": "uganda.sector.subsector",
    "label": "Subsector",
    "facet": true,
    "attributes": {
      "name": {
        "column": "subsector",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "subsector",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "subsector"
  },
  "on_off_budget": {
    "default_value": "",
    "description": "Limited coverage",
    "column": "On-Off Budget",
    "label": "On or Off Budget",
    "facet": true,
    "attributes": {
      "name": {
        "column": "On-Off Budget",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "On-Off Budget",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "on_off_budget"
  },
  "mtef_sector": {
    "default_value": "",
    "description": "Medium Term Expenditure Framework Sector",
    "label": "MTEF Sector",
    "facet": true,
    "attributes": {
      "name": {
        "column": "MTEF Sector",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "MTEF Sector",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "mtef_sector"
  },
  "sector_strategy_policy_details": {
    "default_value": "",
    "description": "Limited coverage",
    "label": "Sector Strategy or Policy Details",
    "facet": true,
    "attributes": {
      "name": {
        "column": "Details of sector policy or strategy",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "Details of sector policy or strategy",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "sector_strategy_policy_details"
  },
  "mtef_reference": {
    "default_value": "",
    "description": "Medium Term Expenditure Framework Reference",
    "label": "MTEF Reference",
    "facet": true,
    "attributes": {
      "name": {
        "column": "MTEF Reference",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "MTEF Reference",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "mtef_reference"
  },
  "sector_strategy_policy": {
    "default_value": "",
    "description": "Limited coverage",
    "label": "Sector Strategy or Policy",
    "facet": true,
    "attributes": {
      "name": {
        "column": "Sector strategy or policy",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "Sector strategy or policy",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "sector_strategy_policy"
  },
  "amount": {
    "default_value": "",
    "description": "Amount committed or disbursed in this year in US Dollars.",
    "datatype": "float",
    "label": "Amount",
    "column": "amount_dollars",
    "type": "measure",
    "dimension": "amount"
  },
  "time": {
    "default_value": "",
    "description": null,
    "format": null,
    "column": "Year",
    "label": "Financial year",
    "datatype": "date",
    "type": "date",
    "dimension": "time"
  },
  "source_id": {
    "default_value": "",
    "description": "ID from the source table",
    "datatype": "string",
    "label": "Source ID",
    "column": "Source_ID",
    "type": "attribute",
    "dimension": "source_id"
  },
  "agency_details": {
    "default_value": "",
    "description": "Sub-unit of Agency\u00a0",
    "label": "Agency Details",
    "facet": true,
    "attributes": {
      "name": {
        "column": "Agency Details (where relevant)",
        "datatype": "id",
        "default_value": "",
        "constant": ""
      },
      "label": {
        "column": "Agency Details (where relevant)",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "agency_details"
  },
  "unique_id": {
    "default_value": "",
    "description": "Unique row ID",
    "column": "rowid",
    "label": "Unique ID",
    "datatype": "string",
    "key": true,
    "type": "attribute",
    "dimension": "unique_id"
  },
  "programme": {
    "description": "Recurrent spending only",
    "taxonomy": "uganda.programme",
    "label": "Programme",
    "facet": true,
    "attributes": {
      "code": {
        "column": "Programme Code",
        "datatype": "string",
        "default_value": "",
        "constant": ""
      },
      "name": {
        "column": "Programme Name",
        "datatype": "id",
        "default_value": "undefined",
        "constant": ""
      },
      "label": {
        "column": "Programme Name",
        "datatype": "string",
        "default_value": "(Undefined)",
        "constant": ""
      }
    },
    "type": "compound",
    "dimension": "programme"
  }
}