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. Must have a Staff Type of P: Primary Teacher or T: Teacher in the Section Staff History Table. Does not send records when the Calendar Exclude check box is marked. Does not send a record when the Course is not marked Active or is marked Exclude from State Reporting. Does not report a record when the Staff does not have an Ed-Fi ID. Does not report when the course is in a school marked as Exclude. Does not report a record when the Staff's District Assignment record for the reporting School does not overlap the scope year in which the section is aligned.
Put	When Start or End dates are modified on the Staff History record.
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.

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 is send.
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 is needed 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.

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
Classroom Position Descriptor	Teacher Role

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 Rules and Requirements	Mandatory, Conditional or Optional	Location
sectionReference	A reference to the related Section resource. Reports the data that is part of the Natural Key for the Section resource. For the Term(s) reported, the sessionName associated with the mapped Ed-Fi Code value using the Kansas sessionName Translation table (see below) is sent.	M
staffReference	A reference to the related Staff resource. Reports the data that is part of the Natural Key for the Staff resource. The Ed-Fi ID reports from the Staff State ID field.	M
beginDate	Reports the 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. Reports the Staff History Start date when populated. When blank, looks to the District Assignment record for the teacher for that School and report Assignment Start Date 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 the District Assignment Start Date is Prior to the lowest Term Start Date, reports the lowest Term Start Date for that section that is associated with the term descriptor selected for the section based on section schedule placement. When the teacher has more than one District Assignment record that overlaps the section, reports the Start Date from the most recent District Assignment record 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 the District Assignment Start Date is prior to the lowest Term Start date, reports the lowest term Start date for that section that is associated with the term descriptor selected for the section based on section schedule placement.	M	Staff History > Start Date sectionstaffhistory.startdate District Assignment > Start Date employmentassignment.startdate Term Setup > Start Date term.startdate
classroomPositionDescriptor	A unique identifier used as Primary Key. Reports the Ed-Fi Code value for the Teacher of Record.	M	Section Staff History > Role sectionstaffhistory.role
endDate	Reports the month, day and year of the last day of a teacher''s assignment to the section. NEDM: Ending Date. Reports the Staff History End Date if populated When blank, looks to the District Assignment record for the teacher for that School and report Assignment End Date 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, report sthe Term End Date for that section that is associated with the term descriptor selected for the section based on section schedule placement. When the teacher has more than one District Assignment record that overlaps the section, reports the End Date from the most Recent District Assignment record 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, reports the Term End Date for that section that is associated with the term descriptor selected for the section based on section schedule placement.	O	Section Staff History > End Date sectionstaffhistory.enddate 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 and does not report.	O
percentageContribution	The percentage of time the teacher is responsible for the student. This is optional and does not report.	O
TeacherStudentDateLinkExclusion	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 and does not report.	O

Kansas Session Name Translation Table

Code Value	Session Name
Q1	SchoolYear.endYear + ' Quarter 1'
Q2	SchoolYear.endYear + ' Quarter 2'
Q3	SchoolYear.endYear + ' Quarter 3'
Q4	SchoolYear.endYear + ' Quarter 4'
S1	SchoolYear.endYear + ' First Semester'
S2	SchoolYear.endYear +' Second Semester'
SM	'Summer'
T1	SchoolYear.endYear + ' Trimester 1'
T2	SchoolYear.endYear + ' Trimester 2'
T3	SchoolYear.endYear + ' Trimester 3'
YR	SchoolYear.endYear +' School Year'

Descriptors

Classroom Position Descriptor

Click here to expand...

Ed-Fi Code	Ed-Fi Short Description	Namespace	Ed-Fi Description
Assistant Teacher	Assistant Teacher	uri://ed-fi.org/ClassroomPositionDescriptor	Assistant Teacher
Substitute Teacher	Substitute Teacher	uri://ed-fi.org/ClassroomPositionDescriptor	Substitute Teacher
Support Teacher	Support Teacher	uri://ed-fi.org/ClassroomPositionDescriptor	Support Teacher
Teacher of Record	Teacher of Record	uri://ed-fi.org/ClassroomPositionDescriptor	Teacher of Record

Staff Section Association (Kansas v3.6)