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 for remote sections use schd_ms record where section was taken.
		sessionName			term descriptor short description	Y	Calculated from marking periods for section using logic in Sessions resource. Terms from REG_MP_WEEKS (mpw) linked to SCHD_MS (ms) via SCHD_MS_MP (msmp) msmp.section_key = ms.section_key mpw.marking_period = msmp.marking_period and mpw.building = ms.building and mpw.school_year = ms.school_year Note that a trimester calendar may have 4 marking periods but only 3 terms, with 2 marking periods having the same term number.
	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 and SCHD_MS_USER.screen_number = 100, field_number = 24	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