Resource Overview
-
Ed-Fi endpoint:
/data/v3/staffSchoolAssociations -
Published view/entity: Staff School
-
Purpose: Teacher or staff associated with a school
-
Source query:
StaffSchoolAssociation -
Dependencies: No resource dependency is declared.
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]
-
[S_TN_SCH_InstrProgram_C]
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 at the school during the year for the Term selected in the PowerSchool UI.
Resource Output
|
Data Element (Ed-Fi target) |
Data View Column Name |
Submission |
[Table]Field (PowerSchool Source) |
Business Rules |
Comments |
|---|---|---|---|---|---|
|
schoolReference.schoolId |
SchoolOrgID |
Y |
Publishing framework or supporting query Query alias: SchoolOrgID |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: SchoolOrgID. |
|
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. |
|
calendarReference.calendarCode |
CalendarCode |
Y |
[S_TN_SCH_InstrProgram_C]InstructionalProgramNbr |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: CalendarCode. |
|
calendarReference.schoolId |
SchoolOrgID |
Y |
Publishing framework or supporting query Query alias: SchoolOrgID |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: SchoolOrgID. |
|
calendarReference.schoolYear |
SchoolYear |
Y |
Staging rule: staffSchoolAssociations p_yearid + 1991 |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: SchoolYear. |
|
programAssignmentDescriptor |
ProgramAssignment_DX |
Y |
Staging rule: staffSchoolAssociations 'Regular Education' |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: ProgramAssignment_DX. |