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)
Andrea Hall
Authoring Organization(s)
On behalf of the Mississippi Department of Education
Email Address
ahall@aemcorp.com
Use Case Title
Add TitleIPartAAllocation to Staging.OrganizationFederalFunding
Use Case Overview
This will allow State Education Agencies to report FS193 Title I Allocations to the US Department of ED through Generate.
Pull Request Number(s) (If applicable)
Use Case Background
There are two reasons for adding this element to Staging:
- Complete federal reporting requirements for Title I Part A.
- To complete the FS193 Title I Allocations ETL Checklist.
Components Affected
CEDS Data Warehouse
CEDS Element Gap Analysis
A CEDS Connection exists but it is old and needs to be updated to align to the current file specification. https://ceds.ed.gov/connectReport.aspx?uid=10770
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.
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)
Andrea Hall
Authoring Organization(s)
On behalf of the Mississippi Department of Education
Email Address
ahall@aemcorp.com
Use Case Title
Add TitleIPartAAllocation to Staging.OrganizationFederalFunding
Use Case Overview
This will allow State Education Agencies to report FS193 Title I Allocations to the US Department of ED through Generate.
Pull Request Number(s) (If applicable)
Use Case Background
There are two reasons for adding this element to Staging:
Components Affected
CEDS Data Warehouse
CEDS Element Gap Analysis
A CEDS Connection exists but it is old and needs to be updated to align to the current file specification. https://ceds.ed.gov/connectReport.aspx?uid=10770
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.