Enable Identification of Employer of Staff vs. Owner of Staff Work Location

[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; Kristy Webber

Authoring Organization(s): State of Michigan/CEPI

Email address: [email protected]

Use Case Title
Enable Identification of Employer of Staff vs. Owner of Staff Work Location

Use Case Description

Element Name: Employer LEA Identifier
Element Definition: Stores the LEA identifier of the employing entity

Element Name: Employer IEU Identifier
Element Definition: Stores the ISD identifier of the employing entity

Use Case Background
The entity that owns the school building is not always the same entity paying the salary of the staff member assigned to that building. Some of our reports call for aggregations based on where people have been assigned to work, and other reports call for aggregations based on who has employed those persons.

Right now, our state stores employment data and assignment data in two separate tables which allows us to differentiate between the district that owns the building and the district paying the salary.

In the CEDS Data Warehouse, there is only a single fact table that houses both employment and assignment data, and that table only has elements for linking to a single district or a single ISD. CEDS does not currently have a way to store separate districts so that we can aggregate numbers separately for these two types of relationships.

Adding these element would allow us to use the (already existing) fields of a) SchoolId, b) LeaId, and c) IeuId in the Data Warehouse to represent a) the school to which a staff member is assigned, b) the LEA which owns that building, and c) the IEU in which that building is located.

And then we’d could use EmployerLEAId and EmployerIEUId to point to the employing entities.

Location of Element in the Domain Entity Schema
K12 -> K12 Staff -> Assignment 
K12 -> K12 School -> Job
K12 -> LEA -> Job

[CJ-Gilbert-CEPI]

Proposed solution to use case 924:

Add EmployerLEA and EmployerIEU Issue_924 Proposed Solution.docx

[CJ-Gilbert-CEPI]

An updated solution that reflects that the solution requires changes to the DW FactK12StaffAssignment table rather the addition of new elements.

CEDS OSC DW_Issue_93 EmployerLEAId - Proposed Solution - V2.docx