Staff School Associations (Wisconsin v3.6)

Tool Search: Ed-Fi

This association indicates the school(s) to which a teacher provides instructional services.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a District Assignment record is created or changed and saved for a staff member.

Do not report if any of the following scenarios are true:

  • There is not an Ed-FI ID for the staff person.
  • The District Assignment records are not active based on the Scope Year logic listed below.
  • If the record is being triggered from a District Assignment record and it is marked as Exclude.

  • If the record is being triggered from a District Assignment record and the School is marked as Exclude.

  • If data is sent prior to the Exclude check boxes are checked, the data will remain and the user will need to use the Delete Tool to remove data.
Put

When any field not part of the natural key changes:

  • academicSubjects
  • gradeLevels
Delete/Post

If any part of the Natural Key changes:

  • programAssignmentDescriptor
Delete/PostIf there are two District Assignment records that create the same natural Key and 1 is Deleted, the remaining record will be posted.
DeleteWhen a District Assignment record is deleted.


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
Post/Delete

Natural Key changes: 

  • If the School Number/Ed-Fi School Number changes or the  Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the School ID/Ed-Fi ID Change triggers.
  • programAssignmentDescriptor
DeleteCascading Deletes: N/A - there are no dependent resources.


Scope Year Logic

This table describes scope year logic of this object.

Logic

A record will report when a person has a District Assignment or District Employment record that is aligned to a scoped year.

Report when a staff has an active District Assignment or District Employment record that overlaps with the School year Start and End Dates

  • If School Year Start Date is NULL, 7/1/xxxx will be the default start date used.
  • If School Year End Date is NULL, 6/30/xxxx will be the default end date used.
Data will only send for the years that have valid configuration.


Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
employmentassignmentPost/Put/DeleteThe primary table used for sending data for this resource.


Object Data Elements

Data Element Labels in bold are part of the Natural Key and are required data elements for data to send to Ed-Fi.

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

id  

The unique identifier of the resource.
M


program
Assignment
Descriptor 

The name of the program for which the individual is assigned; for example: Regular education Title I-Academic Title I-Non-Academic Special Education Bilingual/English as a Second Language.

  1. Report 'Regular Education' if the Teacher checkbox is checked.
  2. Report' Special Education' if the Special Ed checkbox is checked.
  3. Else, report 'Other'.
Census>  People > District Assignment

employmentassignment.teacher

employmentassignment.specialed

employmentassignment.behavior

employmentassignment.health

employmentassignment.advisor

employmentassignment.supervisor

employmentassignment.foodservice

employmentassignment.counselor

calendar
Reference
A reference to the related Calendar Resource.
  1. This is optional, does not report.
O

school
Reference
A reference to the related Education Organization resource.
  1. Reports the data that is part of the Natural Key for the Schools resource.


M

schoolYear
TypeReference
 Identifier for a school year.
  1. Report the calendar End Year (ex: 2017).
O

staff
Reference
A reference to the related Staff resource.
  1. Reports the data that is part of the Natural Key for the Staff resource.




academic
Subjects

An unordered collection of staffSchoolAssociationAcademicSubjects. This association indicates the school(s) to which a teacher provides instructional services.

  1. See Array section below for logic.
O

gradeLevelsAn unordered collection of staffSchoolAssociationGradeLevels. This association indicates the school(s) to which a teacher provides instructional services.
  1. See Array section below for logic.
O

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

Arrays

Click here to expand...

Academic Subject

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

academicSubjectDescriptor
Key for academicSubject.
  1. Report the Ed-Fi Code from the Primary Teaching Area field.
  2. If Ed-Fi Code is NULL or field is blank, do not report.
M Census> People> District Assignments> Primary Teaching Areaemploymentassignment. primaryTeachingArea

Grade Levels

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

gradeLevelDescriptor
Key for gradeLevels.
  1. Report the Ed-Fi Code from the Grade selected.
  2. If Ed-Fi Code is NULL or field is blank, do not report.
M Census> People> District Assignments> Grade Level employmentassignment.grade

Type/Descriptors

Click here to expand...

Program Assignment Descriptors

Code ValueDescriptionNamespaceShort Description
Bilingual/English as a Second LanguageBilingual/English as a Second Languageuri://ed-fi.org/ProgramAssignmentDescriptorBilingual/English as a Second Language
OtherOtheruri://ed-fi.org/ProgramAssignmentDescriptorOther
Regular EducationRegular Educationuri://ed-fi.org/ProgramAssignmentDescriptorRegular Education
Special EducationSpecial Educationuri://ed-fi.org/ProgramAssignmentDescriptorSpecial Education
Title I-AcademicTitle I-Academicuri://ed-fi.org/ProgramAssignmentDescriptorTitle I-Academic
Title I-Non-AcademicTitle I-Non-Academicuri://ed-fi.org/ProgramAssignmentDescriptorTitle I-Non-Academic

