This association indicates the education organization to which a staff member provides services; also known as school of service.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When a person has a District Employment record with the District Staff check box checked and a District Assignment Code populated OR When a person has a District Assignment record and the District Staff check box is not checked
|
| Put | When any field not part of the natural key changes:
|
| Put | 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. |
| Delete | When a District Employment 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 |
|---|---|
| Delete/Post | Natural Key change:
|
| Delete/Post | The logic for an Ed-FI ID change will update all resources impacted by this change. |
| Delete/Post | If the Start Date or Assignment Code changes, the record will delete and repost. |
| Delete/Post | Cascading Updates: The Staff Education Organization Assignment Association establishes ownership of the Staff record. If the natural key changes all dependent resources of staff will delete/post.
|
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.
|
When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to.
|
Resource Preferences
This table describes the Resource Preferences of this object.
| Data Element Label | Mapping Needed |
|---|---|
| Staff Classification Descriptors | Employment District Assignment Code EmploymentAssignment Assignment Code |
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 | Business Requirement | M, C or O | Data Source GUI Path Database Field |
|---|---|---|---|
id | The unique identifier of the resource. | M | |
| beginDate | Month, day and year of the start or effective date of a staff member''s employment, contract or relationship with the LEA. When reporting from the District Employment record, report the District Employment Start Date. When reporting from the District Assignment record, report the District Assignment Start Date. | M | Census> People> District Employment> Start Date Census> People> District Assignment> Start Date employment.startDate employmentassignment.StartDate |
| staffClassificationDescriptor | The titles of employment, official status, or rank of education staff. Report the Ed-Fi code mapped to the value selected: If reporting from District Employment, report the Ed-Fi Code mapped to the District Assignment Code selected. If reporting from District Assignment, report the Ed-Fi Code mapped to the Assignment Code selected. If District Assignment is NULL, report 2. | M | Census> People> District Employment> District Assignment Code Census> People> District Assignment> Assignment Code employment.assignmentCode employmentassignment.assignmentCode |
| credentialReference | This is optional, does not report. | O | |
| educationOrganization Reference | A reference to the related EducationOrganization resource. First look to District Employment > District Staff. If the checkbox is checked, report staff with the District Number. If the District Staff checkbox is not checked, report the State School Number. | M | |
| StaffEducationOrganization EmploymentAssociation Reference | A reference to the related Staff Education Organization Employment Association resource. Reports the data that is part of the Natural Key for the Staff Education Organization Employment Association. | O | |
| staffReference | A reference to the related Staff resource. Reports the data that is part of the Natural Key for the Staff resource. | M | |
| endDate | Month, day and year of the end or termination date of a staff member''s employment, contract or relationship with the LEA. When reporting from the District Employment record, report the District Employment End Date.
| O | Census> People> District Assignment> End Date employment.endDate employmentassignment.endDate |
| orderOfAssignment | Describes whether the assignment is this the staff member's primary assignment, secondary assignment. This is optional, do not report. | O | |
| positionTitle | The descriptive name of an individual's position. When reporting from the District Employment record, report the name from the District Assignment Code selected. When reporting from the District Assignment record, report the name from the Assignment Code selected. If District Assignment = NULL, report Teacher. | O | Census> People> District Employment> District Assignment Code Census> People> District Assignment> Assignment Code employment.assignmentCode employmentassignment.assignmentCode |
| _etag | A unique system-generated value that identifies the version of the resource. | O |
