eSchoolPlus Texas
eSchoolPlus Texas
Breadcrumbs

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