Report 2.15: Language Instruction Program - Student List Report

(Updated as of 10/04/2023)

Description: Reports a list of students with Education Program Codes of 300-307 (Language Instruction Programs) as of Census Day.

Report Type: Snapshot / Certification (Fall 1)

Security Roles: Fall 1 Reports Role

Data As Of:

  • If Snapshot version, Fall 1 Census Day (First Wednesday in October)

Basic selection criteria:

Students Included:

  • Students with an open enrollment as of Report date, where the Enrollment Status equals 10 (Primary), Short-term (30) and is in Grade Levels TK – 12.
  • Students with a qualifying enrollment at the school with Education Program Codes of 300-307 on Census Day

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
  • LEA
  • Status – (Snapshot)
  • School Type
  • School
  • Grade
  • Gender
  • Ethnicity/Race
  • Title 1 Part C Migrant
  • Socio-economically Disadvantaged
  • Students with Disabilities
  • Gifted and Talented Education
  • Title lll Eligible Immigrant
  • Language Instruction Program
  • English Language Acquisition Status

Report Logic

Image of Report 2.15: Language Instruction Program - Student List Report with numbered columns for mapping

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 – SENR 1.08-SSID
4 Student name – concatenation of student legal name – SINF 2.11-Student Legal First Name, 2.12-Student Legal Middle Name, 2.13-Student Legal Last name
5 Local ID – SENR 1.09-Local Student ID
6 Gender – SINF2.19
7 Grade Level – SENR 1.24
8 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:
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"
9 English Language Acquisition Status - SELA Code 12.13
10 Primary Language - SELA Code 12.15
11 Language Instruction Program (LIP) -SPRG 3.13 (300 – 307)
Note: All records populated for the student in columns 300-307 in report 2.14 for the respective school should also populate as their own record row in report 2.15.