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 |
|