Tool Search: Ed-Fi
This association indicates the education organization an employee, contractor, volunteer or other service provider is formally associated with typically indicated by which organization the staff member has a services contract with or receives compensation from.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When a person has a District Employment record that overlaps the configured year and an active District Assignment record populated. OR When a person has a District Assignment record and the District Staff checkbox is not marked Does NOT report a record if any of the following scenarios are true:
When the school staff member has more than one qualifying District Assignment record, a record generates for each eligible School/Start date. |
| Delete/Post | When any field part of the natural key changes:
When there are two District Assignment records that create the same natural Key and one is deleted, the remaining record is posted. |
| Delete |
|
School Exclude, Calendar Exclude, Resource Toggle and Resync Logic
This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.
| Action | Trigger |
|---|---|
| None | When a resource is toggled to off after data has sent, all sent data remains in the ODS but no new data sends. |
| Resync | When a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is deleted from the Ed-Fi Identity Mapping table. |
| Resync | When a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it is deleted from the ODS. |
| Resync | When a mapping is changed in Resource Preferences, a resync needs to be done to reflect the changes. |
Natural Key Changes, Cascading Updates, and Deletes Logic
This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.
| Action | Trigger |
|---|---|
| Delete/Post | Natural Key change:
|
| Delete/Post | When the Start Date or Employment Status Descriptor changes, the record deletes and reposts. |
| Delete/Post | There are no dependent resources. |
Scope Year Logic
This table describes scope year logic of this object.
| Logic |
|---|
A record reports when a person has a District Assignment or District Employment record that is aligned to a scoped year.
|
Data only sends for the years that have valid configuration. |
Resource Preferences
This table describes the Resource Preferences of this object.
| Data Element Label | Mapping Needed |
|---|---|
Separation Reason Descriptors | Employment Exit Reason |
| Level Of Education Institution Descriptors | Employment Baccalaureate Degree Institution |
Event Queue Detail
This table describes the Event Queue Detail of this object.
| Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| employment | Post/Put/Delete | The primary table used for sending data for this resource. |
| employmentassignment | Post/Put/Delete | The primary table used for sending data for this resource. |
Object Data Elements
This table describes data elements sent within the Staff Education Organization Assignment Association resource.
| Data Element Label | Description | M, C, or O | Database Location |
|---|---|---|---|
id | The unique identifier of the resource | M | |
| employmentStatusDescriptor | This descriptor defines the type of employment or contract. Reports as FTE. | M | employment.status employmentassignment.type |
| hireDate | The month, day, and year on which a contract between an individual and a governing authority specifies that employment is to begin (or the date on which the agreement is made valid). NEDM: Contract Beginning Date. When reporting from the District Employment record, reports the District Employment Start Date. | M | District Employment > Start Date employmentassignment.StartDate |
| educationOrganizationReference | A reference to the related EducationOrganization resource. DESE assigned 6 digit district code where the educator is being reported from where the educationOrganizationId is the Reporting District Code. | M | District Information > State District Number |
| staffReference | A reference to the related Staff resource. Reports the fields that are part of the Natural Key for the Staffs resource where the staffUniqueId is the Staff SSN. | M |
