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 | N/A, a delete and insert occurs when any field is edited and saved. |
| Delete/Post | When the person’s employment assignment record is changed. |
| Delete/Post | When the person’s employment record is changed |
| 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/Post | When the Assignment Code, Start Date or End date is modified on the District Assignment record. |
| Delete | When a District Assignment record is deleted. |
| Delete | When a District Employment record is deleted. |
| Delete | When a District Employment record > District Staff is unchecked AND no district assignment exists for the staff. |
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 | Business Rules | 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. |
| 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:
| M | Census> People> District Employment> District Assignment Code Census> People> District Assignment> Assignment Code | employment.assignmentCode employmentassignment. assignmentCode |
| credentialReference |
| O | |||
| educationOrganization Reference | A reference to the related EducationOrganization resource. |
| M | ||
| StaffEducationOrganization EmploymentAssociation Reference | A reference to the related Staff Education Organization Employment Association resource. |
| O | ||
| staffReference | A reference to the related 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. |
| 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. |
| O | ||
| positionTitle | The descriptive name of an individual''s position. |
| 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 |
