Staff Employment | PowerSchool SIS Tennessee

Resource Overview

Ed-Fi endpoint: /data/v3/staffEducationOrganizationEmploymentAssociations
Published view/entity: Staff Employment
Purpose: Staff employment with the district/LEA
Source query: StaffEduOrgEmployAssociation
Dependencies: staffs

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.

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

Data Element (Ed-Fi target)	Data View Column Name	Submission	[Table]Field (PowerSchool Source)	Business Rules	Comments
educationOrganizationReference.educationOrganizationId	EduOrgID	Y	Staging rule: staffEmployment 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: EduOrgID.
staffReference.staffUniqueId	StaffUID	Y	Staging rule: staffEmployment 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.
credentialReference.credentialIdentifier	CredentialIdentifier	Y	Publishing framework or supporting query Query alias: CredentialIdentifier	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: CredentialIdentifier.
credentialReference.stateOfIssueStateAbbreviationDescriptor	StateOfIssueAbbrev_DX	Y	Publishing framework or supporting query Query alias: StateOfIssueAbbrev_DX	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: StateOfIssueAbbrev_DX.
employmentStatusDescriptor	EmploymentStatus_DX	Y	Staging rule: staffEmployment coset.codevalue	Required by the production resource definition when the resource is published.	JSON type: string. Query alias: EmploymentStatus_DX.
hireDate	HireDate	Y	Staging rule: staffEmployment to_char( case when vt.hireDate < p_firsttermday then p_firsttermday else vt.hireDate end, 'YYYY-MM-DD' )	Required by the production resource definition when the resource is published.	JSON type: datetime. Query alias: HireDate.
department	Department	Conditional	Staging rule: staffEmployment case WHEN length(sched_department) < 4 THEN sched_department ELSE NULL END	Submit when the source alias is populated and the parent structure is applicable.	JSON type: string. Query alias: Department.
endDate	EndDate	Conditional	Staging rule: staffEmployment 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.
fullTimeEquivalency	FullTimeEquivalency	Conditional	Staging rule: staffEmployment case ss.workStatus when 'F' then '1' when 'P' then '.5' else null end	Submit when the source alias is populated and the parent structure is applicable.	JSON type: number. Query alias: FullTimeEquivalency.
hourlyWage	HourlyWage	Conditional	Publishing framework or supporting query Query alias: HourlyWage	Submit when the source alias is populated and the parent structure is applicable.	JSON type: number. Query alias: HourlyWage.
offerDate	OfferDate	Conditional	Publishing framework or supporting query Query alias: OfferDate	Submit when the source alias is populated and the parent structure is applicable.	JSON type: datetime. Query alias: OfferDate.
separationDescriptor	Separation_DX	Conditional	Publishing framework or supporting query Query alias: Separation_DX	Submit when the source alias is populated and the parent structure is applicable.	JSON type: string. Query alias: Separation_DX.
separationReasonDescriptor	SeparationReason_DX	Conditional	Publishing framework or supporting query Query alias: SeparationReason_DX	Submit when the source alias is populated and the parent structure is applicable.	JSON type: string. Query alias: SeparationReason_DX.