Tennessee Ed-Fi Data v3.1 - Staff Section Association

Classic View: System Administration > Ed-Fi

Search Terms: 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: Have a District Assignment record with Assignment Code is not null. Assignment must overlap the configured scope year. Staff member has an Ed-Fi ID is not null. Staff member has an Email Address is not null.
	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. 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, a resync must be completed to have all the records update
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. Data will only send for years that have valid configuration.

Logic

Reports for Sections in the scope year to which the course's calendar is aligned.

Data will only send 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	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.	Report the Staff History Start date if populated: If Blank, look at the District Assignment record for the teacher for that School and report Assignment Start Date if 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. If District Assignment Start Date is Prior to the lowest Term Start Date, report the lowest Term Start Date for that section that is associated with the term descriptor selected for the section based on section schedule placement. If the teacher has more than 1 District Assignment record that overlaps the section, report the Start Date from the most recent District Assignment record if 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. If the District Assignment Start Date is prior to the lowest Term Start date, report 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	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.	Primary Teacher - Reports 'Teacher of Record'. Teachers - Reports mapped Ed-Fi Code of Role.	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.	Report the Staff History End Date if populated: If Blank, look at the District Assignment record for the teacher for that School and report Assignment End Date if 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. Else, Report the Term End Date for that section that is associated with the term descriptor selected for the section based on section schedule placement. If the teacher has more than 1 District Assignment record that overlaps the section, report the End Date from the most Recent District Assignment record if 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. Else, Report the Term End Date for that section that is associated with the term descriptor selected for the section based on section schedule placement.	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
_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 System Administration > Resources > District Information	School.number district.number
etag	A unique system-generated value that identifies the version of the resource.		O

Type/Descriptors

Classroom Position Descriptors

Code Value	Description	Namespace	Short 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