Staff Associations

This category captures information about staff employment, assignments, schools and teacher sections as published within the Staff Associations 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 StaffEducationOrganization EmploymentAssociation resource within the Staff Associations category. The layout includes the School Name, Teacher Number (PowerSchool ID), Staff Name, Hire Date, and PIC.

staffEducationOrganizationEmploymentAssociations

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]
[S_MI_SSF_TSDL_X]

Selection Criteria

Records are published if the following criteria are met:

StaffUniqueId must be populated in PowerSchool.
The staff member must not be excluded from state reporting.
The staff member is not designated as Lunch Staff.
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.
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
educationOrganizationId	The Education Organization with which the staff is employed.	Integer	[S_MI_SSF_TSDL_X]repDistrict Or, [Prefs] where name = districtnumber	R
staffUniqueId	The staff employed by the education organization.	Integer	[S_MI_SSF_TSDL_X]repPIC	R
employmentStatusDescriptor	Reflects the type of employment or contract, for example, Probationary, Contractual, Substitute/Temporary, Tenured or Permanent, Volunteer/No contract.	Descriptor	[S_MI_SSF_TSDL_X]repFunded If empty, then Default = '9'	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_MI_SSF_TSDL_X]repHireDate, if populated. Otherwise, the date of July 1 for the current school year is published. For example, for the 2018-19 school year, '2018-07-01' is published.	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	[S_MI_SSF_TSDL_X]repTermDate	O
separationReasonDescriptor	The reason for terminating the employment, for example, employment in education, employment outside of education, retirement, family/personal relocation, assignment change.	Descriptor	[S_MI_SSF_TSDL_X]repTermReason	O

Back to top

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 (PowerSchool ID), Staff Name, Assignment, Begin Date, End Date, and PIC.

staffEducationOrganizationAssignmentAssociations

This association indicates the education organization to which a staff member provides services; also known as the 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 staff member was previously 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 staff member is not designated as Lunch Staff.
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.
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: 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	[S_MI_SSF_TSDL_X]repDistrict Or, [Prefs] where name = districtnumber	R
/staffUniqueId	The staff employed by the education organization.	Integer	[S_MI_SSF_TSDL_X]repPIC	R
/employmentStatusDescriptor	Reflects the type of employment or contract, for example, Probationary, Contractual, Substitute/Temporary, Tenured or Permanent, Volunteer/No contract.	Descriptor	[S_MI_SSF_TSDL_X]repFunded Or Default = '9'	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_MI_SSF_TSDL_X]repHireDate, if populated. Otherwise, the date of July 1 for the current school year is published. For example, for the 2018-19 school year, '2018-07-01' is published.	R
educationOrganizationId	The Education Organization to which the staff member provides services.	Integer	[SchoolStaff]SchoolId	R
staffIdentity	StaffUniqueId - The staff employed by the education organization.	Integer	[S_MI_SSF_TSDL_X]repPIC	R
staffClassificationDescriptor	The titles of employment, official status, or rank of education staff.	Descriptor	[SchoolStaff]StaffStatus 1 = 'Teacher' 2 = 'School Administrator' 4 = 'Substitute Teacher' Otherwise '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	The most recent date from: [S_MI_SSF_TSDL_X]repHireDate Or, if empty or greater than the first day of the selected school year: [Terms]FirstDay of the selected school year	R
postionTitle	The descriptive name of an individual's position. If available, this element is required.	Varchar(100)	[Users]Title Or, if empty [SchoolStaff]StaffStatus 1 = 'Teacher' 2 = 'School Administrator' 4 = 'Substitute Teacher' Otherwise '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_MI_SSF_TSDL_X]repTermDate	O

Back to top

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, and PIC.

staffSchoolAssociations

This association indicates the education organization to which a teacher provides services; also known as the 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 preceding 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.

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.
Teacher Program Assignment is required within this resource; if no assignment exists, this value is defaulted 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: Staff.
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
schoolId	The school where the staff member provides services.	Integer	Derived from: [SchoolStaff]SchoolID	R
staffUniqueId	The staff member providing services to the school.	Integer	[S_MI_SSF_TSDL_X]repPIC	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.	Descriptor	[S_MI_SSF_TSDL_X]teacherSpecEd = 1: 'Special Education' [S_MI_SSF_TSDL_X]teacherLEP = 1: 'Bilingual/English as a Second Language' [S_MI_SSF_TSDL_X]teacherEC or [S_MI_SSF_TSDL_X]teacherEO = 1: 'Other' Otherwise: 'Regular Education'	R
schoolYearType	The identifier for a school year.	Type	Derived from: YearId for the term selected in the PowerSchool UI	R

Back to top