Add School Year to Staff Evaluation and Credential Award tables. #89
Description
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) CJ Gilbert
Authoring Organization(s) CEPI, Michigan
Email address GilbertC6@Michigan.gov
Use Case Title
Add School Year to Staff Evaluation and Credential Award tables.
Use Case Overview
Add School Year (000243 ) to the Staff Evaluation and Credential Award tables in the IDS – and to the corresponding classes in the Ontology as well as the corresponding tables in the Data Warehouse (FactK12StaffEvaluationParts and FactCredentialAward)
Use Case Background
In Michigan, staff evaluations are typically collected during the school year in which they occurred, but our state law provides educators with a five-year window in which they can identify errors in the data and appeal to have them changed. As a result, we have a need to store the School Year (000243 ) in the Staff Evaluation table in the IDS (and in the Staff Evaluation class in the Ontology)
Michigan also has certain credentials that are awarded for use during a specific school year, but the Credential Award End Date can vary depending on the type of credential. For example, a daily substitute permit for the 2024-2025 school year will be valid through August 2025 even though the 2025-2026 School Year will ‘start’ on July 1, 2025. As a result, our transactional systems need to be able to associate the award of a specific credential with a specific school year.
We propose modifying the Staff Evaluation and Credential Award tables in the IDS – and the corresponding classes in the Ontology – to include School Year (000243). We also propose adding SchoolYear to the corresponding tables in the Data Warehouse (FactK12StaffEvaluationParts and FactCredentialAward)
Components Affected
• CEDS Integrated Data Store
• CEDS Ontology
• CEDS Data Warehouse
INTEGRATED DATA STORE DESIGN OVERVIEW
Description of Proposed Changes
Add School Year (000243) to the Staff Evaluation and Credential Award tables.
ONTOLOGY DESIGN OVERVIEW
Description of Proposed Changes
Add the property for School Year (000243) to the Staff Evaluation and Credential Award classes.
DATA WAREHOUSE DESIGN OVERVIEW (Includes Dim, Fact, and Report tables)
Description of Proposed Changes
Add a foreign key SchoolYearId to FactK12StaffEvaluationParts and FactCredentialAward. This key would point to the appropriate record in DimSchoolYears