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)
Nathan Clinton
Authoring Organization(s)
Mississippi Department of Education
Michigan Center for Education and Performance Information
Email Address
nathan.clinton@aemcorp.com
Use Case Title
Provide a concise description that defines the use case.
SEAs need student addresses tied to enrollment data
Use Case Overview
Provide a concise, high-level description of the actions of the use case. While being concise, the description should cover all possible actions for the use case.
Add a bridge table connected to FactK12StudentEnrollments that captures 1-to-many addresses for a student.
Pull Request Number(s) (If applicable)
Use Case Background
Provide information related to why these changes/additions are needed.
Student addresses are needed for location analysis by both Michigan and Mississippi.
Components Affected
CEDS Data Warehouse (complete DW Design Overview Table)
Add a new table named RDS.BridgeK12StudentEnrollmentPersonAddresses
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) Nathan Clinton
Authoring Organization(s) Mississippi Department of Education Michigan Center for Education and Performance Information
Email Address nathan.clinton@aemcorp.com
Use Case Title Provide a concise description that defines the use case. SEAs need student addresses tied to enrollment data
Use Case Overview Provide a concise, high-level description of the actions of the use case. While being concise, the description should cover all possible actions for the use case. Add a bridge table connected to FactK12StudentEnrollments that captures 1-to-many addresses for a student.
Pull Request Number(s) (If applicable)
Use Case Background Provide information related to why these changes/additions are needed. Student addresses are needed for location analysis by both Michigan and Mississippi.
Components Affected
CEDS Data Warehouse (complete DW Design Overview Table) Add a new table named RDS.BridgeK12StudentEnrollmentPersonAddresses