{"status": "ok", "name": "uifwexp", "model": {"fact_table": "uifwexp_facts", "label": "Unauthorised, Irregular, Fruitless and Wasteful Expenditure", "description": "Specific expenditure amounts from audited financial results, recorded in the notes to the annual financial statements.", "update_cycle": "year", "updates_table": "uifw_expense_facts_update", "last_updated": "2026-07-30T13:55", "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"}, "item": {"attributes": {"code": {"column": "item_code", "label": "Code", "type": "string", "description": "'unauthorised', 'irregular' or 'fruitless' which stands for Fruitless and Wasteful", "ref": "item.code"}, "label": {"column": "item_label", "label": "Label", "type": "string", "description": "", "ref": "item.label"}}, "key_attribute": "code", "label_attribute": "label", "description": "", "label": "Item", "non_aggregatable": true, "ref": "item", "label_ref": "item.label", "key_ref": "item.code", "cardinality_class": null, "hierarchy": "item"}, "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"}}, "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": {}}}