Tool Search: Ed-Fi

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 that overlaps the configured year with the District Staff checkbox marked and a District Assignment Code populated. OR When a person has a District Assignment record that overlaps the configured year. Does NOT report a record when any one of the following scenarios are true: There is not an Ed-FI ID for the staff person. 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. When the Assignment Code field is not mapped in Resource Preferences. When the school staff member has more than one qualifying District Assignment record, a record generates for each eligible School/Start date.
Put	When any field not part of the natural key changes: End Date
Delete/Post	When any field part of the natural key changes: Begin Date Staff Classification Descriptor
Delete/Post	When there are two District Assignment records that create the same natural Key and one is Deleted, the remaining record is 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	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.

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: When the School ID changes, all data remains under the old number and a resync needs to be completed to populate data under the new number. The delete tool needs to be used to remove all data from the old School ID. When an Ed-Fi ID changes, this happens with the cascading deletes from the Ed-Fi ID Change trigger.
Delete/Post	The logic for an Ed-FI ID change updates all resources impacted by this change.
Delete/Post	When the Start Date or Assignment Code changes, the record deletes and re-posts.
Delete/Post	Cascading Updates: The Staff Education Organization Assignment Association establishes ownership of the Staff record. When the natural key changes all dependent resources of staff deletes/posts. Staff Education Organization Employment Associations, Staff School Associations, Staff Section Associations, Staff Cohort Associations

Scope Year Logic

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.
When using data in Campus that has an effective date, the following logic is applied to determine the scope year(s) to report the data to. Current Year: Records are compared to today's date to determine the eligibility of the record to report. Previous Years: The record's date must be on or before the schools year's end date defined in the School Years editor. When blank, the default date of 6/30/xxxx is used. Future Years: The record's date must be on or after the schools year's start date defined in the School Years editor. When blank, the default date of 7/01/xxxx is used.

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.

When using data in Campus that has an effective date, the following logic is applied to determine the scope year(s) to report the data to.

Current Year: Records are compared to today's date to determine the eligibility of the record to report.
Previous Years: The record's date must be on or before the schools year's end date defined in the School Years editor. When blank, the default date of 6/30/xxxx is used.
Future Years: The record's date must be on or after the schools year's start date defined in the School Years editor. When blank, the default date of 7/01/xxxx is used.

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

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	Description	M, C, or O	Database Location
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. Passes the effective date of a staff member's employment, contract, or relationship with the LEA.	M	District Employment > Start Date District Assignment > Start Date employment.startDate employmentassignment.StartDate
staffClassificationDescriptor	The titles of employment, official status, or rank of education staff Reports selected Assignment Code. When Assignment Code is null, reports as 60.	M	District Assignments > Employment Assignment Information > Assignment Code employment.assignmentCode employmentassignment.assignmentCode
educationOrganizationReference	A reference to the related EducationOrganization resource. DESE assigned 4 digit school code where the educator is being reported from where the educationOrganizationId is the Reporting School Code.	M	District Employment District Assignment
staffReference	A reference to the related Staff resource. Reports the fields that are part of the Natural Key for the Staffs resource where the staffUniqueId is the Staff SSN.	M	Demographics > Local Staff Number
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 Assignment record, reports the District Assignment End Date. When null, this does not report.	O	District Assignment > End Date employment.endDate employmentassignment.endDate

Type/Descriptor

Click here to expand...

Staff Classification Descriptors

The District Assignment Code from the District Employment tool and the Assignment Code from the District Assignment tool is a shared Data Dictionary that is an unlocked list that is managed by the districts.

To create a new or modify an existing Assignment Code go to Attribute/Dictionary > Employment Assignment > Assignment Code.

Ed-Fi Code Value	Short Description	Namespace	Description
10	Central Office Administration	uri://dese.mo.gov/StaffClassificationDescriptor	Central Office Administration
20	Building Principals	uri://dese.mo.gov/StaffClassificationDescriptor	Building Principals
30	Supervisors	uri://dese.mo.gov/StaffClassificationDescriptor	Supervisors
40	Media Personnel	uri://dese.mo.gov/StaffClassificationDescriptor	Media Personnel
50	Guidance Personnel/Placement Specialists	uri://dese.mo.gov/StaffClassificationDescriptor	Guidance Personnel/Placement Specialists
60	Teachers	uri://dese.mo.gov/StaffClassificationDescriptor	Teachers
70	Other Pupil Services Personnel	uri://dese.mo.gov/StaffClassificationDescriptor	Other Pupil Services Personnel
80	Aides	uri://dese.mo.gov/StaffClassificationDescriptor	Aides
90	Ancillary Personnel	uri://dese.mo.gov/StaffClassificationDescriptor	Ancillary Personnel

Staff Education Organization Assignment Association (Missouri v3.6)

Object Triggering Logic

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

Natural Key Changes, Cascading Updates, and Deletes Logic

Scope Year Logic

Resource Preferences

Event Queue Detail

Object Data Elements

Type/Descriptor

Staff Classification Descriptors

Related Articles