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.

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

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf 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.
ResyncIf 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.
ResyncIf 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.

ActionTrigger
Delete/PostNatural 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

SectionStaffHistorypersonID-SectionID-TermID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
sectionstaffhistoryPost/Put/DeleteThe primary table used for sending data for this resource.
employmentassignmentPutBegin Date, End date
termPutBegin Date, End Date
sectionstaffhistoryPutBegin 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

sectionReferenceA reference to the related Section resource.

Reports the fields that are part of the Natural Key for the Sections resource.

MN/AN/A
 staffReferenceA reference to the related Staff resource.

Reports the fields that are part of the Natural Key for the Staffs resource.

MN/AN/A
beginDateMonth, 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.
MSection > 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.
MSection > 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 ValueDescriptionNamespaceShort Description
ParaPro Whole ClassParaprofessional who assists all the students in the class.uri://gadoe.org/ClassroomPositionDescriptorParaprofessional Whole Class
ParaPro Special AssistanceParaprofessional who assists some of the students in the classuri://gadoe.org/ClassroomPositionDescriptorParaprofessional Special Assistance
Job CoachJob Coach collaborates with lead teachers to support instructional needs of students with disabilities included in a general education classuri://gadoe.org/ClassroomPositionDescriptorJob Coach - Inclusion
InterpreterInterprets spoken communication for hearing-impaired students in a general education classuri://gadoe.org/ClassroomPositionDescriptorInterpreter - Inclusion
Gen Ed SupportTeacher, not a Special Education teacher,  (not providing direct instruction) who assists some students with disabilities in a general education classuri://gadoe.org/ClassroomPositionDescriptorGen Ed Support - Inclusion
Speech TherapistSpeech Therapist who assists some or all the students in the classuri://gadoe.org/ClassroomPositionDescriptorSpeech Therapist
Other TherapistOther Therapist, not a speech therapist, who assists some or all the students in the classuri://gadoe.org/ClassroomPositionDescriptorOther Therapist
Teacher of RecordTeacher of Recorduri://gadoe.org/ClassroomPositionDescriptorTeacher of Record

staffServiceTypeDescriptor

Ed-Fi Code ValueDescriptionNamespaceShort Description
ESOLESOL Teacheruri://gadoe.org/StaffServiceTypeDescriptorESOL Teacher
GiftedGifted Teacheruri://gadoe.org/StaffServiceTypeDescriptorGifted Teacher
Special EdSpecial Ed Teacheruri://gadoe.org/StaffServiceTypeDescriptorSpecial Ed Teacher
EIPEIP Teacheruri://gadoe.org/StaffServiceTypeDescriptorEIP Teacher
GaVSGa Virtual Teacher (ex. - teacher ID all 2?s)uri://gadoe.org/StaffServiceTypeDescriptorGa Virtual Teacher
VirtualVirtual Teacher, not GaVS (ex. - teacher ID all 3?s)uri://gadoe.org/StaffServiceTypeDescriptorVirtual Teacher, not GaVS
SoftwareSoftware driven class (ex. - teacher ID all 4?s)uri://gadoe.org/StaffServiceTypeDescriptorSoftware
Out of state teacherTransfer course - Out of state teacher (ex. - teacher ID all 8?s)uri://gadoe.org/StaffServiceTypeDescriptorTransfer course - Out of state teacher
In state teacherTransfer course - In state teacheruri://gadoe.org/StaffServiceTypeDescriptorTransfer course - In state teacher
Day Care TeacherGeneral 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/StaffServiceTypeDescriptorGeneral Ed Day Care Teacher
Short Term SubShort Term Sub ? Used for teachers on leave or a sick day. (ex. - teacher ID= ?121212121?)uri://gadoe.org/StaffServiceTypeDescriptorShort Term Sub
Dual EnrollmentDual Enrollment teacher (ex. - teacher ID 77000xxxx, where xxxx = the post-secondary school)uri://gadoe.org/StaffServiceTypeDescriptorDual Enrollment