CEDStandards / CEDS-Data-Warehouse

Modeled for longitudinal storage and reporting of P-20W data, the Common Education Data Standards (CEDS) Data Warehouse implements star schema data warehouse normalization techniques for improved query performance.
https://github.com/CEDStandards/CEDS-Data-Warehouse
Apache License 2.0
22 stars 3 forks source link

Create Fact tables to house K12 Calendar Data (Session & Date Level) #68

Open AEMDuaneBrown opened 9 months ago

AEMDuaneBrown commented 9 months ago

This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments.

Author(s) Duane Brown Authoring Organization(s) CEDS / Mississippi Email Address duane.brown@aemcorp.com Use Case Title Create Fact tables to house K12 Calendar Data (Session & Date Level)

Use Case Overview Create two Fact tables, one that will contain K12 Calendar data at the session level and another that will contain K12 Calendar Data at the day (date) level.

Pull Request Number(s) (If applicable)

Use Case Background Needed for tracking calendar information in an SEA. Used for determining days of instruction for funding.