Nebraska Ed-Fi Data v3.5 - Staff School Associations
Last Modified on 10/22/2022 10:30 am CDT
Classic View: System Administration > Ed-Fi
Search Terms: 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.
Do not report if 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.
If the record is being triggered from a District Assignment record and it is marked as Exclude.
If the record is being triggered from a District Assignment record and the School is marked as Exclude.
If data is sent prior to the Exclude check boxes are checked, the data will remain and the user will need to use the Delete Tool to remove data.
Put
When any field not part of the natural key changes:
academicSubjects
gradeLevels
Delete/Post
If any part of the Natural Key changes:
programAssignmentDescriptor
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.
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
Post/Delete
Natural Key changes:
If the School Number/Ed-Fi School Number changes or the Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the School ID/Ed-Fi ID Change triggers.
programAssignmentDescriptor
Delete
Cascading Deletes: N/A - there are no dependent resources.
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.
Report when a staff has an active District Assignment or District Employment record that overlaps with the School year Start and End Dates
If School Year Start Date is NULL, 7/1/xxxx will be the default start date used.
If School Year End Date is NULL, 6/30/xxxx will be the default end date used.
Data will only send for the years that have valid configuration
Event Queue Detail
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.
Object Data Elements
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
Business Rules
M, C or O
Data Source GUI Path
Database Field
id
The unique identifier of the resource.
M
programAssignment Descriptor
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 .
Report 'Regular Education' if the Teacher checkbox is checked.
Report' Special Education' if the Special Ed checkbox is checked.
Else, report '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.
This is optional, does not report.
O
schoolReference
A reference to the related Education Organization resource.
Reports the data that is part of the Natural Key for the Schools resource.
M
schoolYearTypeReference
Identifier for a school year.
Report the calendar End Year (ex: 2017).
O
staffReference
A reference to the related Staff resource.
Reports the data that is part of the Natural Key for the Staff resource.
M
academicSubjects
An unordered collection of staffSchoolAssociationAcademicSubjects. This association indicates the school(s) to which a teacher provides instructional services.
See Array section below for logic.
O
gradeLevels
An unordered collection of staffSchoolAssociationGradeLevels. This association indicates the school(s) to which a teacher provides instructional services.
See Array section below for logic.
O
_etag
A unique system-generated value that identifies the version of the resource.
O
Arrays
Academic Subject
Data Element Label
Business Requirement
Business Rules
M, C or O
Data Source GUI Path
Database Field
academicSubjectDescriptor
Key for academicSubject.
Report the Ed-Fi Code from the Primary Teaching Area field.
If Ed-Fi Code is NULL or field is blank, do not report.
M
Census> People> District Assignments> Primary Teaching Area
employmentassignment. primaryTeachingArea
Grade Levels
Data Element Label
Business Requirement
Business Rules
M, C or O
Data Source GUI Path
Database Field
gradeLevelDescriptor
Key for gradeLevels.
Report the Ed-Fi Code from the Grade selected.
If Ed-Fi Code is NULL or field is blank, do not report.
