Resource Overview
-
Ed-Fi endpoint:
/data/v3/staffSectionAssociations -
Published view/entity: Staff Section
-
Purpose: Teachers and their role within each assigned section
-
Source query:
StaffSectionAssociation -
Dependencies:
sections,staffEducationOrganizationAssignmentAssociations
staffSectionAssociation
This association indicates the class sections to which a teacher is assigned. This resource is required for all teachers.
Primary PowerSchool Source Data
-
[Courses]
-
[Sections]
-
[SectionTeacher]
-
[Terms]
-
[Users]
-
[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
|
Data Element (Ed-Fi target) |
Data View Column Name |
Submission |
[Table]Field (PowerSchool Source) |
Business Rules |
Comments |
|---|---|---|---|---|---|
|
sectionReference.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. |
|
sectionReference.schoolYear |
SchoolYear |
Y |
Staging rule: staffSectionAssociations p_yearid + 1991 |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: SchoolYear. |
|
sectionReference.localCourseCode |
LocalCourseCode |
Y |
[Courses]DCID; [Courses]Course_number; [Sections]DCID; [Sections]ID; [Sections]Section_number; Transformation: EDFI_TN_LIB.formaLocalCourseCode(p_profileid, crs.dcid, crs.course_number, p_yearid, sec.dcid, sec.id, sec.section_number) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: LocalCourseCode. |
|
sectionReference.sectionIdentifier |
UniqueSectionCode |
Y |
[Sections]DCID; Transformation: CST_PUBWORKFLOW_LIB.formaSectionCodeBase(p_profileid, sec.dcid, p_orgid) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: UniqueSectionCode. |
|
sectionReference.sessionName |
SessionName |
Y |
[Terms]Portion; [Terms]Abbreviation; [S_TN_SEC_X]InstructionalProgramNbr; Transformation: EDFI_TN_LIB.getSessionName_3(p_profileid,t.portion, t.abbreviation,xt.InstructionalProgramNbr) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: SessionName. |
|
staffReference.staffUniqueId |
StaffUID |
Y |
users.dcid; transformation: EDFI_TN_LIB.getStaffUniqueId(p_profileid, u.dcid) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StaffUID. |
|
beginDate |
BeginDate |
Conditional |
[Terms]Firstday; [Terms]Lastday; [Sectionteacher]Start_date; [Sectionteacher]End_date; Transformation: to_char( ( select min(cd.date_value) from calendar_day cd where cd.schoolid = p_schoolid and cd.insession = 1 and cd.date_value between t.firstday and t.lastday and cd.date_value between st.start_date and coalesce(st.end_date, t.lastday) ), 'YYYY-MM-DD' ) |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: datetime. Query alias: BeginDate. |
|
classroomPositionDescriptor |
ClassroomPosition_DX |
Y |
[Sections]Teacher; [Schoolstaff]id; Transformation: case when (sec.teacher = ss.id) then 'Teacher of Record' else 'Support Teacher' end |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: ClassroomPosition_DX. |
|
endDate |
EndDate |
Conditional |
[Terms]Firstday; [Terms]Lastday;[Sectionteacher]Start_date; [Sectionteacher]End_date; Transformation: to_char( ( select max(cd.date_value) from calendar_day cd where cd.schoolid = p_schoolid and cd.insession = 1 and cd.date_value between t.firstday and t.lastday and cd.date_value between st.start_date and coalesce(st.end_date, t.lastday) ), 'YYYY-MM-DD' ) |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: datetime. Query alias: EndDate. |