Academic Subject Descriptors

Code ValueDescriptionNamespaceShort Description
Career and Technical EducationCareer and Technical Educationuri://ed-fi.org/AcademicSubjectDescriptorCareer and Technical Education
CompositeCompositeuri://ed-fi.org/AcademicSubjectDescriptorComposite
Critical ReadingCritical Readinguri://ed-fi.org/AcademicSubjectDescriptorCritical Reading
Cross SubjectCross Subjecturi://ed-fi.org/AcademicSubjectDescriptorCross Subject
EnglishEnglishuri://ed-fi.org/AcademicSubjectDescriptorEnglish
English Language ArtsEnglish Language Artsuri://ed-fi.org/AcademicSubjectDescriptorEnglish Language Arts
Fine and Performing ArtsFine and Performing Artsuri://ed-fi.org/AcademicSubjectDescriptorFine and Performing Arts
Foreign Language and LiteratureForeign Language and Literatureuri://ed-fi.org/AcademicSubjectDescriptorForeign Language and Literature
Life and Physical SciencesLife and Physical Sciencesuri://ed-fi.org/AcademicSubjectDescriptorLife and Physical Sciences
MathematicsMathematicsuri://ed-fi.org/AcademicSubjectDescriptorMathematics
Military ScienceMilitary Scienceuri://ed-fi.org/AcademicSubjectDescriptorMilitary Science
OtherOtheruri://ed-fi.org/AcademicSubjectDescriptorOther
Physical, Health, and Safety EducationPhysical, Health, and Safety Educationuri://ed-fi.org/AcademicSubjectDescriptorPhysical, Health, and Safety Education
ReadingReadinguri://ed-fi.org/AcademicSubjectDescriptorReading
Religious Education and TheologyReligious Education and Theologyuri://ed-fi.org/AcademicSubjectDescriptorReligious Education and Theology
ScienceScienceuri://ed-fi.org/AcademicSubjectDescriptorScience
Social Sciences and HistorySocial Sciences and Historyuri://ed-fi.org/AcademicSubjectDescriptorSocial Sciences and History
Social StudiesSocial Studiesuri://ed-fi.org/AcademicSubjectDescriptorSocial Studies
WritingWritinguri://ed-fi.org/AcademicSubjectDescriptorWriting

Grade Level Descriptors

Code ValueDescriptionNamespaceShort Description
Adult EducationAdult Educationuri://ed-fi.org/GradeLevelDescriptorAdult Education
Early EducationEarly Educationuri://ed-fi.org/GradeLevelDescriptorEarly Education
Eighth gradeEighth gradeuri://ed-fi.org/GradeLevelDescriptorEighth grade
Eleventh gradeEleventh gradeuri://ed-fi.org/GradeLevelDescriptorEleventh grade
Fifth gradeFifth gradeuri://ed-fi.org/GradeLevelDescriptorFifth grade
First gradeFirst gradeuri://ed-fi.org/GradeLevelDescriptorFirst grade
Fourth gradeFourth gradeuri://ed-fi.org/GradeLevelDescriptorFourth grade
Grade 13Grade 13uri://ed-fi.org/GradeLevelDescriptorGrade 13
Infant/toddlerInfant/toddleruri://ed-fi.org/GradeLevelDescriptorInfant/toddler
KindergartenKindergartenuri://ed-fi.org/GradeLevelDescriptorKindergarten
Ninth gradeNinth gradeuri://ed-fi.org/GradeLevelDescriptorNinth grade
No grade levelNo grade leveluri://ed-fi.org/GradeLevelDescriptorNo grade level
OtherOtheruri://ed-fi.org/GradeLevelDescriptorOther
PostsecondaryPostsecondaryuri://ed-fi.org/GradeLevelDescriptorPostsecondary
Preschool/PrekindergartenPreschool/Prekindergartenuri://ed-fi.org/GradeLevelDescriptorPreschool/Prekindergarten
Second gradeSecond gradeuri://ed-fi.org/GradeLevelDescriptorSecond grade
Seventh gradeSeventh gradeuri://ed-fi.org/GradeLevelDescriptorSeventh grade
Sixth gradeSixth gradeuri://ed-fi.org/GradeLevelDescriptorSixth grade
Tenth gradeTenth gradeuri://ed-fi.org/GradeLevelDescriptorTenth grade
Third gradeThird gradeuri://ed-fi.org/GradeLevelDescriptorThird grade
Twelfth gradeTwelfth gradeuri://ed-fi.org/GradeLevelDescriptorTwelfth grade
UngradedUngradeduri://ed-fi.org/GradeLevelDescriptorUngraded