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. |
Staff must meet the following conditions to report:
| |
| Staff member must be a Primary Teacher or Teacher with a Role mapped to an Ed-Fi Code. | |
| Do not send records if the Calendar Exclude check box is checked. | |
| Do not send a record if the Course is marked Inactive or Exclude. | |
| Do not report a record if the Staff does not have an Ed-Fi ID or an Email. | |
| Do not report if the course is in a school marked as exclude. | |
| Course must have a State Code is not nullL. | |
| Put | When Start or End dates are modified on the Staff History.
|
| 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 | 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. |
| M | ||
| staffReference | A reference to the related 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 OR System Administration> Calendar> Calendar> Terms | sectionstaffhistory.startdate OR employmentassignment.startdate OR term.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. NEDM: Ending Date. |
| 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. |
| O | ||
| percentage Contribution | The percentage of time the teacher is responsible for the student. |
| 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. |
| O | ||
_ext.tdoe.submittedFor SchoolYearTypeReference. schoolYear | The key for School Year | Use the School Year tied to the configured year to identify the End Year. | M | System Administration > Ed-Fi > Ed-Fi Configuration > Connection > School Year | SchoolYear.endYear |
_ext.tdoe.submittedByEducation OrganizationReference.education OgranizationID | The identifier assigned to an education organization. | Reports State District Number + State School Number. Note: Leading zeros are included to complete 7 character code. | M | System Administration > Resources > School
| School.number
|
| etag | A unique system-generated value that identifies the version of the resource. | O |
