Staff and Teacher Association Data
This category captures information about staff employment, assignments, schools, and teacher sections as published within the Staff Association category.
Staff Employments
This view captures information about staff member's employment as published in the StaffEducationOrganization EmploymentAssociation resource within the Staff Association category. The layout includes the School Name, Teacher Number, Staff Name, Gender, Last Publish Date, and the Publishing 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
[S_TN_USR_X]
[S_TN_USR_StaffAssignments_C]
Selection Criteria
Records are published if the following criteria are met:
The staff member was published in the staff resource.
StaffUniqueId must be populated in PowerSchool.
The staff member must not be excluded from state reporting.
The staff member was employed during the school year for the term selected in the PowerSchool UI.
The staff member is not designated as Lunch Staff or Substitute Teacher.
Resource Output
A separate staffEducationOrganizationEmploymentAssociation is published for each staff member and teacher for each Education Organization at which they are employed.
A staff member who is employed at multiple schools will have a record for each school.
The Education Organization reported within this resource is either the district (LEAID) or the school (SchoolID).
The staffEducationOrganizationEmploymentAssociation resource is dependent on the prior publishing of the following resources: staff.
LEAs and Schools may upload (publish) data to the 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 |
|---|---|---|---|---|
staffReference/staffIdentity | The staff employed by the education organization. | Integer | Staff UniqueId downloaded from State | M |
educationOrganizationReference/ | The Education Organization with which the staff is employed. | Integer | LEAID or SchoolID downloaded from State SchoolID Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
employmentStatus | Reflects the type of employment or contract, for example, Probationary, Contractual, Substitute/Temporary, Tenured/Permanent, Volunteer/No contract. | Descriptor | [S_TN_USR_X]WorkStatus F: 'Tenured/Permanent' P: 'Employed part time' | M |
employmentPeriod The set of elements defining and characterizing a person's period of employment including start and end dates and the type and reason for separation. | 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 | [S_TN_USR_StaffAssignments_C]AssignmentBeginDate | M |
/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 | [S_TN_USR_StaffAssignments_C]AssignmentEndDate | C |
fullTimeEquivalency | The ratio between the hours of work expected in a position and the hours of work normally expected in a full-time position in the same setting. | Decimal(5,2) | Derived from: [S_TN_USR_X]WorkStatus F: '1' P: '.5' | O |
Staff Assignments
This view captures details about staff assignments as published in the StaffEducationOrganizationAssignmentAssociation within the Staff Association category. The layout includes the same core information as listed in the Staff Employments view and adds the Assignment, Begin Date, End Date, Last Publish Date, and the Publishing 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
[S_TN_USR_X]
[S_TN_USR_StaffAssignments_C]
Selection Criteria
Records are published if the following criteria are met:
The staff member was published in the staff resource.
StaffUniqueId 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 assignment must be during the school year for the term selected in the PowerSchool UI.
The staff member is not designated as Lunch Staff or Substitute Teacher.
Resource Output
A separate staffEducationOrganizationAssignmentAssociation record is published for each school assignment for each staff member and teacher who meets the selection criteria.
A staff member who works at multiple schools will have a record for each school.
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: staff, staffEducationOrganizationEmploymentAssociation.
LEAs and Schools may upload (publish) data to the 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 |
|---|---|---|---|---|
staffReference/staffIdentity | The staff employed by the education organization. | Integer | Staff UniqueId downloaded from State Derived from: [Users]DCID | M |
educationOrganizationReference/ | The Education Organization to which the staff member provides services. | Integer | LEAID or SchoolID downloaded from State SchoolID Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
staffClassificationDescriptor | The titles of employment, official status, or rank of education staff. Refer to Staff Assignment Codes for information on the values that can be published. | Descriptor | [Staff_Assignments]TN_StaffAssignment | M |
positionTitle | The descriptive name of an individual's position. If available, this element is required. | Varchar(100) | The short description from the StaffClassification descriptor is used. | C |
beginDate | Month, day, and year of the start or effective date of a staff member's employment, contract, or relationship with the LEA. | Date | [S_TN_USR_StaffAssignments_C]AssignmentBeginDate | M |
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_TN_USR_StaffAssignments_C]AssignmentEndDate | C |
staffEducationOrganizationEmploymentAssociationReference/staffEducationOrganizationEmploymentAssociationIdentity A reference to the employment association. | O | |||
/educationOrganizationReference/ | The Education Organization with which the staff is employed. | Integer | LEAID or SchoolID downloaded from State SchoolID Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
/staffReference/staffIdentity | StaffUniqueId - The staff employed by the education organization. | Integer | Staff UniqueId downloaded from State | M |
/employmentStatus | EmploymentStatusDescriptor - Reflects the type of employment or contract, for example, Probationary, Contractual, Substitute/temporary, Tenured or permanent, Volunteer/no contract. | Descriptor | [S_TN_USR_X]WorkStatus F: 'Tenured/Permanent' P: 'Employed part time' | M |
Staff Schools
This view captures a list of school assignments for each teacher as published in the StaffSchoolAssociation resource within the Staff Association category. The layout includes the School Name, Teacher Number, Staff Name, Gender, Last Publish Date, and the Publishing 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]
Selection Criteria
Records are published if the following criteria are met:
The teacher was published in the staff resource.
StaffUniqueId 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 or has a staff assignment of XS at the school during the year for the Term selected in the PowerSchool UI.
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 teacher programAssignment is required within this resource; since there is no current PowerSchool source for Program Assignment, this value defaults to 'Regular Education'.
The Education Organization reported within this resource is the School (SchoolID).
The staffSchoolAssociation resource is dependent on the prior publishing of the following resources: staffEducationOrganizationEmploymentAssociation.
LEAs and Schools may upload (publish) data to the 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 |
|---|---|---|---|---|
staffReference/staffIdentity | The teacher providing services to the school. | Integer | Staff UniqueId downloaded from State Derived from: [SchoolStaff]Users_DCID | M |
schoolReference/schoolIdentity | The school where the teacher provides services. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
schoolYear | The identifier for a school year. | Enumerated List | Derived from: YearId for term selected in the PowerSchool UI | O |
programAssignment | The name of the program for which the teacher is assigned, for example, Regular education, Title I-Academic, Title I-Non-Academic, Special Education, Bilingual/ English as a Second Language. | Descriptor | 'Regular Education' | M |
Staff Sections
This view captures the section assignments for each teacher as published in the StaffSectionAssociation resource within the Staff Association category. The layout includes the School Name, Teacher Number, Staff Name, Course Number, Course Name, Section Number, Last Publish Date, and the Publishing ID.
staffSectionAssociation
This association indicates the class sections to which a teacher is assigned. This resource is required for all teachers.
Primary PowerSchool Source Data
[SectionTeacher]
[Sections]
[S_TN_SEC_X]
Selection Criteria
Records are published if the following criteria are met:
The teacher was published in the staff resource.
The section was published in the Master Schedule category.
StaffUniqueId 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's section must not be excluded from state reporting.
The course must have a valid state course code.
Dual Enrollment, [S_TN_SEC_Honors_X]DualEnrollment, must be marked 'N' or be empty.
Resource Output
A separate staffSectionAssociation record is published for each course section in which the teacher is scheduled based on the year for the Term selected in the PowerSchool UI.s
A teacher with classes at multiple schools will have a record for each section at each school.
A section with multiple teachers will have a record for each teacher associated with the section.
The staffSectionAssociation resource is dependent on the prior publishing of the following resources: staff, staffSchoolAssociation, and section.
Note: staffSectionAssociation is not published for dual enrollment courses.
LEAs and Schools may upload (publish) data to the 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 |
|---|---|---|---|---|
staffReference/staffIdentity | The staff member assigned to the section. | Integer | Staff UniqueId downloaded from State Derived from: [SectionTeacher]TeacherId | M |
sectionReference/sectionIdentity The section the staff member is assigned to. | M | |||
/locationReference/locationIdentity The location, typically a classroom, where the section meets. | R | |||
//classroomIdentificationCode | A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or resource. | Varchar(20) | [Sections]Room | M |
//schoolReference/schoolIdentity | The school for the section's classroom. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
/classPeriodReference/classPeriodIdentity The class period during which the section meets. | M | |||
//classPeriodName | An indication of the portion of a typical daily session in which students receive instruction in a specified subject, for example, morning, sixth period, block period, or AB schedules. | Varchar(20) | [Period]Period_Number | M |
//schoolReference/schoolIdentity | The school for which the period is defined. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
/courseOfferingReference/courseOfferingIdentity The course offering taught in the section. | M | |||
//localCourseCode | The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students; must match LocalCourseCode in corresponding CourseOffering. | Varchar(60) | If Report Course.Section setting is set to Yes, then Local Course Number + Section_Number '_' Section DCID | M |
//term | The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school. This must match Term in corresponding CourseOffering. | Enumerated List | [Sections]TermID | M |
//schoolYear | The identifier for the school year, for example, 2010-2011. This must match SchoolYear in corresponding CourseOffering. | Enumerated List | [Terms]YearID | M |
//schoolReference/schoolIdentity | The school offering the course. This must match SchoolID in corresponding CourseOffering. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
classroomPosition | ClassroomPositionDescriptor - The type of position the staff member holds in the specific class/section, for example, Teacher of Record, Assistant Teacher, Support Teacher, Substitute Teacher, etc. | Descriptor | [S_TN_SEC_X]TeacherOfRecord | R |
beginDate | Month, 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. | Date | [SectionTeacher]Start_Date | R |
endDate | Month, day, and year of the last day of a teacher's assignment to the section. | Date | [SectionTeacher]End_Date | R |
federallyFundedIndicator | Indicates whether this section is federally funded (Y, N, or blank). N and blank both indicate that the section is not federally funded. | Vchar(1) | [S_TN_SEC_X]FederallyFunded | |