Add student level Title I data to the dimensional model

[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)
AEM

Email Address
jcunningham@aemcorp.com

Use Case Title
Provide a concise description that defines the use case.
Add student level Title I data to the dimensional model.

Use Case Overview
Provide a concise, high-level description of the actions of the use case. While being concise, the description should cover all possible actions for the use case.
We currently have DimTitleIStatuses which represents Organization level data and there is no dimension for student level Title I data.

Pull Request Number(s) (If applicable)

Use Case Background
Provide information related to why these changes/additions are needed.
We need the student level Title I data for EDFacts reporting

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

Description of Proposed Changes
Provide a concise description of the proposed changes.
We are suggesting creating a new dimension named DimOrganizationTitleIStatuses that will contain the information currently in DimTitleIStatuses and then DimTitleIStatuses will be repurposed for student level CEDS Title I elements.

DATA MIGRATION IMPACT ANALYSIS

Description of Proposed Changes
Provide a concise description of the proposed changes.
We will need to update the Staging-to-RDS migration scripts for both Directory and Title I to use the new dimensions.