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
eSP Source Data
Tables: SCHD_STU_CRS (sc), SCHD_STU_CRS_DATES (scd), SCHD_MS (ms), SCHD_MS_SESSION (mss), REG_BUILDING (rb),
REG_ENTRY_WITH (rew)
Selection Criteria
One section association is published for each session of section in which student is enrolled where:
Student is enrolled in current year
Section is scheduled in current year
Section building is not transfer building, not out-of-district
Student is registered for section (sc.modeled = 'N')
Note: student enrollment is per section (ms), sessions are schedule-related (mss) and published as sections
Resource Output
The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
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 | eSP Source | Required? | Comments |
studentSectionAssociations |
| ||||||
studentUniqueId | E1523 | TX-UNIQUE-STUDENT-ID | ru.field_value where ru.screen_number = 10165, ru.field_number = 1 | Y | from schd_stu_course.student_id | ||
sectionReference | Y | ||||||
localCourseCode | schd_ms.course + '-' + schd_ms.course_section, add '-S' summer_school = 'Y' | Y | Same as Base Profile rules; for remote sections use schd_ms record where section was taken. | ||||
schoolId | schd_ms.building | Y | |||||
schoolYear | schd_ms.school_year | Y | |||||
sectionIdentifier | E1056 | CLASS-ID-NUMBER | schd_ms_session.section_key + '-' + schd_ms_session.course_session | Y | Publish multiple MSS as single section, sections correspond 1:1 to courseOfferings | ||
sessionName | term descriptor short description | Y | Calculated from marking periods for section using logic in Sessions resource.
| ||||
beginDate | E1069 | STUDENT-BEGIN-DATE | schd_stu_crs_dates.date_added | Y | |||
endDate | E1070 | STUDENT-END-DATE | day after schd_stu_crs_dates.date_dropped | N | Day after last day in section | ||
homeroomIndicator | E1440 | HOME-ROOM-INDICATOR | SCHD_MS_USER.field_value = 'Y' where SCHD_MS_USER.section_key = ms.section_key | TX | TX Homeroom indicator specific for TX reporting, not derived from core eSP setup | ||
TX Extensions |
|
| TX | ||||
courseCompletionIndicator | E1068 | COURSE-COMPLETION-INDICATOR | tx_stu_passfail.course_completed where tx_stu_passfail.section_key = schd_ms.section_key | TX | Moved from CourseTranscripts, consistent with current TWEDS, Dec 14, 2021 | ||
additional fields for display only |
|
|
| ||||
grade level from most recent enrollment in selected year |