CEDStandards / CEDS-Data-Warehouse

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.
https://github.com/CEDStandards/CEDS-Data-Warehouse
Apache License 2.0
22 stars 3 forks source link

Add PerkinsPostProgramPlacementIndicator to DimCteOutcomeIndicators #85

Closed AEMDuaneBrown closed 3 months ago

AEMDuaneBrown commented 3 months ago

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) Duane Brown Authoring Organization(s) AEM on behalf of Mississippi Department of Education Email Address

Use Case Title Add PerkinsPostProgramPlacementIndicator to DimCteOutcomeIndicators

Use Case Overview The existing CEDS element Perkins Post-Program Placement Indicator is an indication of the post-program status of a CTE Concentrator in the second quarter after exiting from secondary education. This would be considered an an outcome. The proposal is to add this option set to the DimCteOutcomeIndicators table. The table contains only two elements presently.

Pull Request Number(s) (If applicable)

Use Case Background Provide information related to why these changes/additions are needed.

Components Affected Delete everything from the list below except the components affected:

CEDS Integrated Data Store (complete IDS Design Overview Table)

CEDS Data Warehouse (complete DW Design Overview Table)

CEDS Data Migrations (complete Data Migration Impact Analysis Table)

CEDS Element Gap Analysis Provide link to CEDS Align Map or Connection.


INTEGRATED DATA STORE DESIGN OVERVIEW

Description of Proposed Changes Provide a concise description of the proposed changes.

As-Is Diagram Add as an attachment in this issue.

Proposed To-Be Diagram Add as an attachment in this issue.


DATA WAREHOUSE DESIGN OVERVIEW (Includes Dim, Fact, and Report tables)

Description of Proposed Changes Provide a concise description of the proposed changes.

As-Is Diagram Add as an attachment in this issue.

Proposed To-Be Diagram Add as an attachment in this issue.


DATA MIGRATION IMPACT ANALYSIS

Description of Proposed Changes Provide a concise description of the proposed changes.

New Business Rule Provide a concise and comprehensive description of the new business rule.

Existing Business Rule Provide a concise and comprehensive description of the existing business rule.

Changed Business Rule Provide a concise and comprehensive description of the changes to be made to the business rule.

AEMDuaneBrown commented 3 months ago

Completed with feature/Issue-85