{"status": "ok", "name": "audit_opinions", "model": {"fact_table": "audit_opinion_facts", "label": "Audit Opinions", "description": "Outcomes of financial statement audits from the Auditor General.", "update_cycle": "year", "updates_table": "audit_opinion_facts_update", "last_updated": "2026-07-30T09:24", "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"}, "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"}, "opinion": {"label": "Opinion", "key_attribute": "code", "label_attribute": "label", "attributes": {"code": {"label": "Code", "column": "opinion_code", "type": "string", "ref": "opinion.code"}, "label": {"label": "Label", "column": "opinion_label", "type": "string", "ref": "opinion.label"}, "report_url": {"label": "Auditor General's Report URL", "column": "report_url", "type": "string", "ref": "opinion.report_url"}}, "ref": "opinion", "label_ref": "opinion.label", "key_ref": "opinion.code", "cardinality_class": null, "hierarchy": "opinion"}}, "measures": {}, "aggregates": {"_count": {"label": "Facts", "ref": "_count", "function": "count"}}, "hierarchies": {}}}