Editing Kotahi data supply (section)

==Pinnacle Workplan==
===Current state===
Database schema and target objects built (staging/rpt)
Staging tables being manually loaded weekly

===TO DO===
* Automation of data pickup and load to staging
** StepFunction:
** S3 trigger -->
** Lambda invocation -->
** Write data to staging
** Truncate/reload to rpt
** <code>Activities</code> needs to be merged/upserted

* Considerations:
** Audit data (inc. diagnostics where applicable)
** Error logging
** Point in time reporting
** Exclude confidential narratives

===Required analysis objects in <code>rpt</code>===
Propose use of materialized views (?) to build objects showing us the following:
* Family views
** Location
** Household size
** Demographic/descriptive info
* Link to Indici<ref>Relies on NHI lkup in Indici.</ref>
** Cross-reference Indici<>Kotahi data.<ref>Where is this useful/valuable?</ref>
* Point in time
** How many cases on this date
** Family risk/need over time
** Rate of change in risk/need over time
* Goal plan analysis
** Goals/needs met
** Mapping of service-level goals/domains to KPT or other wellbeing domains
* Duration/effort
** Multiple staff/ multiple clients
** Activity duration
** Effort/duration and link to goal completion or change in risk/need

ADD MORE HERE!!