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. Does not send records when the Calendar Exclude checkbox is marked. Does not send a record when the Course is marked Inactive or Exclude. Does not send is the Course is marked as Exclude. Does not send when the Course does not have a State Code. Must have a role mapped to an Ed-Fi code populated to report. Does not report a record when the Staff does not have an Ed-Fi ID. Does not report when the course is in a school marked as exclude. Does not report a record when the Staff's District Assignment record for the reporting School does not overlap the scope year to which the section is aligned. Only sends a record for sections in which staff have an overlapping section staff history record: Only posts 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 posts 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.
Post/Delete	When 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	When a resource is toggled to off after data has sent, all sent data will remain in the ODS but no new data sends.
Resync	When a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is deleted from the Ed-Fi Identity Mapping table.
Resync	When a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it is deleted from the ODS.
Resync	When a mapping is changed in Resource Preferences, a resync needs 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 when 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 only sends for years that have valid configuration.

Logic

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

Data only sends for years that have valid configuration.

Resource Preferences

Data Element Label	Mapping Needed
Teacher Role	Classroom Position Descriptor

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	Description	M, C or O	Database 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. localCourseCode = Course Number schoolId = Reporting School schoolYear = End year of the calendar sectionIdentifier = Section Number sessionName = Term Descriptor	M
staffReference	A reference to the related Staff resource. Reports the data that is part of the Natural Key for the Staff resource.	M
classroomPositionDescriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. Must have an assignment code reported. Cannot be Null. Reports selected Position Code (Course/Section > Section Editor > Position Code). When Position Code is null, reports the Assignment Code for Primary Teacher (Census > People > District Assignments > Employment Assignment Information > Assignment Code). When both Position Code and Assignment Code are null, reports as 60.	M	Course/Section > Section > Section Editor > Position Code AND Census > District Assignments > Employment Assignment Information > Assignment Code sectionstaffhistory.role

Type/Descriptors

Click here to expand...

Classroom Position Descriptors

Ed-Fi Code	Ed-Fi Short Description	Namespace	Ed-Fi Description
10	Central Office Administration	uri://dese.mo.gov/ClassroomPositionDescriptor	Central Office Administration
20	Building Principals	uri://dese.mo.gov/ClassroomPositionDescriptor	Building Principals
30	Supervisors	uri://dese.mo.gov/ClassroomPositionDescriptor	Supervisors
40	Media Personnel	uri://dese.mo.gov/ClassroomPositionDescriptor	Media Personnel
50	Guidance Personnel/Placement Specialists	uri://dese.mo.gov/ClassroomPositionDescriptor	Guidance Personnel/Placement Specialists
60	Teachers	uri://dese.mo.gov/ClassroomPositionDescriptor	Teachers
70	Other Pupil Services Personnel	uri://dese.mo.gov/ClassroomPositionDescriptor	Other Pupil Services Personnel
80	Aides	uri://dese.mo.gov/ClassroomPositionDescriptor	Aides
90	Ancillary Personnel	uri://dese.mo.gov/ClassroomPositionDescriptor	Ancillary Personnel

Staff Section Association (Missouri v3.6)