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. Does not report when any of the following scenarios are true: There is not an Ed-FI ID for the staff person. The District Assignment records are not active based on the Scope Year logic listed below. When the record is triggered from a District Assignment record and it is marked as Exclude. When the record is triggered from a District Assignment record and the School is marked as Exclude. When data is sent prior to the Exclude checkboxes are marked, the data remains and the user needs to use the Delete Tool to remove data.
Put	When any field not part of the natural key changes.
Delete/Post	When any part of the Natural Key changes: programAssignmentDescriptor
Delete/Post	When there are two District Assignment records that create the same natural Key and 1 is Deleted, the remaining record is 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	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.

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

Action	Trigger
Post/Delete	Natural Key changes: When the School Number/Ed-Fi School Number changes or the Ed-Fi ID changes, a delete/post occurs with the cascading deletes from the School ID/Ed-Fi ID Change triggers. programAssignmentDescriptor
Delete	N/A - there are no dependent resources.

Action

Trigger

Post/Delete

Natural Key changes:

When the School Number/Ed-Fi School Number changes or the Ed-Fi ID changes, a delete/post occurs with the cascading deletes from the School ID/Ed-Fi ID Change triggers.
programAssignmentDescriptor

Delete

N/A - there are no dependent resources.

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.
Reports when a staff has an active District Assignment or District Employment record that overlaps with the School year Start and End Dates When School Year Start Date is NULL, 7/1/xxxx is the default start date used. When School Year End Date is NULL, 6/30/xxxx is the default end date used.
Data only sends for the years that have valid configuration

Logic

A record reports when a person has a District Assignment or District Employment record that is aligned to a scoped year.

Reports when a staff has an active District Assignment or District Employment record that overlaps with the School year Start and End Dates

Data only sends for the years that have valid configuration

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.

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
programAssignmentDescriptor	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 Reports as Regular Education when the Teacher checkbox is marked. Reports as Special Education when the Special Ed checkbox is marked. Otherwise, reports as 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. Reports the fields that are part of the Natural Key for the Calendar resource where the schoolID is the Reporting School and the schoolYear is the end year of the calendar.	M
schoolReference	A reference to the related Education Organization resource. Reports the data that is part of the Natural Key for the Schools resource where the schoolID is the Reporting School.	M
staffReference	A reference to the related Staff resource. Reports the data that is part of the Natural Key for the Staff resource where the staffUniqueID is the Primary Teacher SSN.	M

Click here to expand...

Ed-Fi Code	Ed-Fi Short Description	Namespace	Ed-Fi Description
Regular Education	Regular Education	uri://dese.mo.gov/ProgramAssignmentDescriptor	Regular Education