Integration of Attendance Status and Truancy Data into CEDS Data Warehouse

[VT-AOE-DMAD-Drew-Bennett]

Author(s): Drew Bennett-Stein

Authoring Organization(s): State of Vermont, Agency of Education

Email Address: Drew.Bennett@vermont.gov

Use Case Title: Integration of Attendance Status and Truancy Data into CEDS Data Warehouse

Use Case Overview:
This use case proposes the integration of detailed attendance status (excused/unexcused) and truancy data into the CEDS Data Warehouse. This includes the addition of new tables such as DimAttendanceStatuses and modifications to existing tables like FactK12StudentAttendanceRates or FactK12StudentDailyAttendances for capturing the number of unexcused absences.

Pull Request Number(s) (If applicable): [To be filled after initiating the pull request]

Use Case Background:
The current CEDS Data Warehouse model lacks specific data points for Attendance Status (excused/unexcused) and does not include a field for 'NumberofDaysUnexcused' in the RoleAttendance section. This data is vital for analyzing attendance patterns and addressing issues like truancy effectively.

Components Affected:

CEDS Data Warehouse (complete DW Design Overview Table)
INTEGRATED DATA STORE DESIGN OVERVIEW

Description of Proposed Changes:
The proposal is to add a new table, DimAttendanceStatuses, for detailed attendance statuses, and to enhance existing tables to capture 'NumberofDaysUnexcused'.

As-Is Diagram: [Attachment Required]

Proposed To-Be Diagram: [Attachment Required]

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

Description of Proposed Changes:
Addition of DimAttendanceStatuses table and modifications to FactK12StudentAttendanceRates or FactK12StudentDailyAttendances to include unexcused absences data.

As-Is Diagram: [Attachment Required]

Proposed To-Be Diagram: [Attachment Required]

DATA MIGRATION IMPACT ANALYSIS

Description of Proposed Changes:
Introduction of new data points for attendance status and truancy.

New Business Rule:

Capture and store detailed attendance status (excused/unexcused).
Record 'NumberofDaysUnexcused' for each student.
Existing Business Rule:

[Describe the current business rules regarding attendance data management]
Changed Business Rule:

Enhancement of the existing business rule to include detailed attendance statuses and truancy data.