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 Staff History OR When a Section Student Detail record is created with a Course State Code Override and Staff exist in Staff History
Do not report a record if the any of the following exclusions are present:
Course is inactive (Active is unchecked)
Course State Exclude
Course State Code is NULL
Role selected is: "03: Exclude from State Reporting"
Role selected is not mapped to an Ed-Fi Code
Staff does not have a SSN
Staff's District Assignment record for the reporting School does not overlap the scope year the section is aligned to
Calendar Exclude
School Exclude
Staff Section Association records will exist for BOTH the original and override state codes (if entered).
Delete/Post/Put
A DELETE/POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.
When the following information on Staff History is changed:
Start Date
End Date
Teacher Role
When the following information on District Assignment is changed:
Start Date
End Date
When the following information is changed on Section Student Detail:
Course State Code Override
Delete
When the Staff History record is deleted.
When the Staff's District Assignment no longer overlaps the term dates for that specific Staff Section Association record.
When the Staff's Staff History dates no longer overlap the term dates for that specific Staff Section Association record.
When the Role is removed, set to "03: Exclude from State Reporting," or set to a value that is not mapped to an Ed-Fi Code.
When the Section Student Detail record that has a Course State Code Override is deleted.
When the Course State Code Override on a Section Student Detail record is changed or removed.
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.
Identity Mapping Object Key
Campus Object Type
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.
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 and Business Rules
M, C or O
Data Source GUI Path
Database Field
sectionReference
A reference to the related Section resource.
Reports the fields that are part of the Natural Key for the Sections resource.
M
N/A
N/A
staffReference
A reference to the related Staff resource.
Reports the fields that are part of the Natural Key for the Staffs resource.
M
N/A
N/A
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.
Reports the Staff History Start Date
Reports the latest of the Term Start Date or the District Assignment Start Date if the Staff History Start Date is NULL.
M
Course > Section > Staff History > Start Date
Census > People > District Assignment > Start Date
System Administration > Calendar > Calendar > Terms
SectionStaffHistory.startDate
EmploymentAssignment.startDate
Term.startDate
classroomPositionDescriptor
The type of position the Staff member holds in the specific class/section; for example: Teacher of Record, Assistant Teacher, Support Teacher, Substitute Teacher.
Do NOT report a record for anyone whose selected Role is 03: Exclude from State Reporting.
For Primary Teachers only:
Report Teacher of Record.
For Teachers only:
Report Gen Ed Support.
M
Section > Staff History > Type
SectionStaffHistory.staffType
endDate
Month, day and year of the last day of a teacher''s assignment to the section.
Reports the Staff History End Date
Reports the earliest of the Term End Date or the District Assignment End Date if the Staff History End Date is NULL.
M
Course > Section > Staff History > End Date
Census > People > District Assignment > End Date
System Administration > Calendar > Calendar > Terms
SectionStaffHistory.endDate
EmploymentAssignment.endDate
Term.endDate
staffServiceTypeDescriptor
Report ESOL if the selected Role is "04: ESOL Teacher."
Report EIP if the selected Role is "05: EIP Teacher."
Report Gifted if:
The state code of the associated course has a "2" in the first number after the decimal.
E.g. ##.2###### courses should report these staff members as "Gifted."
This DOES need to work for override course state codes as well.
The normal section could report the teacher as "Gen Ed Support," but the override may report them as "Gifted."
The selected Role is "06: Gifted Teacher."
Report Special Ed if:
The state code of the associated course has an "8" in the first number after the decimal.
E.g. ##.8###### courses should report these staff members as "Special Ed."
This DOES need to work for override course state codes as well.
The normal section could report the teacher as "Gen Ed Support," but the override may report them as "Special Ed."
The selected Role is one of the following:
"02: SPED Co-Teacher"
"07: SPED Collab Teacher"
"08: SPED Consult Teacher"
Report GaVS if the Social Security Number of the staff member is: 222222222.
Report Virtual if the Social Security Number of the staff member is: 333333333.
Report Software if the Social Security Number of the staff member is: 444444444.
Report Out of state teacher if the Social Security Number of the staff member is: 888888888.
Report In state teacher if the Social Security Number of the staff member is: 999999999.
Report Day Care Teacher if the Social Security Number of the staff member is: 616161616.
Report Short Term Sub if the Social Security Number of the staff member is: 121212121.
Report Dual Enrollment if the Social Security Number of the staff member is of format: 77000xxxx (where xxxx = the post-secondary school).
Report GenEd in all other situations.
M
Section > Staff History > Role
SectionStaffHistory.role
attendance90Percent
Report True if the LEA Stats record for the configured year has TKES 90% Teaching as A: All Teachers Included (ATI).
Report True if the Percent field on Staff History for the staff in the section is NULL or has a value of .9 or higher.
Report False in all other situations.
M
LEA Stats
Section Staff History
LEAStatsGA.tkesSelection
SectionStaffHistory.percent
Type/Descriptors
classroomPositionDescriptor
Ed-Fi Code Value
Description
Namespace
Short Description
ParaPro Whole Class
Paraprofessional who assists all the students in the class.
uri://gadoe.org/ClassroomPositionDescriptor
Paraprofessional Whole Class
ParaPro Special Assistance
Paraprofessional who assists some of the students in the class
uri://gadoe.org/ClassroomPositionDescriptor
Paraprofessional Special Assistance
Job Coach
Job Coach collaborates with lead teachers to support instructional needs of students with disabilities included in a general education class
uri://gadoe.org/ClassroomPositionDescriptor
Job Coach - Inclusion
Interpreter
Interprets spoken communication for hearing-impaired students in a general education class
uri://gadoe.org/ClassroomPositionDescriptor
Interpreter - Inclusion
Gen Ed Support
Teacher, not a Special Education teacher, (not providing direct instruction) who assists some students with disabilities in a general education class
uri://gadoe.org/ClassroomPositionDescriptor
Gen Ed Support - Inclusion
Speech Therapist
Speech Therapist who assists some or all the students in the class
uri://gadoe.org/ClassroomPositionDescriptor
Speech Therapist
Other Therapist
Other Therapist, not a speech therapist, who assists some or all the students in the class
uri://gadoe.org/ClassroomPositionDescriptor
Other Therapist
Teacher of Record
Teacher of Record
uri://gadoe.org/ClassroomPositionDescriptor
Teacher of Record
staffServiceTypeDescriptor
Ed-Fi Code Value
Description
Namespace
Short Description
ESOL
ESOL Teacher
uri://gadoe.org/StaffServiceTypeDescriptor
ESOL Teacher
Gifted
Gifted Teacher
uri://gadoe.org/StaffServiceTypeDescriptor
Gifted Teacher
Special Ed
Special Ed Teacher
uri://gadoe.org/StaffServiceTypeDescriptor
Special Ed Teacher
EIP
EIP Teacher
uri://gadoe.org/StaffServiceTypeDescriptor
EIP Teacher
GaVS
Ga Virtual Teacher (ex. - teacher ID all 2?s)
uri://gadoe.org/StaffServiceTypeDescriptor
Ga Virtual Teacher
Virtual
Virtual Teacher, not GaVS (ex. - teacher ID all 3?s)
uri://gadoe.org/StaffServiceTypeDescriptor
Virtual Teacher, not GaVS
Software
Software driven class (ex. - teacher ID all 4?s)
uri://gadoe.org/StaffServiceTypeDescriptor
Software
Out of state teacher
Transfer course - Out of state teacher (ex. - teacher ID all 8?s)
uri://gadoe.org/StaffServiceTypeDescriptor
Transfer course - Out of state teacher
In state teacher
Transfer course - In state teacher
uri://gadoe.org/StaffServiceTypeDescriptor
Transfer course - In state teacher
Day Care Teacher
General Ed Day Care Teacher code used to report a Pre-School teacher who is not employed by the LEA. (ex. - teacher ID= ?616161616?) (The ADDITIONAL TEACHER, employed by the LEA, is providing Special Education services.)
uri://gadoe.org/StaffServiceTypeDescriptor
General Ed Day Care Teacher
Short Term Sub
Short Term Sub ? Used for teachers on leave or a sick day. (ex. - teacher ID= ?121212121?)
uri://gadoe.org/StaffServiceTypeDescriptor
Short Term Sub
Dual Enrollment
Dual Enrollment teacher (ex. - teacher ID 77000xxxx, where xxxx = the post-secondary school)
