Resource Overview
-
Ed-Fi endpoint:
/data/v3/studentSectionAssociations -
Published view/entity: Student Section
-
Purpose: Students and their enrolled sections
-
Source query:
StudentSectionAssociation -
Dependencies:
sections,studentSchoolAssociations
This association indicates the course sections to which a student is assigned.
Primary PowerSchool Source Data
-
[CC]
-
[Courses]
-
[Students]
-
[Calendar Day]
-
[Terms]
Selection Criteria
Records are published if the following criteria are met:
-
The student was published in the Student Parent category.
-
The section was published in the Master Schedule category.
-
StudentUniqueId must be populated in PowerSchool.
-
The school must not be excluded from state reporting.
-
The section must not be excluded from state reporting.
-
The course must have a valid state course code.
-
The enrollment ExitDate is greater than the EntryDate.
-
Remote enrollments - Students taking courses in other schools within the district.
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: studentSectionAssociations 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; 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 |
Staging rule: studentSectionAssociations 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 |
[CST_PUBPUBLISHED_TMP]RUNTIMEPROP_5 |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: SessionName. |
|
studentReference.studentUniqueId |
StudentUID |
Y |
[Students]DCID; Transformation: EDFI_TN_LIB.getStudentUniqueId(p_profileid, s.dcid) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StudentUID. |
|
beginDate |
BeginDate |
Y |
[CC].DateEnrolled; transformation: to_char(cc1.DateEnrolled, 'YYYY-MM-DD') |
Required by the production resource definition when the resource is published. |
JSON type: datetime. Query alias: BeginDate. |
|
endDate |
EndDate |
Conditional |
[CC]Dateleft; [Calendar_day]Date_value; [Calendar_day]Schoolid; [Calendar_day]Insession; [Terms]firstday; [Terms]Lastday; Transformation: case when cc.dateleft is null then null else 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 < cc.dateleft ), 'YYYY-MM-DD' ) end |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: datetime. Query alias: EndDate. |
|
attemptStatusDescriptor |
AttemptStatus_DX |
Conditional |
Publishing framework or supporting query Query alias: AttemptStatus_DX |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: AttemptStatus_DX. |
|
homeroomIndicator |
HomeroomIndicator |
Conditional |
[S_TN_CRS_X]HomeroomClass_TF; [Courses]ID; Transformation: case when cx.HomeroomClass_TF = 1 or ps_customfields.getcf('courses', crs.id, 'Alt_Course_Number') in ( '0003', '0100', '0200', '0300' , '0400', '0500', '0600', '0700', '0800', '9385', '9685') then '1' else '0' end |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: boolean. Query alias: HomeroomIndicator. |