Report 2.7: English Learner Education Services - Student List

(Updated as of 12/13/2023)

Description: Reports all English Learner students with a Primary Enrollment Status as of Census Day and identifies the EL Education Services received, if any.

Report Type: ODS and Snapshot / Certification (Fall 2)

Security Roles: Fall 2 Reports

Data As Of:

  • If ODS version, user defined
  • If Snapshot version, Fall 2 Census Day (First Wednesday in October)

Basic selection criteria:

Students Included:

  • Students with an open enrollment on the “Data As Of” date
  • Students with an English Learner (EL) SELA Status Code on the date of the report
  • Enrollment Status equals 10 (Primary)
  • Grade Levels TK – 12

Course Section (CRSE) data and Student Course Section (SCSE) data are selected for the Academic Year being reported.

Course Data Rules:

  • CRSE course sections with an Education Service Code of,

    • 1 – Primary Language Instruction and Designated and Integrated English Language Development (ELD) Instruction
    • 2 – Designated ELD Instruction Only
    • 3 – Integrated ELD Instruction Only
    • 4 – Designated and Integrated ELD Instruction But Not Primary Language Instruction
    • 5 – No English Learner Services
    • 6 – Other English Learner Services

  • Course section with 0 enrollment: Not Included

  • Course section with SEID = 9999999999: Included

Report Filters: Filters can be selected resulting in only totals for the selected filter being displayed – legend on bottom of last page of report states which filter/s were selected

  • Academic Year (Snapshot)
  • LEA
  • Status – (Snapshot)
  • School Type
  • School
  • Grade
  • Gender
  • Ethnicity/Race
  • Title I Part C Migrant
  • Socio-economically Disadvantaged
  • Student with Disabilities
  • Gifted and Talented Education
  • Title III Eligible Immigrant
  • Education Service


Report Logic


Report 2.7: English Learner Education Services - Student List Description


Column Rules
1 School code is derived from user ID permission and Expected Schools table
2 School Name is determined by #1 and the Expected Schools Table
3 SSID Field 1.08 - SSID number
4 SENR Field 1.12 – Student Legal Last Name and SENR Field 1.10 – Student Legal First Name and SENR Field 1.11 – Student Legal Middle Name
5 SENR Field 1.09 - Local Student ID
6 SINF Field 2.19 - Student Gender Code
7 Ethnicity/Race - identified using SINF fields 2.24 (Student Hispanic Ethnicity Indicator), SINF 2.25 (Student Ethnicity Missing Indicator), SINF 2.26-2.30 (Student Race 1-5 Code), and SINF 2.31 (Student Race Missing Indicator) and the following rules:
1) If the Student Hispanic Ethnicity Indicator (Field 2.24) = Y, always roll up to Hispanic, even if one or more races are selected or the Student Race Missing Indicator (Field 2.31) = Y
2) If Student Hispanic Ethnicity Missing Indicator (Field 2.24) = N or null and the Student Ethnicity Missing Indicator (Field 2.25) = Y or null and Student Race 1 - 5 Codes (Fields 2.26 - 2.30) is indicated, then roll up per rules outlined in 5 below.
3) If the Student Hispanic Ethnicity Indicator (Field 2.24) = N and the Student Race Missing Indicator (Field 2.31) = Y, then roll up to "Missing".
4) If the Student Hispanic Ethnicity Indicator (Field 2.24) = N or null, and the Student Race Missing Indicator (Field 2.31) = Y, then roll up to "Missing."
5) If the Student Hispanic Ethnicity Indicator (Field 2.24) = N or null, and the Student Race Missing Indicator (Field 2.31) = N or null, and Student Race 1-5 Codes (Field 2.26 - 2.30) is indicated, then roll up as follows:
• If a single race = American Indian or Alaska Native (100), roll up to American Indian or Alaska Native
• If there is one or more of any of the Asian subgroups: ((201) Chinese, (202) Japanese, (203) Korean, (204) Vietnamese, (205) Asian Indian, (206) Laotian, (207) Cambodian, (208) Hmong, (299) Other Asian, and no other race category (100, 301, 302, 303, 304, 399, 400, 600, 700, 302, 303, 304, 399, 400, 600, 700) then roll up to Asian
• If a single race = Filipino (400) roll up to Filipino(400)
• If race includes Filipino (400) AND one or more of any of the Asian subgroups, [(201) Chinese, (202) Japanese, (203) Korean, (204) Vietnamese, (205) Asian Indian, (206) Laotian, (207) Cambodian, (208) Hmong, (299) Other Asian) and no other race category roll up to Filipino(400)
• If there is one or more of any of the Native Hawaiian/Pacific Islander subgroups ((301) Hawaiian, (302) Guamanian, (303) Samoan, (304) Tahitian, (399) Other Pacific Islander) and no other race category (100, 201, 202, 203, 204, 205, 206, 207, 208, 299, 400, 600, 700) then roll up to Hawaiian/Pacific Islander.
• If a single race = (600) Black or African American, roll up to Black or African American
• If a single race = (700) White, roll up to White
• If more than one of the following races: American Indian or Alaska Native, Asian, Black or African American, Native Hawaiian/Pacific Islander, White, roll up to "Multiple"
8 SELA 12.13 – English Language Acquisition Status Code in CALPADS Code Sets.
9 SELA 12.15 – Primary Language – See Language in CALPADS Code Sets.
10 CRSE field 9.20 - Education Service code
For a student with multiple services, a row will display for each Education Service.
However, students receiving multiple EL services will be counted in only one service at the aggregate level (Report 2.4: English Learner Education Services - Student Count Unduplicated. An “*” will indicate the service in which the student is counted in the aggregate report.
11 CRSE field 9.21 - Language of Instruction
12 # of Course Sections Served – Count of the course sections in which the student is receiving the service(s) or no service(s).

Glossary References:

English Learners

English Learner Services

Census Day

Open Enrollment