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. |
| Post | When students are added to a reportable section with a teacher. |
| Put | When Start or End dates are modified on the Staff History. |
| Post/Delete | If 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. |
| Delete | If an end date is added on Section Staff History that ends the teacher record before the section reference start date. |
| Delete | When staff Role is changed to XX: Not State Reported. |
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 changes: The natural key logic from Sections and Staffs will update this resource if 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.
|
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 | Business Requirement | Business Rules | M, C or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|---|
| id | The unique identifier of the resource. | M | |||
| sectionReference | A reference to the related Section resource. | Reports the data that is part of the Natural Key for the Section resource. | M | ||
| staffReference | A reference to the related Staff resource. | Reports the data that is part of the Natural Key for the Staff resource. | M | ||
| beginDate | Month, day and year of a teacher''s assignment to the section. If blank, defaults to the first day of the first grading period for the section. |
| M | Course> Section> Staff History> Start Date OR Census> People> District Assignment> Start Date | sectionstaffhistory.startdate OR employmentassignment. startdate |
| classroom PositionDescriptor | A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. |
| M | Course> Section> Staff History> Role | sectionstaffhistory.role |
| endDate | Month, day and year of the last day of a teacher''s assignment to the section. |
| O | Course> Section> Staff History> End Date OR Census> People> District Assignment> End Date | sectionstaffhistory.enddate OR 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 | ||
| percentage Contribution | The percentage of time the teacher is responsible for the student. | This is optional, does not report. | O | ||
| teacher Student DataLinkExclusion | 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 | ||
| etag | A unique system-generated value that identifies the version of the resource. | O |
