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/ educationOrganizationIdentity	The Education Organization with which the staff is employed.	Integer	LEAID or SchoolID downloaded from State SchoolID Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	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/ educationOrganizationIdentity	The Education Organization to which the staff member provides services.	Integer	LEAID or SchoolID downloaded from State SchoolID Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	M
staffClassification	The titles of employment, official status, or rank of education staff.	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/ educationOrganizationIdentity	The Education Organization with which the staff is employed.	Integer	LEAID or SchoolID downloaded from State SchoolID Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	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 [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	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 Default: 'OPEN'	M
//schoolReference/schoolIdentity	The school for the section's classroom.	Integer	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	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 Derived from: [Section_Meeting]Period_Number	M
//schoolReference/schoolIdentity	The school for which the period is defined.	Integer	SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	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 Otherwise, [Sections]ID	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 [Terms]Portion [Terms]Abbreviation	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 [Prefs]Value and [Schools]Alternate_School_Number if value is greater than 0 Otherwise [Schools]School_Number	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