Tool Search: Ed-Fi
This association indicates the course sections to which a staff is assigned.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When a staff is added to a course section on Staff History.
|
| Post | When a Role mapped to an Ed-Fi code is added to an existing teacher on the Staff History Record. |
| Put | When Start or End dates are modified on the Staff History. |
| Post/Delete | When the start or end dates are modified on the District Assignment record or the District Assignment record is deleted or added and the staff is still aligned to the section. |
| Delete | When a staff member is deleted from Staff History. |
| Delete | When a Role is removed from a Teacher on Staff History |
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 changes: The natural key logic from Sections and Staffs updates this resource when they change. |
Scope Year Logic
This table describes scope year logic of this object.
| Logic |
|---|
Reports for Sections in the scope year to which the course's calendar is aligned. Data only sends for years that have valid configuration. |
Resource Preferences
Data Element Label | Mapping Needed |
|---|---|
| Teacher Role | Classroom Position Descriptor |
Event Queue Detail
This table describes the Event Queue Detail of this object.
| Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| sectionstaffhistory | Post/Put/Delete | The primary table used for sending data for this resource. |
| employmentassignment | Put | Begin Date, End date |
| term | Put | Begin Date, End Date |
| sectionstaffhistory | Put | Begin Date, Role, End Date |
Object Data Elements
This table describes data elements sent within the Staff Section Association resource.
Data Element Label | Description and Business Rules | M, C or O | Data Source GUI Path AND Database Field |
|---|---|---|---|
| id | The unique identifier of the resource. | M | Not stored |
| sectionReference | A reference to the related Section resource. Reports the data that is part of the Natural Key for the Section resource. | M | Not stored |
| staffReference | A reference to the related Staff resource. Reports the data that is part of the Natural Key for the Staff resource
| M | Section > Staff History > Primary Teacher sectionstaffhistory.staffType |
| beginDate | Month, day and year of a teacher's assignment to the section. When blank, defaults to the first day of the first grading period for the section. Report the Staff History Start date when populated. When blank, the Assignment Start Date reports from the District Assignment record for the teacher for that School when it is on or after the lowest Term Start Date and on or before the highest Term End Date for that section that is associated with the term descriptor selected for the section based on section schedule placement. When District Assignment Start Date is prior to the lowest Term Start Date, the lowest Term Start Date for that section that is associated with the term descriptor selected for the section based on section schedule placement reports. When the District Assignment Start Date is prior to the lowest Term Start date, the lowest term Start date for that section that is associated with the term descriptor selected for the section based on section schedule placement reports. | M | Course > Section > Staff History > Start Date sectionstaffhistory.startdate Census> People> District Assignment> Start Date employmentassignment.startdate System Administration> Calendar> Calendar> Terms term.startdate |
| classroomPositionDescriptor | A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. One record reports per course section for teachers with a role of Teacher of Record with the following priority:
For all other roles, the Ed-Fi Code value from the role selected reports.
| M | Course > Section > Staff History > Staff History Detail > Teacher Role sectionstaffhistory.role sectionstaffhistory.staffType |
| endDate | The last day of a teacher's assignment to the section. Reports the Staff History End Date when populated. When Blank, the Assignment End Date reports from the District Assignment record for the teacher for that School when it is on or after the lowest Term Start Date and on or before the highest Term End Date for that section that is associated with the term descriptor selected for the section based on section schedule placement. Otherwise, the Term End Date for that section that is associated with the term descriptor selected for the section based on section schedule placement reports. Otherwise, the Term End Date for that section that is associated with the term descriptor selected for the section based on section schedule placement reports. | O | Course > Section > Staff History > End Date sectionstaffhistory.enddate Census > People > District Assignment > End Date employmentassignment.enddate |
| highlyQualifiedTeacher | An indication of whether a teacher is classified as highly qualified for his/her assignment according to state definition. This attribute indicates the teacher is highly qualified for this section being taught. This is optional, does not report. | O | Not stored |
| percentageContribution | The percentage of time the teacher is responsible for the student. This is optional, does not report. | O | Not stored |
| teacherStudentDataLinkExclusion | Indicates that the student-section combination is excluded from calculation of value-added or growth attribution calculations used for a particular teacher evaluation. This is optional, does not report. | O | Not stored |
| etag | A unique system-generated value that identifies the version of the resource. | O | Not stored |
