Student Sections
Student sections refer to the specific classes or instructional units that students are enrolled in.
Student Information: Details about the student, including unique identifiers and demographic information.
Section Information: Information about the section, such as the course it belongs to, the teacher, and the schedule.
Enrollment Details: Specifics about the student’s enrollment in the section, including start and end dates, and any special considerations or accommodations.
studentSectionAssociations
Primary PowerSchool Source Data
Tables: CC, SECTIONS (sec), STUDENTS (s), TERMS (t), COURSES (crs)
Selection Criteria
One record published for each student enrollment in a section during the current school year where:
Student, Section, School not excluded from Ed-Fi or state reporting
Section included in CourseOfferings
Includes sections taken at a different school from enrollment school
Includes sections derived from hand-entered StoredGrades records
Resource Output
A student record is published for each student enrolled in the district in the year for the Term selected in the PowerSchool UI.
The student resource is not dependent on the prior publishing of other Ed-Fi resources.
Note: After a student record is uploaded, it cannot be modified until a studentSchoolAssociation record in the Student Enrollment category has also been uploaded for the same student.This establishes a relationship between the school, the associated LEA, and the student.
The LEA then has permission to modify the previously uploaded Student record.
LEAs and Schools may upload (publish) data to the ODS in real-time or on-demand ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Resource | Data Element | Description | TX Element | TX Element Name | Stored in [Table]Field | Required? |
---|---|---|---|---|---|---|
studentUniqueId | E1523 | TX-UNIQUE-STUDENT-ID | State-assigned number for student (STUDENTS.state_studentnumber) | Y | ||
sectionReference | Y | |||||
localCourseCode | sec.course_number | Y | ||||
schoolId | State-assigned number based on SECTIONS.schoolId | Y | ||||
schoolYear | TERMS.yearid + 1991 | Y | ||||
sectionIdentifier | E1056 | CLASS-ID-NUMBER | Sections: S_TX_SEC_X.E1056_SectionIden_Calc | Y | ||
sessionName | Composite using TERMS.schoolid, TERMS.abbreviation, TERMS.dcid | Y | ||||
beginDate | E1069 | STUDENT-BEGIN-DATE | CC.dateenrolled - also need manual entry stored grades records added here | Y | ||
endDate | E1070 | STUDENT-END-DATE | CC.dateleft | N | ||
homeroomIndicator | E1440 | HOME-ROOM-INDICATOR | S_TX_CRS_X.E1440_Homeroom_Section Flag above must be 1 (true) and Service Id for section must be in list at right. | TX | ||
TX Extensions |
|
| TX | |||
courseCompletionIndicator | E1068 | COURSE-COMPLETION-INDICATOR | true if student has final grade in Storedgrades or if student was enrolled through end of course or course part, otherwise false. Override in S_TX_SGR_X.E1068. | TX | ||
additional fields for display only |
|
|
| |||
sch.school_name | ||||||
s.student_number | ||||||
s.lastfirst | ||||||
s/r.grade_level | ||||||
crs.course_name | ||||||
sec.section_number | ||||||
t.abbreviation |