Staff Section Association (Nebraska v3.5)

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 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 check box is checked.
  • Does not send a record when the Course is marked Inactive or Exclude from State Reporting.

    • Does not send a record when an active teacher does not have any sections due to the exclude on the course.

  • 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 the section is aligned to.
  • Records only send for sections in which staff have an overlapping section staff history record:

    • Posts only 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.
    • Posts only 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.
PostWhen 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.

DeleteWhen a staff member is deleted from Staff History.
DeleteWhen 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.

ActionTrigger
NoneWhen a resource is toggled to OFF after data has sent, all sent data remains in the ODS but no new data sends.
ResyncWhen 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.
ResyncWhen 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.
ResyncWhen 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.

ActionTrigger
Delete/PostNatural Key changes: The natural key logic from Sections and Staffs updates 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.

Resource Preferences

Data Element Label

Mapping Needed

Teacher RoleClassroom Position Descriptor

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

Description and Business Rules

M, C or O

Data Source GUI Path AND

Database Field

idThe unique identifier of the resource.MNot stored
sectionReferenceA reference to the related Section resource.

Reports the data that is part of the Natural Key for the Section resource.
MNot stored
 staffReferenceA reference to the related Staff resource.

Reports the data that is part of the Natural Key for the Staff resource.


Teacher Override: Course and section
  • Course, When field on course is populated, report this number a staff reference and teacher of record.
  • Section, when this field is populated, report this number as staff reference and teacher of record. Section overrides course and Staff History.
MNot stored
beginDateMonth, day and year of a teacher's assignment to the section. When blank, defaults to the first day of the first grading period for the section.

Report the Staff History Start date when populated.

When blank, the Assignment Start Date reports from the District Assignment record for the teacher for that School when 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.


When District Assignment Start Date is prior to the lowest Term Start Date, the lowest Term Start Date for that section that is associated with the term descriptor selected for the section based on section schedule placement reports.


When the teacher has more than one District Assignment record that overlaps the section, the Start Date from the most recent District Assignment record when 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 reports.


When the District Assignment Start Date is prior to the lowest Term Start date, the lowest term Start date for that section that is associated with the term descriptor selected for the section based on section schedule placement reports.

M

Course > Section > Staff History > Start Date


sectionstaffhistory.startdate


Census> People> District Assignment> Start Date


employmentassignment.startdate


System Administration> Calendar> Calendar> Terms


term.startdate

classroomPositionDescriptorA unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

One record reports per course section for teachers with a role of Teacher of Record with the following priority:

  • reports primary teachers assigned as a Teacher of Record or primary teacher with no role assigned (role is blank), then,
  • reports non-primary teachers assigned as Teacher of Record. When there are multiple teachers, the newest teacher reports.

For all other roles, the Ed-Fi Code value from the role selected reports.


Teacher Override: Course and section
  • Course: When field on course is populated, reports this number a staff reference and teacher of record.
  • Section: when this field is populated, reports this number as staff reference and teacher of record. Section overrides course and Staff History.
MCourse > Section > Staff History > Staff History Detail > Teacher Role

sectionstaffhistory.role


sectionstaffhistory.staffType


endDate The last day of a teacher's assignment to the section. 

Reports the Staff History End Date when populated.

When Blank, the Assignment End Date reports from the District Assignment record for the teacher for that School when 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, the Term End Date for that section that is associated with the term descriptor selected for the section based on section schedule placement reports.


When the teacher has more than one District Assignment record that overlaps the section, the End Date from the most Recent District Assignment record when 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 reports.


Otherwise, the Term End Date for that section that is associated with the term descriptor selected for the section based on section schedule placement reports.

O

Course > Section > Staff History > End Date


sectionstaffhistory.enddate


Census > People > District Assignment > End Date


employmentassignment.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.
ONot stored
percentageContributionThe percentage of time the teacher is responsible for the student.

This is optional, does not report.
ONot stored
teacherStudentDataLinkExclusionIndicates 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.
ONot stored
etagA unique system-generated value that identifies the version of the resource.ONot stored

Type Descriptors

Click here to expand...

Classroom Position Descriptors

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01Teacher of RecordTeacher of Record
02Assistant TeacherAssistant Teacher
03Support TeacherSupport Teacer
04Substitute TeacherSubstitute Teacher

Previous Versions

Nebraska Ed-Fi Data v3.5 - Staff Section Association [.2319 and previous]