Given the complexity of multi-year data across departments, programs, strategies, variable metrics and data sources, it seems like hosting a dedicated database to house all the pulled data will be more efficient for managing and analyzing data as it's collected.
Potential tables
Each of these should have a clear definition.
fundingAgency: the agency that receives the funds from MZ and oversees the programming
operatingOrg: the organization that implements the funded program
program: the specific program that directly provides the services funded
spendingYear: the year funding was allocated for
Requirements for closing this issue
These can be changed as appropriate.
[ ] A schema that accepts the many different metrics available is mapped out and documented.
[ ] Schema documentation is reviewed with FPS team for troubleshooting.
[ ] Schema documentation is attached to this issue.
[ ] Next steps for implementing the scheme are identified and documented in one or more issues (e.g. "Choose a database platform").
Description
Given the complexity of multi-year data across departments, programs, strategies, variable metrics and data sources, it seems like hosting a dedicated database to house all the pulled data will be more efficient for managing and analyzing data as it's collected.
Potential tables
Each of these should have a clear definition.
Requirements for closing this issue
These can be changed as appropriate.