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.
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)
Lakshmana Kommuri
Authoring Organization(s)
CEPI - State Of Michigan
Email Address
kommuril@michigan.gov
Use Case Title
Add TitleIStatusId to FactK12StudentEnrollments
Use Case Overview
CEPI needed Title I Status data available in FactK12StudentEnrollments.
Components Affected
Delete everything from the list below except the components affected:
CEDS Data Warehouse (complete DW Design Overview Table)
CEDS Data Migrations (complete Data Migration Impact Analysis Table)
DATA WAREHOUSE DESIGN OVERVIEW (Includes Dim, Fact, and Report tables)
Description of Proposed Changes
Add TitleIStatusId column to the Fact table - FactK12StudentEnrollments
Make TitleIStatusId as a Foreign key references to DimTitleIStatuses
DATA MIGRATION IMPACT ANALYSIS
Description of Proposed Changes
Update the Staging-to-RDS data migration scripts to populate the new TitleIStatusId field by joining to vwDimTitleIStatuses.
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) Lakshmana Kommuri Authoring Organization(s) CEPI - State Of Michigan Email Address kommuril@michigan.gov Use Case Title Add TitleIStatusId to FactK12StudentEnrollments
Use Case Overview CEPI needed Title I Status data available in FactK12StudentEnrollments.
Components Affected Delete everything from the list below except the components affected:
CEDS Data Warehouse (complete DW Design Overview Table)
CEDS Data Migrations (complete Data Migration Impact Analysis Table)
DATA WAREHOUSE DESIGN OVERVIEW (Includes Dim, Fact, and Report tables)
Description of Proposed Changes
DATA MIGRATION IMPACT ANALYSIS
Description of Proposed Changes Update the Staging-to-RDS data migration scripts to populate the new TitleIStatusId field by joining to vwDimTitleIStatuses.