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)
CEDS
Email Address
nathan.clinton@aemcorp.com
Use Case Title
Add default values to all junk dimension table columns to allow for the easy, consistent addition of new columns
Use Case Overview
Adding new columns to tables can be difficult if the new columns a NOT NULL. Adding a default value constraint to these new columns solves this problem. To remain consistent, we should set all Junk dimension column defaults to 'MISSING'.
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) CEDS
Email Address nathan.clinton@aemcorp.com
Use Case Title Add default values to all junk dimension table columns to allow for the easy, consistent addition of new columns
Use Case Overview Adding new columns to tables can be difficult if the new columns a NOT NULL. Adding a default value constraint to these new columns solves this problem. To remain consistent, we should set all Junk dimension column defaults to 'MISSING'.
Pull Request Number(s) (If applicable)