Staff Section Associations (Georgia v3.6.1)

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 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.

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.

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

Click here to expand...

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)	uri://gadoe.org/StaffServiceTypeDescriptor	Dual Enrollment