Staff Education Organization Assignment | PowerSchool SIS Tennessee

Resource Overview

Ed-Fi endpoint: /data/v3/staffEducationOrganizationAssignmentAssociations
Published view/entity: Staff Assignment
Purpose: Staff assignment within a specific school
Source query: StaffEduOrgAssignAssociation
Dependencies: staffEducationOrganizationContactAssociations, staffEducationOrganizationEmploymentAssociations

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]

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

Data Element (Ed-Fi target)	Data View Column Name	Submission	[Table]Field (PowerSchool Source)	Business Rules	Comments
educationOrganizationReference.educationOrganizationId	EduOrgID	Y	Publishing framework or supporting query Query alias: EduOrgID	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: EduOrgID.
staffReference.staffUniqueId	StaffUID	Y	[SchoolStaff]Users_DCID; Transformation: EDFI_TN_LIB.getStaffUniqueId(p_profileid, ss.users_dcid)	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: StaffUID.
employmentStaffEducationOrganizationEmploymentAssociationReference.educationOrganizationId	DistrictContactID	Y	Staging rule: staffAssignment CST_PUBWORKFLOW.formatLEADistrictIDBase(p_profileid, 0, 0, 'districtnumber', 1)	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: DistrictContactID.
employmentStaffEducationOrganizationEmploymentAssociationReference.employmentStatusDescriptor	EmploymentStatus_DX	Y	Staging rule: staffAssignment coset.codevalue	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: EmploymentStatus_DX.
employmentStaffEducationOrganizationEmploymentAssociationReference.hireDate	HireDate	Y	Staging rule: staffAssignment to_char( case when vt1.hireDate < p_firsttermday then p_firsttermday else vt1.hireDate end, 'YYYY-MM-DD' )	Required by the production resource definition when the resource is published.	JSON type: datetime. Query alias: HireDate.
employmentStaffEducationOrganizationEmploymentAssociationReference.staffUniqueId	StaffUID	Y	[SchoolStaff]Users_DCID; Transformation: EDFI_TN_LIB.getStaffUniqueId(p_profileid, ss.users_dcid)	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: StaffUID.
staffClassificationDescriptor	StaffClassification_DX	Y	Staging rule: staffAssignment vt.StaffAssignment	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: StaffClassification_DX.
beginDate	BeginDate	Y	Staging rule: staffAssignment to_char( case when vt.beginDate < p_firsttermday then p_firsttermday else vt.beginDate end, 'YYYY-MM-DD' )	Required by the production resource definition when the resource is published.	JSON type: datetime. Query alias: BeginDate.
endDate	EndDate	Conditional	Staging rule: staffAssignment case when vt.endDate < p_lasttermday then to_char(vt.endDate, 'YYYY-MM-DD') else null end	Submit when the source alias is populated and the parent structure is applicable.	JSON type: datetime. Query alias: EndDate.
positionTitle	PositionTitle	Y	Staging rule: staffAssignment CST_PUBWORKFLOW_LIB.getCodeSetShortDescription(p_profileid, 'staffClassificationDescriptors', (select STAFFASSIGNMENT from S_TN_USR_STAFFASSIGNMENTS_C c where c.unique_id = vt.unique_id and trim(StaffAssignment) is not null))	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: PositionTitle.
fullTimeEquivalency	FTE	Conditional	Staging rule: staffAssignment COALESCE(vt.federalfunding, vt.localfunding, vt.otherfunding)	Submit when the source alias is populated and the parent structure is applicable.	JSON type: string. Query alias: FTE.
orderOfAssignment	orderOfAssignment	Conditional	Staging rule: staffAssignment case when vt.federalfunding is not null then 1 when vt.localfunding is not null then 2 when vt.otherfunding is not null then 3 end	Submit when the source alias is populated and the parent structure is applicable.	JSON type: number. Query alias: orderOfAssignment.