Extend CEDS DW model to include workforce element to support COI Career Pathways report project

[sethltaylor]

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)
Seth Taylor
Authoring Organization(s)
P20W+ COI
Email Address
staylor@veriteedservices.com
Use Case Title
COI Career Pathways - Workforce Report

Use Case Overview
Data modelling to support the P20W+ COI Career Pathways report for workforce data elements.

Pull Request Number(s) (If applicable)

Use Case Background
The P20W+ COI is working on a career pathways report that links workforce outcomes to K-12, post-secondary, CTE, and adult-ed factors. This update will support data modelling for the workforce data elements.

Components Affected

CEDS Data Warehouse (complete DW Design Overview 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.