Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.