Tool Search: Ed-Fi
This association indicates the school(s) to which a teacher provides instructional services.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When a District Assignment record is created or changed and saved for a staff member. Do not report if any of the following scenarios are true:
|
| Put | When any field not part of the natural key changes:
|
| Delete/Post | If any part of the Natural Key changes:
|
| Delete/Post | If there are two District Assignment records that create the same natural Key and 1 is Deleted, the remaining record will be posted. |
| Delete | When a District Assignment record is deleted. |
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 | If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send. |
| Resync | If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table. |
| Resync | If a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS. |
| Resync | If a mapping is changed in Resource Preferences, a resync will need 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 |
|---|---|
| Post/Delete | Natural Key changes:
|
| Delete | Cascading Deletes: N/A - there are no dependent resources. |
Scope Year Logic
This table describes scope year logic of this object.
| Logic |
|---|
A record will report when a person has a District Assignment or District Employment record that is aligned to a scoped year. |
Report when a staff has an active District Assignment or District Employment record that overlaps with the School year Start and End Dates
|
| Data will only send for the years that have valid configuration. |
Event Queue Detail
This table describes the Event Queue Detail of this object.
| Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| employmentassignment | Post/Put/Delete | The primary table used for sending data for this resource. |
Object Data Elements
Data Element Labels in bold are part of the Natural Key and are required data elements for data to send to Ed-Fi.
Data Element Label | Business Requirement | Business Rules | M, C or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|---|
id | The unique identifier of the resource. | M | |||
| programAssignment Descriptor | The name of the program for which the individual is assigned; for example: Regular education Title I-Academic Title I-Non-Academic Special Education Bilingual/English as a Second Language. |
| M | Census> People > District Assignment | employmentassignment. teacher employmentassignment. specialed employmentassignment. behavior employmentassignment. health employmentassignment. advisor employmentassignment. supervisor employmentassignment. foodservice employmentassignment. counselor |
| calendarReference | A reference to the related Calendar Resource. |
| O | ||
| schoolReference | A reference to the related Education Organization resource. |
| M | ||
| schoolYearType Reference | Identifier for a school year. |
| O | ||
| staffReference | A reference to the related Staff resource. |
| M | ||
| academicSubjects | An unordered collection of staffSchoolAssociationAcademicSubjects. This association indicates the school(s) to which a teacher provides instructional services. |
| O | ||
| gradeLevels | An unordered collection of staffSchoolAssociationGradeLevels. This association indicates the school(s) to which a teacher provides instructional services. |
| O | ||
| _etag | A unique system-generated value that identifies the version of the resource. | O |
