{"status": "ok", "name": "cflow_v2", "model": {"fact_table": "cflow_facts_v2", "label": "Cash Flow (v2)", "description": "The movement of cash into and out of the municipality. Section 71-level aggregation of mSCOA data from 2019-20 onwards replacing the original cflow cube.", "update_cycle": "quarter", "updates_table": "cash_flow_v2_update", "last_updated": "2026-07-30T12:05", "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": "cflow_items_v2.code", "label": "Code", "type": "string", "description": "Code used by treasury", "ref": "item.code"}, "label": {"column": "cflow_items_v2.label", "label": "Label", "type": "string", "description": "", "ref": "item.label"}, "position_in_return_form": {"column": "cflow_items_v2.position_in_return_form", "label": "Position in Return Form", "type": "integer", "description": "The position of this item in the Section 71 Return form - useful for sorting line items to be ordered as they are in the return form to group related items and place them below the section headings and above section totals.", "ref": "item.position_in_return_form"}, "return_form_structure": {"column": "cflow_items_v2.return_form_structure", "label": "Return Form Structure", "type": "string", "description": "What structural role this line item has in the return form", "ref": "item.return_form_structure"}, "composition": {"column": "cflow_items_v2.composition", "label": "Composition", "type": "string", "description": "The composition of this item. Indicates how this item is composed of other items in this cube for the same mnuicipality, financial year and period, and amount type using item codes.", "ref": "item.composition"}}, "key_attribute": "code", "label_attribute": "label", "description": "", "label": "Item", "join_column": ["item_id", "id"], "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"}, "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_v2.code", "label": "Code", "type": "string", "description": "", "ref": "amount_type.code"}, "label": {"column": "amount_type_v2.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_id", "id"], "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": {}}}