Wisconsin Ed-Fi Data v3.5 - Staff Section Association

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 a course section on Staff History.

  • Must have a Staff Type of P:  Primary Teacher or T: Teacher in the Section Staff History Table.
  • Do not send records if the Calendar Exclude check box is checked.
  • Do not send a record if the Course is marked Inactive or Exclude.

  • Must have a role mapped to an Ed-Fi code populated to report.
  • Do not report a record if the Staff does not have an Ed-Fi ID.
  • Do not report if the course is in a school marked as exclude.
  • Do not report a record if the Staff's District Assignment record for the reporting School does not overlap the scope year the section is aligned to.
  • Do not send a record if the Course is marked Exclude.
  • Do not report if the course is in a Calendar marked Summer School.
  • Do not report a record if there are 0 students rostered into the section.
  • Do not send a record If Ed-Fi Configuration Profile = Choice OR Choice + Private Opt In.
  • Only send a record for sections in which staff have an overlapping section staff history record:

    1. Only post 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.
    2. Only post 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.
PostWhen students are added to a reportable section with a teacher.
Put

When Start or End dates are modified on the Staff History.

Post/Delete

If 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.
DeleteIf an end date is added on Section Staff History that ends the teacher record before the section reference start date.
DeleteWhen staff Role is changed to XX: Not State Reported.


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.


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

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

idThe unique identifier of the resource.
M

sectionReferenceA reference to the related Section resource.

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


M

 staffReferenceA reference to the related Staff resource.

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


M

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.
  1. Report the Staff History Start date if populated.
    • If Blank, look at the District Assignment record for the teacher for that School and report Assignment Start Date if it is on or after the lowest Term Start Date and on or before the highest Term End Date for that section.
      • If District Assignment Start Date is Prior to the lowest Term Start Date, report the lowest Term Start Date for that section.
  2. If the teacher end date is before the section start date, do not report a record for the teacher.
M

Course> Section> Staff History> Start Date


OR


Census> People> District Assignment> Start Date

sectionstaffhistory.startdate

OR

employmentassignment.

startdate



classroom PositionDescriptorA unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.
  1. Reports the Ed-Fi Code field from the Role that is selected.
    • Report default value if selected.
  2. If Role is XX:  Not State Reported, do not report a record.
  3. If Role is NULL, do not report a record.
MCourse> Section> Staff History> Rolesectionstaffhistory.role
endDate Month, day and year of the last day of a teacher''s assignment to the section. 
  1. Report the Staff History End Date if populated.
    • If Blank, look at the District Assignment record for the teacher for that School and report Assignment End Date if it is on or after the lowest Term Start Date and on or before the highest Term End Date for that section.
  2. Else, Report the Term End Date for that section.
O

Course> Section> Staff History> End Date


OR


Census> People> District Assignment> End Date

sectionstaffhistory.enddate

OR

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.

O

percentage ContributionThe percentage of time the teacher is responsible for the student.

This is optional, does not report.

O

teacher Student DataLinkExclusionIndicates 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.

O

etagA unique system-generated value that identifies the version of the resource.
O

Type/Descriptors

Click here to expand...

Classroom Position Descriptor:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
03187Administrative staffAdministrative staff is specified as the type of position the staff member holds in the specific course section.
73071Co-teacherCo-teacher is specified as the type of position the staff member holds in the specific course section.
04725CounselorCounselor is specified as the type of position the staff member holds in the specific course section.
73073Course ProctorCourse Proctor is specified as the type of position the staff member holds in the specific course section.
05973Instructor of recordInstructor of record is specified as the type of position the staff member holds in the specific course section.
01234InternIntern is specified as the type of position the staff member holds in the specific course section.
73072Lead Team TeacherLead Team Teacher is specified as the type of position the staff member holds in the specific course section.
00069Non-instructional staffNon-instructional staff is specified as the type of position the staff member holds in the specific course section.
09999OtherOther is specified as the type of position the staff member holds in the specific course section.
00059Paraprofessionals/teacher aidesParaprofessionals/teacher aides is specified as the type of position the staff member holds in the specific course section.
05971Primary instructorPrimary instructor is specified as the type of position the staff member holds in the specific course section.
04735Resource teacherResource teacher is specified as the type of position the staff member holds in the specific course section.
05972Secondary instructorSecondary instructor is specified as the type of position the staff member holds in the specific course section.
73074Special Education ConsultantSpecial Education Consultant is specified as the type of position the staff member holds in the specific course section.
00080Student teachersStudent teachers is specified as the type of position the staff member holds in the specific course section.
01382Volunteer/no contractVolunteer/no contract is specified as the type of position the staff member holds in the specific course section.