Uganda budget model

ugandabudgetmodel.json

{

"sector": {

    "taxonomy": "uganda.sector",
    "attributes": {
        "name": {
            "column": "sector",
            "datatype": "id",
            "default_value": "",
            "constant": ""
        },
        "label": {
            "column": "sector",
            "datatype": "string",
            "default_value": "",
            "constant": ""
        }
    },
    "type": "compound",
    "description": "Sector of this transaction. Derived from SWG.",
    "label": "Sector"

},
"gou_vote": {

    "taxonomy": "uganda.gou_vote",
    "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",
    "description": "GoU Budget Vote Code ",
    "label": "Vote Code"

},
"sector_objective": {

    "taxonomy": "uganda.swg.sector_objective",
    "attributes": {
        "name": {
            "column": "Sector Objective",
            "datatype": "id",
            "default_value": "",
            "constant": ""
        },
        "label": {
            "column": "Sector Objective",
            "datatype": "string",
            "default_value": "",
            "constant": ""
        }
    },
    "type": "compound",
    "description": "Second-level functional classification",
    "label": "Sector Objective"

},
"source_table": {

    "default_value": "",
    "description": "Source Table for this data",
    "datatype": "string",
    "label": "Source Table",
    "column": "Source_Table",
    "type": "attribute"

},
"donorref": {

    "default_value": "",
    "description": "Donor's project reference number",
    "datatype": "string",
    "label": "Donor project number",
    "column": "Donorref",
    "type": "attribute"

},
"agency_details": {

    "default_value": "",
    "description": "Sub-unit of Agency ",
    "datatype": "string",
    "label": "Agency Details",
    "column": "Agency Details (where relevant)",
    "type": "attribute"

},
"close_date": {

    "default_value": "",
    "description": null,
    "datatype": "string",
    "label": "Project end date",
    "column": "CLOSE DATE",
    "type": "attribute"

},
"project_type": {

    "default_value": "",
    "description": "Limited coverage",
    "datatype": "string",
    "label": "Project Type",
    "column": "Type of Project-Basket",
    "type": "attribute"

},
"aid_modality": {

    "default_value": "",
    "description": "Limited coverage",
    "datatype": "string",
    "label": "Aid Modality",
    "column": "Aid Modality",
    "type": "attribute"

},
"aid_programme_code": {

    "default_value": "",
    "description": null,
    "datatype": "string",
    "label": "Aid Programme Code",
    "column": "Aid_Programme_Code",
    "type": "attribute"

},
"donor_coa_code": {

    "default_value": "",
    "description": "Uganda Chart of Accounts code for donor",
    "datatype": "string",
    "label": "COA Code of Donor",
    "column": "DONOR COA CODE",
    "type": "attribute"

},
"peap_area": {

    "taxonomy": "uganda.peap.objective.area",
    "attributes": {
        "name": {
            "column": "PEAP Area",
            "datatype": "id",
            "default_value": "",
            "constant": ""
        },
        "label": {
            "column": "PEAP Area",
            "datatype": "string",
            "default_value": "",
            "constant": ""
        }
    },
    "type": "compound",
    "description": "Poverty Eradication Action Plan",
    "label": "PEAP Area"

},
"from": {

    "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",
    "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"

},
"signed_date": {

    "default_value": "",
    "description": null,
    "datatype": "string",
    "label": "Agreement signed on",
    "column": "SIGNDATE",
    "type": "attribute"

},
"spending_type": {

    "default_value": "",
    "description": "Whether the spending is a commitment (planned) or a disbursement (outturn)",
    "datatype": "string",
    "label": "Spending Type",
    "column": "spending_type",
    "type": "attribute"

},
"aid_programme_name": {

    "default_value": "",
    "description": null,
    "datatype": "string",
    "label": "Aid Programme Name",
    "column": "Aid_Programme_Name",
    "type": "attribute"

},
"swg": {

    "taxonomy": "uganda.swg",
    "attributes": {
        "name": {
            "column": "SWG",
            "datatype": "id",
            "default_value": "",
            "constant": ""
        },
        "label": {
            "column": "SWG",
            "datatype": "string",
            "default_value": "",
            "constant": ""
        }
    },
    "type": "compound",
    "description": "First-level functional classification",
    "label": "Sector Working Group"

},
"project_code": {

    "default_value": "",
    "description": "Limited coverage",
    "datatype": "string",
    "label": "GoU Project Code",
    "column": "Project Code",
    "type": "attribute"

},
"to": {

    "attributes": {
        "name": {
            "column": "recipient",
            "datatype": "id",
            "default_value": "Society Uganda",
            "constant": ""
        },
        "label": {
            "column": "recipient",
            "datatype": "string",
            "default_value": "Society Uganda",
            "constant": ""
        }
    },
    "type": "compound",
    "description": "the recipient (\"Society (Uganda)\" in all cases)",
    "label": "Recipient"

},
"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.",
    "datatype": "string",
    "label": "Budget Support offset",
    "column": "bs_offset",
    "type": "attribute"

},
"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"

},
"sector_strategy_policy": {

    "default_value": "",
    "description": "Limited coverage",
    "datatype": "string",
    "label": "Sector Strategy or Policy",
    "column": "Sector strategy or policy",
    "type": "attribute"

},
"peap_pillar": {

    "taxonomy": "uganda.peap",
    "attributes": {
        "name": {
            "column": "PEAP Pillar",
            "datatype": "id",
            "default_value": "",
            "constant": ""
        },
        "label": {
            "column": "PEAP Pillar",
            "datatype": "string",
            "default_value": "",
            "constant": ""
        }
    },
    "type": "compound",
    "description": "Poverty Eradication Action Plan",
    "label": "PEAP Pillar"

},
"project_name": {

    "default_value": "",
    "description": "Limited coverage",
    "datatype": "string",
    "label": "GoU Project Name",
    "column": "Project Name",
    "type": "attribute"

},
"financecomment": {

    "default_value": "",
    "description": null,
    "datatype": "string",
    "label": "Financial comments",
    "column": "Financecomment",
    "type": "attribute"

},
"grant_loan": {

    "default_value": "",
    "description": "Limited coverage",
    "datatype": "string",
    "label": "Grant or Loan",
    "column": "GRANT-LOAN",
    "type": "attribute"

},
"amount_ugx": {

    "default_value": "",
    "description": "Amount committed or disbursed in this year in Ugandan Shillings",
    "datatype": "float",
    "label": "UGX Amount",
    "column": "amount",
    "type": "attribute"

},
"donorcurrency": {

    "default_value": "",
    "description": "Currency in which Donor Amount was provided in (if any)",
    "datatype": "string",
    "label": "Donor's currency",
    "column": "donorcurrency",
    "type": "attribute"

},
"agency_name": {

    "default_value": "",
    "description": "Relevant Agency",
    "datatype": "string",
    "label": "Agency Name",
    "column": "Agency Name",
    "type": "attribute"

},
"spending_source_type": {

    "taxonomy": "uganda.spending_source_type",
    "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",
    "description": "The type of spending source (1=GoU; 2=Aid; 3=Budget Support)",
    "label": "Spending Source Type"

},
"donor_name": {

    "default_value": "",
    "description": null,
    "datatype": "string",
    "label": "Donor Name",
    "column": "Donor name",
    "type": "attribute"

},
"subsector": {

    "taxonomy": "uganda.sector.subsector",
    "attributes": {
        "name": {
            "column": "subsector",
            "datatype": "id",
            "default_value": "",
            "constant": ""
        },
        "label": {
            "column": "subsector",
            "datatype": "string",
            "default_value": "",
            "constant": ""
        }
    },
    "type": "compound",
    "description": "Subsector of this transaction. Derived from Sector Objective.",
    "label": "Subsector"

},
"on_off_budget": {

    "default_value": "",
    "description": "Limited coverage",
    "datatype": "string",
    "label": "On or Off Budget",
    "column": "On-Off Budget",
    "type": "attribute"

},
"mtef_sector": {

    "default_value": "",
    "description": "Medium Term Expenditure Framework Sector",
    "datatype": "string",
    "label": "MTEF Sector",
    "column": "MTEF Sector",
    "type": "attribute"

},
"sector_strategy_policy_details": {

    "default_value": "",
    "description": "Limited coverage",
    "datatype": "string",
    "label": "Sector Strategy or Policy Details",
    "column": "Details of sector policy or strategy",
    "type": "attribute"

},
"mtef_reference": {

    "default_value": "",
    "description": "Medium Term Expenditure Framework Reference",
    "datatype": "string",
    "label": "MTEF Reference",
    "column": "MTEF Reference",
    "type": "attribute"

},
"start_date": {

    "default_value": "",
    "description": null,
    "datatype": "string",
    "label": "Project start date",
    "column": "START DATE",
    "type": "attribute"

},
"amount": {

    "default_value": "",
    "description": "Amount committed or disbursed in this year in US Dollars.",
    "datatype": "float",
    "label": "Amount",
    "column": "amount_dollars",
    "type": "measure"

},
"time": {

    "default_value": "",
    "description": null,
    "datatype": "date",
    "label": "Financial year",
    "column": "Year",
    "type": "date"

},
"source_id": {

    "default_value": "",
    "description": "ID from the source table",
    "datatype": "string",
    "label": "Source ID",
    "column": "Source_ID",
    "type": "attribute"

},
"peap_objective": {

    "taxonomy": "uganda.peap.objective",
    "attributes": {
        "name": {
            "column": "PEAP Objective",
            "datatype": "id",
            "default_value": "",
            "constant": ""
        },
        "label": {
            "column": "PEAP Objective",
            "datatype": "string",
            "default_value": "",
            "constant": ""
        }
    },
    "type": "compound",
    "description": "Poverty Eradication Action Plan",
    "label": "PEAP Objective"

},
"unique_id": {

    "default_value": "",
    "description": "Unique row ID",
    "datatype": "string",
    "label": "Unique ID",
    "column": "rowid",
    "key": true,
    "type": "attribute"

},
"programme": {

    "taxonomy": "uganda.programme",
    "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",
    "description": "Recurrent spending only",
    "label": "Programme"

}
}