Editing Kotahi data supply (section)

===Materialized Views for Reporting===
====Technical Implementation====
The following materialized views have been created in the <code>kotahi</code> schema to support reporting requirements:

{| class="wikitable sortable"
! Materialized View !! Purpose !! Refresh Schedule
|-
| <code>mvw_activities_summary</code> || Details of kotahi activities|| 00:45 daily
|-
| <code>mvw_client_services</code> || Shows active/inactive service relationships with status history || 00:50 daily
|-
| <code>mvw_client_summary</code> || Core client demographics + household/location metadata || 00:55 daily
|-
| <code>mvw_tupaia_report</code> || Kotahi data relating to tupaia service || 01:05 daily
|-
| <code>mvw_tupaia_stages</code> || Tracks client progression through service stages || 01:15 daily
|-
| <code>mvw_tupaia_stages_counts</code> || Count of tupaia clients in each stage of tupaia pathways || 01:25 daily
|}