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 | 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. |
| 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 | 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. |
| 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 | ||
etag | A unique system-generated value that identifies the version of the resource. | O |