Indiana Ed-Fi Data v2.4/3.1 - Staff Section Associations

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. Must have a Staff Type of P: Primary Teacher OR T: Teacher in the Section Staff History Table with a Role. 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. Must have a role mapped to an Ed-Fi code populated to report. Do not report a record if the Staff does not have an Ed-Fi ID. Do not report if the course is in a school marked as exclude. Do not report a record if the Staff's District Assignment record for the reporting School does not overlap the scope year to which the section is aligned. Do not report a record if Role = 'EX: Exclude From Reporting'. Only send a record for sections in which staff have an overlapping section staff history record: Only post for session names where the start date of the term is on or before the section staff history end date or the section staff history end date is null. Only post for session names where the end date of the term is on or after the section staff history start date or the section staff history start date is null.
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. When Section data is changed.
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.

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

Identity Mapping Object Key

campusObjectType	Object Key Data Source
SectionStaffHistory	personID-SectionID-TermID

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.
sectionPlacement	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
course	Post/Delete	Active

Object Data Elements

This table describes data elements sent within the Staff Section Association resource. Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.

Data Element Label	Business Requirement	Business Rules	M, C or O	Location
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.	Reports the Ed-Fi Code from the Role that is selected. Report default value if selected. Does not report if Role is blank. Does not report if Role is 'EX: Exclude From Reporting'. See Descriptors section for list of Descriptors that will report.	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.	Reports the Staff History End Date if populated: If blank, looks at the District Assignment record for the teacher for that School and reports 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. 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. If the teacher has more than 1 District Assignment record that overlaps the section, reports 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. 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.	C	Course > Section > Staff History > End Date OR Census > People > District Assignment > End Date OR System Administration > Calendar > Calendar > Terms sectionstaffhistory.enddate OR employmentassignment.enddate OR term.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

Descriptors

Click here to expand...

Classroom Position Descriptors

Code Value	Description	Namespace	Short Description
0	Not a special education or EL teacher	http://doe.in.gov/Descriptor/ClassroomPositionDescriptor.xml	Not a special education or EL teacher
4	The special education teacher works within the general education setting in which a general education teacher provides instruction to the class on Core Academic Subjects. The special education teacher provides direct assistance to the students with disability.	http://doe.in.gov/Descriptor/ClassroomPositionDescriptor.xml	Co-Teacher
5	The special education teacher provides consultation (e.g., adapts curricula, uses behavioral supports and interventions, and selects appropriate accommodations) to general education teachers of Core Academic subjects.	http://doe.in.gov/Descriptor/ClassroomPositionDescriptor.xml	Consultant Teacher
6	The special education teacher provides direct assistance to students with disabilities (e.g., tutoring, reinforcement of content provided in general education setting) in segregated settings (e.g., resource class setting, self-contained classroom) after s	http://doe.in.gov/Descriptor/ClassroomPositionDescriptor.xml	Resource Room Teacher
8	The special education teacher is the primary teacher providing instruction to the student in the core academic elementary subjects. They also provide direct instruction to students with disabilities on non-core academic subjects (e.g., life skills, study skills, community-based instruction).	http://doe.in.gov/Descriptor/ClassroomPositionDescriptor.xml	Primary Special Education Teacher
EL Co-Teacher	EL Teacher who co-teaches with another teacher, sharing same responsibilities and providing direct assistance to EL students.	http://doe.in.gov/Descriptor/ClassroomPositionDescriptor.xml	EL Co-Teacher
EL Consultant Teacher	EL Teacher who consults with classroom teacher in assisting with curricula support for EL students.	http://doe.in.gov/Descriptor/ClassroomPositionDescriptor.xml	EL Consultant Teacher
EL Primary Teacher	EL Teacher of Record who meets EL licensure requirements by either obtaining an EL license or having met the EL Teacher of Record Rubric.	http://doe.in.gov/Descriptor/ClassroomPositionDescriptor.xml	EL Primary Teacher
EL Resource Teacher	EL Teacher who does not act as a Teacher of Record, but does provide direct EL services to students; may be known as EL Teacher of Service.	http://doe.in.gov/Descriptor/ClassroomPositionDescriptor.xml	EL Resource Teacher

