Staff Associations
This category captures information about staff assignments and schools as published within the Staff Associations category. The Staff Associations category includes the following data views and resources:
Staff Assignments
This view captures details about staff assignments as published in the staffEducationOrganizationAssignmentAssociation within the Staff Associations category. The layout includes School Name, Teacher Number, Staff Name, State Identifier, 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
- S_USR_EdFi_Assignments_C
Selection Criteria
Records are published if the following criteria are met:
- 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 staffUniqueId must be populated in PowerSchool.
- 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 educationOrganization 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.
- 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 educationOrganization association. | R | |||
/educationOrganizationID | The Education Organization to which the staff member provides services. | Integer | Derived from: SchoolStaff.SchoolId | R |
staffReference A reference to the related staffs resource. | ||||
/staffUniqueID | 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 Users.Title = a downloaded Staff Classifications descriptor: Staff Classification descriptor downloaded from the state SchoolStaff.StaffStatus = 4: Published Value = 'Substitute Teacher' SchoolStaff.StaffStatus = 1: Published Value = 'Teacher' If the staff member exists in [Sections] for the term and year selected on the PowerSchool UI: Published Value = 'Teacher' SchoolStaff.StaffStatus = 2 and assignment is with a district: Published Value = 'LEA Administrator' SchoolStaff.StaffStatus = 2 and assignment is with a school: Published Value = 'School Administrator' Otherwise: Published Value = 'Other' | R |
beginDate | Month, day, and year of the start or effective date of a staff member's employment, contract, or relationship with the LEA. | Date | If S_USR_EdFi_Assignments_C.EndDate is greater than Terms.FirstDay of selected school year : S_USR_EdFi_Assignments_C.EndDate Otherwise: Terms.FirstDay of selected school year Format:'YYYY-MM-DD' | R |
postionTitle | The descriptive name of an individual's position. *If available, this element is required. | Varchar(100) | If CST_PubCodeSet.ResourceName = 'staffClassificationDescriptors' and CST_PubCodeValue.ShortDescription = Users.Title: Users.Title SchoolStaff.StaffStatus = 4: Published Value = 'Substitute Teacher' SchoolStaff.StaffStatus = 1: Published Value = 'Teacher' If the staff member exists in the Sections table for the term and year selected on the PowerSchool UI: Published Value = 'Teacher' SchoolStaff.StaffStatus = 2 and assignment is with a district: Published Value = 'LEA Administrator' SchoolStaff.StaffStatus = 2 and assignment is with a school: Published Value = 'School Administrator' Otherwise: Published Value = 'Other' | O* |
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 | S_USR_EdFi_Assignments_C.EndDate Format:'YYYY-MM-DD' | O |
Staff Schools
This view captures a list of the school(s) or district to which a teacher provides services as published in the staffSchoolAssociation resource within the Staff Association category. The layout includes the School Name, Teacher Number (PowerSchool ID), Staff Name, State Identifier, Last Publish Date, Publishing ID, and Resource ID.
staffSchoolAssociation
This association indicates the education organization to which a teacher provides services; also known as school of service. This resource is required for all Teachers.
Primary PowerSchool Source Data
- SchoolStaff
- S_USR_EdFi_Subjects_C
Selection Criteria
Records are published if the following criteria are met:
- The teacher must not be excluded from state reporting.
- The teacher’s school must not be excluded from state reporting.
- The staffUniqueId must be populated in PowerSchool.
- 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.
- The educationOrganization reported within this resource is the school (SchoolID).
- 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 schools resource | R | |||
/schoolID | The school where the staff member provides services. | Integer | Derived from: SchoolStaff.SchoolId | R |
schoolYearTypeReference A reference to the related schoolYearType resource. | R | |||
/schoolYear | The identifier for a school year. | Integer | Derived from: YearId for term selected in the PowerSchool UI | R |
staffReference A reference to the related staffs 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 | Published Value = 'Regular Education' | R |
staffSchoolAssociationAcademicSubject An unordered collection of staffSchoolAssociationAcademicSubjects. | O | |||
/academicSubjectDescriptor | The teaching field taught by an individual, for example English/Language Arts, Reading, Mathematics, Science, Social Sciences, etc. | String | S_USR_EdFi_Subjects_C.AcademicSubject | R |
staffSchoolAssociationGradeLevel An unordered collection of staffSchoolAssociationGradeLevels. | O | |||
/gradeLevelDescriptor | The set of grade levels for which the individual's assignment is responsible. | String | Subjects or Bell Schedules with a valid grade level will be published. | R |