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)
Center for the Integration of IDEA Data -- CIID
Email Address
nathan.clinton@aemcorp.com
Use Case Title
Remove unused functions from Staging schema
Use Case Overview
There are several functions currently in the Staging schema that refer to CEDS IDS reference tables (Ref tables). These will not function without a fully integrated IDS installed in the same database, plus they are no longer necessary. They should be removed.
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) Center for the Integration of IDEA Data -- CIID
Email Address nathan.clinton@aemcorp.com
Use Case Title Remove unused functions from Staging schema
Use Case Overview There are several functions currently in the Staging schema that refer to CEDS IDS reference tables (Ref tables). These will not function without a fully integrated IDS installed in the same database, plus they are no longer necessary. They should be removed.
Pull Request Number(s) (If applicable) https://github.com/CEDStandards/CEDS-Data-Warehouse/pull/37
Use Case Background These functions were created to support legacy Staging-to-IDS data migrations, which are no longer used or supported.
DATA WAREHOUSE DESIGN OVERVIEW (Includes Dim, Fact, and Report tables) Description of Proposed Changes
Remove the following SQL functions