Staff Associations
This category captures information about staff employment and assignments as published within the Staff Association category. The Staff Associations category includes the following data views and resources:
Staff Employments
This view captures information about staff member’s employment as published in the staffEducationOrganizationEmploymentAssociation resource within the Staff Associations category. The published layout includes the School Name, Teacher Number, Staff Name, WYSE Staff ID, Type, Hire Date, End Date, Last Publish Date, Publishing ID, and Resource ID.
staffEducationOrganizationEmploymentAssociation
This association indicates the education organization an employee, contractor, volunteer, or other service provider is formally associated with; typically indicated by which organization the staff member has a services contract with or receives compensation from. This resource is required for all Staff and Teachers.
Primary PowerSchool Source Data
- [SchoolStaff]
- [Users]
Selection Criteria
Records are published if the following criteria are met:
- The staffUniqueId (WYSE Staff ID) must be populated in PowerSchool.
- The staff member must not be excluded from state reporting.
- The staff member’s End Date is greater than the staff member’s Hire Date.
Resource Output
- A single staffEducationOrganizationEmploymentAssociation is published for each staff member and teacher in the district based on the year for the Term selected in the PowerSchool UI.
- Lunch staff are excluded from publishing.
- The Education Organization reported within this resource is the District (LEAId).
- The staffEducationOrganizationEmploymentAssociation resource is dependent on the prior publishing of the following resources: staffs.
- LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
educationOrganizationReference A reference to the related EducationOrganization resource | R | |||
/educationOrganizationId | The Education Organization with which the staff is employed. | Integer | LEAID downloaded from the state Derived from: | R |
staffReference A reference to the related Staff resource. | R | |||
/staffUniqueId | The staff employed by the education organization. | Integer | [Users]DCID | R |
employmentStatusDescriptor | Reflects the type of employment or contract. | Descriptor | [SchoolStaff]StaffStatus = 4: 'Substitute/temporary' if [Users]SIF_StatePrID contains a valid, seven-character Wyoming entry: 'Tenured or permanent' Otherwise: 'Contractual' | R |
hireDate | The month, day, and year on which a contract between an individual and a governing authority specifies that employment is to begin (or the date on which the agreement is made valid). | Date | [Terms]FirstDay of selected school year | R |
endDate | The month, day, and year on which a contract between an individual and a governing authority ends or is terminated under the provisions of the contract (or the date on which the agreement is made invalid). If applicable, this element is required. | Date | [Terms]LastDay of selected school year | O |
Staff Identities
This view captures contact information the school or district to which a staff member provides services; also known as school of service. The layout includes the School Name, Teacher Number, Staff Name, WYSE Staff ID, Email, School Phone, Last Publish Date, Publishing ID, and Resource ID.
staffEducationOrganizationIdentityAssociations
This association provides the contact information a staff person has in the context of the educationOrganization that the staff member is assigned, employed, or associated with.
Primary PowerSchool Source Data
- [SchoolStaff]
- [Users]
Selection Criteria
Records are published if the following criteria are met:
- The staffUniqueId (WYSE Staff ID) must be populated in PowerSchool.
- The staff member must not be excluded from state reporting.
- The staff member's school must not be excluded from state reporting.
- The staff member has an email address value populated in the Users table.
Resource Output
- A single staffEducationOrganizationIdentityAssociations is published for each staff member and teacher in the district based on the year for the Term selected in the PowerSchool UI.
- A staff member who works at multiple schools will have a record for each school.
- Lunch staff are excluded from publishing.
- The staffEducationOrganizationIdentityAssociations resource is dependent on the prior publishing of the following resources: staffs.
- LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
educationOrganizationReference A reference to the related EducationOrganization resource | R | |||
/educationOrganizationId | The Education Organization with which the staff is employed. | Integer | LEAID downloaded from the state Derived from: | R |
staffReference A reference to the related Staff resource. | R | |||
/StaffUniqueId | The staff employed by the education organization. | Integer | [Users]DCID | R |
| electronicMailAddress | The electronic mail (email) address listed for an individual or organization. | String | [Users]Email_Addr | R |
| telephones | O | |||
/telephoneNumberType | The type of communication number listed for an individual or organization. | String | 'Work' | R |
/telephoneNumber | The telephone number including the area code, and extension, if applicable. | String | [Users]School_Phone | R |
Staff Schools
This view captures a list of the school(s) to which a teacher provides services. The published layout includes the School Name, Teacher Number, Staff Name, WYSE Staff ID, Last Publish Date, Publishing ID, and Resource ID.
staffSchoolAssociation
This association indicates the education organization to which a teacher provides services. This resource is required for all teachers.
Primary PowerSchool Source Data
- [SchoolStaff]
Selection Criteria
Records are published if the following criteria are met:
- The staffUniqueId (WYSE Staff ID) must be populated in PowerSchool.
- The teacher must not be excluded from state reporting.
- The teacher’s school must not be excluded from state reporting.
- The teacher taught at least one class at the school during the year of the Term selected in PowerSchool
Resource Output
- A separate staffSchoolAssociation record is published for each teacher and for each school to which the teacher is assigned based on the year for the Term selected in the PowerSchool UI.
- A teacher who works at multiple schools will have a record for each school.
- Lunch staff are excluded from publishing.
- The staffSchoolAssociation resource is dependent on the prior publishing of the following resources: staffs.
- LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
schoolReference A reference to the related School resource | R | |||
/schoolId | The school where the staff member provides services. | Integer | SchoolID downloaded from the state Derived from: [SchoolStaff]SchoolID | R |
schoolYearTypeReference A reference to the related SchoolYearType resource. | R | |||
/schoolYear | The identifier for a school year. | Integer | [Terms]YearID | R |
staffReference A reference to the related Staff resource | R | |||
/staffUniqueId | The staff member providing services to the school. | String | [Users]DCID | R |
| programAssignmentDescriptor | 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. | String | 'Regular Education' | R |
Staff Assignments
This view captures details about staff assignments. The published layout includes School Name, Teacher Number, Staff Name, WYSE Staff ID, Assignment, Begin Date, End Date, Last Publish Date, Publishing ID, and Resource ID.
staffEducationOrganizationAssignmentAssociation
This association indicates the education organization to which a staff member provides services; also known as school of service. This resource is required for all Staff and Teachers.
Primary PowerSchool Source Data
- [SchoolStaff]
- [Users]
Selection Criteria
Records are published if the following criteria are met:
- The staffUniqueId (WYSE Staff ID) must be populated in PowerSchool.
- The staff member must not be excluded from state reporting.
- The staff member’s assigned organization must be either the district office, or a school that is not excluded from state reporting.
- The staff member’s End Date is greater than the staff member’s Hire Date.
Resource Output
- A separate staffEducationOrganizationAssignmentAssociation record is published for each school assignment for each staff member and teacher based on the year for the Term selected in the PowerSchool UI.
- A staff member who works at multiple schools will have a record for each school.
- Lunch staff are excluded from publishing.
- The Education Organization reported within this resource is either the district (LEAId) or the school (SchoolId).
- The staffEducationOrganizationAssignmentAssociation resource is dependent on the prior publishing of the following resources: staffs and staffEducationOrganizationEmploymentAssociation.
- LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
employmentStaffEducationOrganizationEmploymentAssociationReference A reference to the employment association. | R | |||
/educationOrganizationId | The Education Organization with which the staff is employed. | Integer | LEAID downloaded from the state Derived from: | R |
/staffUniqueId | The staff employed by the education organization. | Integer | [Users]DCID | R |
/employmentStatusDescriptor | Reflects the type of employment or contract, for example, Probationary, Contractual, Substitute/Temporary, Tenured or Permanent, Volunteer/No contract. | Descriptor | [SchoolStaff]StaffStatus = 4: 'Substitute/temporary' if [Users]SIF_StatePrid contains seven characters: 'Tenured or permanent' Otherwise: 'Contractual' | R |
/hireDate | The month, day, and year on which a contract between an individual and a governing authority specifies that employment is to begin (or the date on which the agreement is made valid). | Date | [Terms]FirstDay of selected school year | R |
educationOrganizationReference A reference to the education organization association. | R | |||
/educationOrganizationId | The Education Organization to which the staff member provides services. | Integer | SchoolID downloaded from the state Derived from: [SchoolStaff]SchoolID | R |
staffReference A reference to the related staffs resource. | ||||
/staffUniqueId | The staff employed by the education organization. | Integer | [Users]DCID | R |
staffClassificationDescriptor | The titles of employment, official status, or rank of education staff.
| Descriptor | If the staff member is assigned a user access role at the school or district, has a SchoolStaff record for the facility, and the role is mapped to a staff classification descriptor in the Miscellaneous Mappings page, the mapped code value for [SchoolStaff]StaffStatus is published If the staff member’s title in [Users]Title matches an Ed-Fi mapped classification, the mapped code value is published. If [SchoolStaff]StaffStatus = 4, 'Substitute Teacher' is published. If [SchoolStaff]StaffStatus = 1, 'Teacher' is published. If the staff member taught a section during the school year at the [SchoolStaff]SchoolID, 'Teacher' is published. If StaffStatus = 2, 'Support Services Staff' is published. Otherwise, ‘Other’ is published. | R |
postionTitle | The descriptive name of an individual's position. *If available, this element is required. | Varchar(100) | If the staff member is assigned a user access role at the school or district, has a SchoolStaff record for the facility, and the role is mapped to a staff classification descriptor in the Miscellaneous Mappings page, the mapped shortDescription for [SchoolStaff]StaffStatus is published If the staff member’s title in [Users]Title matches an Ed-Fi mapped classification, the mapped shortDescription is published. If [SchoolStaff]StaffStatus = 4, 'Substitute Teacher' is published. If [SchoolStaff]StaffStatus = 1, 'Teacher' is published. If the staff member taught a section during the school year at the [SchoolStaff]SchoolID, 'Teacher' is published. If StaffStatus = 2, 'Support Services Staff' is published. Otherwise, ‘Other’ is published. | O* |
beginDate | Month, day, and year of the start or effective date of a staff member's employment, contract, or relationship with the LEA. | Date | [Terms]FirstDay of selected school year | R |
endDate | Month, day, and year of the end or termination date of a staff member's employment, contract, or relationship with the LEA. If applicable, this element is required. | Date | [Terms]LastDay of selected school year | O |