ToolSearch: 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.
|
| Delete/Post | When any field 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 | 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 . Report 'Regular Education' if the Teacher checkbox is checked. Report' Special Education' if the Special Ed checkbox is checked. Else, report 'Other'. | 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. Do not report, this is optional. | O | |
| schoolReference | A reference to the related Education Organization resource. Reports the data that is part of the Natural Key for the Schools resource. | M | |
| schoolYearTypeReference | Identifier for a school year. Report the calendar End Year (ex: 2017). | O | |
| staffReference | A reference to the related Staff resource. Reports the data that is part of the Natural Key for the Staff resource. | M | |
| academicSubjects | An unordered collection of staffSchoolAssociationAcademicSubjects. This association indicates the school(s) to which a teacher provides instructional services. Do not report, this is optional. | O | |
| gradeLevels | An unordered collection of staffSchoolAssociationGradeLevels. This association indicates the school(s) to which a teacher provides instructional services. Do not report, this is optional. | O | |
| _etag | A unique system-generated value that identifies the version of the resource. | O |
