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 that is mapped to an Ed-Fi Code. OR When a person has a District Assignment record that overlaps the configured year with a Title populated that is mapped to an Ed-Fi Code. Do NOT report a record if any one of the following scenarios are true:
If school staff member has more than 1 qualifying District Assignment record, a record will generate for each eligible School/Start date. If a staff member has a District Employment record that is marked as District Staff and a District Assignment record, the staff member will get multiple records. One with an Ed Org Reference Number = to the District Number and one with an Ed Org Reference Number = to each school in which they have an eligible District Assignment record. |
| Put | When any field not part of the natural key changes:
|
| 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. |
| 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 re-post. |
| 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 |
Identity Mapping Object Key
| campusObjectType | Object Key Data Source |
|---|---|
| Employment | employmentID |
| EmploymentAssignment | assignmentID |
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 |
| staffClassification Descriptor | 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 | 10+DistrictID+SchoolID | district.stateDistrictNumber and school.stateSchoolNumber |
| StaffEducation OrganizationEmployment AssociationReference | 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 |
