{"status": "ok", "name": "conditional_grants", "model": {"fact_table": "conditional_grant_facts", "label": "Conditional Grants", "description": "Details of grants received from national government.", "return_forms": ["Form for each grant"], "update_cycle": "quarter", "last_updated": "2020-10", "dimensions": {"demarcation": {"attributes": {"code": {"column": "scorecard_geography.geo_code", "label": "Demarcation Code", "type": "string", "description": "Municipality code assigned by the Municipal Demarcation Board", "ref": "demarcation.code"}, "label": {"column": "scorecard_geography.name", "label": "Name", "type": "string", "description": "", "ref": "demarcation.label"}}, "key_attribute": "code", "label_attribute": "label", "description": "Municipality demarcation details", "label": "Municipality", "join_column": "demarcation_code", "ref": "demarcation", "label_ref": "demarcation.label", "key_ref": "demarcation.code", "cardinality_class": null, "hierarchy": "demarcation"}, "grant": {"attributes": {"code": {"column": "conditional_grant_types.code", "label": "Code", "type": "string", "description": "", "ref": "grant.code"}, "label": {"column": "conditional_grant_types.name", "label": "Label", "type": "string", "description": "", "ref": "grant.label"}}, "key_attribute": "code", "label_attribute": "label", "description": "", "label": "Grant", "join_column": "grant_code", "ref": "grant", "label_ref": "grant.label", "key_ref": "grant.code", "cardinality_class": null, "hierarchy": "grant"}, "financial_year_end": {"attributes": {"year": {"column": "financial_year", "label": "Year End", "type": "integer", "description": "", "ref": "financial_year_end.year"}}, "key_attribute": "year", "description": "The calendar year falling at the end of the financial year", "label": "Financial Year", "non_aggregatable": true, "ref": "financial_year_end", "label_attribute": "year", "label_ref": "financial_year_end.year", "key_ref": "financial_year_end.year", "cardinality_class": null, "hierarchy": "financial_year_end"}, "period_length": {"attributes": {"length": {"column": "period_length", "label": "Length", "type": "string", "description": "", "ref": "period_length.length"}}, "key_attribute": "length", "description": "The length of the period this figure corresponds to", "label": "Period Length", "non_aggregatable": true, "ref": "period_length", "label_attribute": "length", "label_ref": "period_length.length", "key_ref": "period_length.length", "cardinality_class": null, "hierarchy": "period_length"}, "financial_period": {"attributes": {"period": {"column": "financial_period", "label": "Period", "type": "integer", "description": "", "ref": "financial_period.period"}}, "key_attribute": "period", "description": "The period this figure corresponds to, e.g. the month number of a month within the financial year or the calendar year end of a financial year.", "label": "Financial Period", "ref": "financial_period", "label_attribute": "period", "label_ref": "financial_period.period", "key_ref": "financial_period.period", "cardinality_class": null, "hierarchy": "financial_period"}, "amount_type": {"attributes": {"code": {"column": "amount_type.code", "label": "Code", "type": "string", "description": "", "ref": "amount_type.code"}, "label": {"column": "amount_type.label", "label": "Label", "type": "string", "description": "", "ref": "amount_type.label"}}, "key_attribute": "code", "description": "Whether this figure is actual, budgeted, audited etc.", "label_attribute": "label", "label": "Amount Type", "join_column": "amount_type_code", "non_aggregatable": true, "ref": "amount_type", "label_ref": "amount_type.label", "key_ref": "amount_type.code", "cardinality_class": null, "hierarchy": "amount_type"}}, "measures": {"amount": {"column": "amount", "label": "Amount", "ref": "amount"}}, "aggregates": {"_count": {"label": "Facts", "ref": "_count", "function": "count"}, "amount.sum": {"label": "Amount", "ref": "amount.sum", "function": "sum", "measure": "amount"}}, "hierarchies": {}}}