Term Descriptor

Code value	Description	Name Space	Short Description
Fall Semester	Fall Semester	http://doe.in.gov/Descriptor/TermDescriptor.xml	Fall Semester
First Quarter	First Quarter	http://doe.in.gov/Descriptor/TermDescriptor.xml	First Quarter
First Trimester	First Trimester	http://doe.in.gov/Descriptor/TermDescriptor.xml	First Trimester
Fourth Quarter	Fourth Quarter	http://doe.in.gov/Descriptor/TermDescriptor.xml	Fourth Quarter
MiniTerm	MiniTerm	http://doe.in.gov/Descriptor/TermDescriptor.xml	MiniTerm
Other	Other	http://doe.in.gov/Descriptor/TermDescriptor.xml	Other
Second Quarter	Second Quarter	http://doe.in.gov/Descriptor/TermDescriptor.xml	Second Quarter
Second Trimester	Second Trimester	http://doe.in.gov/Descriptor/TermDescriptor.xml	Second Trimester
Spring Semester	Spring Semester	http://doe.in.gov/Descriptor/TermDescriptor.xml	Spring Semester
Summer Semester	Summer Semester	http://doe.in.gov/Descriptor/TermDescriptor.xml	Summer Semester
Third Quarter	Third Quarter	http://doe.in.gov/Descriptor/TermDescriptor.xml	Third Quarter
Third Trimester	Third Trimester	http://doe.in.gov/Descriptor/TermDescriptor.xml	Third Trimester
Year Round	Year Round	http://doe.in.gov/Descriptor/TermDescriptor.xml	Year Round

References

Data Element	Business Requirement	Business Rules	M, C or O
Section Reference	The Section reference for this resource reports the following details: SchoolID classPeriodName classroomIdentificationCode localCourseCode termDescriptor schoolYear uniqueSectionCode sequenceOfCourse One record per section.	SchoolID Report as 10+District+School classPeroidName Report period name classroomIdentificationCode Report the room number of the classroom. Report the first one entered if more than one. localCourseCode Report the courseNumber termDescriptor Report the termDescriptor from the mapping tool SchoolYear reports endyear as 'YYYY'. uniqueSectionCode reports as sectionID sequenceOfCourse Report 1 on all sectionReferences	M
Staff Reference	The Staff Reference in this resource reports the following details: Staff Unique ID	Reports the Ed-Fi ID of the teacher marked as Primary Teacher in the course/section. If more than one teacher, and one is Primary, report Primary. If more than one and none are marked as Primary, report one marked as teacher of record. If more than one and both marked as teacher of record, report the one with the earliest start date. If more than one and none are marked teacher of record or Primary teacher, report teacher with the earliest start date.	M

Data Element

Business Requirement

Business Rules

M, C or O

Section Reference

The Section reference for this resource reports the following details:

SchoolID
classPeriodName
classroomIdentificationCode
localCourseCode
termDescriptor
schoolYear
uniqueSectionCode
sequenceOfCourse

One record per section.

SchoolID
- Report as 10+District+School
classPeroidName
- Report period name
classroomIdentificationCode
- Report the room number of the classroom. Report the first one entered if more than one.
localCourseCode
- Report the courseNumber
termDescriptor
- Report the termDescriptor from the mapping tool
SchoolYear
- reports endyear as 'YYYY'.
uniqueSectionCode
- reports as sectionID
sequenceOfCourse
- Report 1 on all sectionReferences

Staff Reference

The Staff Reference in this resource reports the following details:

Staff Unique ID

Reports the Ed-Fi ID of the teacher marked as Primary Teacher in the course/section.

If more than one teacher, and one is Primary, report Primary.
If more than one and none are marked as Primary, report one marked as teacher of record.
If more than one and both marked as teacher of record, report the one with the earliest start date.
If more than one and none are marked teacher of record or Primary teacher, report teacher with the earliest start date.