Add MEP Session Type (000187) to the K12StaffAssignment table

[CJ-Gilbert-CEPI]

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 MEP Session Type (000187) to the K12StaffAssignment table

Use Case Overview
Add Migrant Education Program Session Type (000187) to the K12StaffAssignment table in the IDS, to the corresponding class in the Ontology, and to an appropriate Dim table in the DW.

Use Case Background
Michigan collects data about whether a staff member’s assignment is part of the Migrant Education Program’s summer session or regular school year. Right now, the CEDS model only includes this information at an organization or program level rather than at the assignment level. We have need to collect it at an assignment level because a person can have multiple assignments with an organization during a time period and not all of them are necessarily related to the Migrant Education Program.

Components Affected
• CEDS Integrated Data Store
• CEDS Ontology
• CEDS Data Warehouse

INTEGRATED DATA STORE DESIGN OVERVIEW

Description of Proposed Changes
Add Migrant Education Program Session Type (000187) to the K12StaffAssignment table

---

ONTOLOGY

Description of Proposed Changes
Add the Migrant Education Program Session Type (000187) to the K12StaffAssignment class.

---

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

Description of Proposed Changes
Add Migrant Education Program Session Type (000187) to an appropriate dim table that is linked to FactK12StaffAssignments.