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)
Deborah Donovan
Authoring Organization(s)
Mississippi Department of Education
Email Address
ddonovan@mdek12.org
Use Case Title
Create new table to link People and Addresses
Use Case Overview
We would like to be able to link a person (student and staff in particular) with all of their associated addresses, including mailing and physical addresses. There is not currently a way to link this data together for all use cases using existing tables.
Pull Request Number(s) (If applicable)
N/A
Use Case Background
See overview above. For example, we want to display the mailing and physical addresses for all students. Currently, there is no link available.
Components Affected
Delete everything from the list below except the components affected:
CEDS Data Warehouse (complete DW Design Overview Table)
CEDS Data Warehouse Parquet (complete DW Parquet Design Overview Table)
DATA WAREHOUSE DESIGN OVERVIEW (Includes Dim, Fact, and Report tables)
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) Deborah Donovan Authoring Organization(s) Mississippi Department of Education Email Address ddonovan@mdek12.org Use Case Title Create new table to link People and Addresses
Use Case Overview We would like to be able to link a person (student and staff in particular) with all of their associated addresses, including mailing and physical addresses. There is not currently a way to link this data together for all use cases using existing tables.
Pull Request Number(s) (If applicable) N/A Use Case Background See overview above. For example, we want to display the mailing and physical addresses for all students. Currently, there is no link available.
Components Affected Delete everything from the list below except the components affected:
CEDS Data Warehouse (complete DW Design Overview Table)
CEDS Data Warehouse Parquet (complete DW Parquet Design Overview Table)
DATA WAREHOUSE DESIGN OVERVIEW (Includes Dim, Fact, and Report tables)