Add Cohort Graduation Year and Cohort Year to FactK12StudentCounts

[AEMJohnnyCunningham]

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)
Johnny Cunningham
Authoring Organization(s)
CEDS
Email Address
jcunningham@aemcorp.com
Use Case Title
Add Cohort Graduation Year and Cohort Year to FactK12StudentCounts

Use Case Overview
Add Cohort Graduation Year and Cohort Year to FactK12StudentCounts to support reporting of EDFacts file specifications FS150 and FS151

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 Data Warehouse (complete DW Design Overview Table)

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

Description of Proposed Changes
Add these 2 columns to FactK12StudentCounts

[CohortGraduationYearId] [int] NOT NULL,
[CohortYearId] [int] NOT NULL,

---

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.