Report 5.5 - Homeless Student List
(Updated 04/15/2024)
Description: Lists students who were reported as Homeless.
Report Type: Snapshot/Certification (EOY 3) ODS Academic Year
Security Role(s) Required:
EOY 2 Reports (If viewing reports prior to AY 2019-20)
EOY 3 Reports (If viewing reports from AY 2019-20 onwards)
Report Period:
- Snapshot version EOY 3 Report Period (July 1 thru June 30 of the reporting year)
Basic Selection Criteria
- Any open or closed enrollment within the LEA at any time during the Report Period
- Student Information record that falls wholly or in part within a qualified enrollment.
- Enrollment Status Code = 10, 20, or 30
- Grade Level = AY 2023-24 onwards (PS, TK, KN, 01-12); Prior to AY 2023-24 (TD, PS, TK, KN, 01-12, UE, US)
- Program = 191 - Dwelling type 100, 110, 120, 130
A student should ONLY be counted once within an LEA at the school with the most recent Education Program record reflecting a status of homeless, regardless of enrollment status or Specialized Services during the reporting period.
If a student is enrolled at two schools with same School Start Date, count the student in the Primarily enrolled school.
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
- Enrollment Status
- English Language Acquisition Status
- Title 1 Part C Migrant
- Student with Disabilities
- Gifted and Talented Education
- Homeless Dwelling Type
Report Logic:
| 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 | SENR 1.08 – SSID – SSID attributed to the school with the most recent enrollment within the LEA |
| 4 | SINF 2.11 – First Name and SINF 2.13 – Last Name |
| 5 | SENR 2.10 – Local ID |
| 6 | Ethnicity/Race - identified using SINF fields 2.23 (Student Hispanic Ethnicity Indicator), SINF 2.24 (Student Ethnicity Missing Indicator), SINF 2.25-2.29 (Student Race 1-5 Code), and SINF 2.30 (Student Race Missing Indicator) and the following rules: |
| 1) If the Student Hispanic Ethnicity Indicator (Field 2.23) = Y, always roll up to Hispanic, even if one or more races are selected or the Student Race Missing Indicator (Field 2.30) = Y | |
| 2) If Student Hispanic Ethnicity Missing Indicator (Field 2.23) = N or null and the Student Ethnicity Missing Indicator (Field 2.24) = 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.23) = N and the Student Race Missing Indicator (Field 2.30) = Y, then roll up to "Missing". | |
| 4) If the Student Hispanic Ethnicity Indicator (Field 2.23) = N or null, and the Student Race Missing Indicator (Field 2.30) = Y, then roll up to "Missing." | |
| 5) If the Student Hispanic Ethnicity Indicator (Field 2.23) = N or null, and the Student Race Missing Indicator (Field 2.30) = 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" | |
| Note: The above rules apply to Snapshot reports starting AY 2016-2017 and ODS reports. For ODS reports that display Ethnicity/Race and are generated in AY 2016-2017, the Filipino ethnicity will not be displayed as a separate ethnicity/race or counted within Asian ethnicity/race category. | |
| 7 | SENR 1.25 -Stu Grade Level = AY 2023-24 onwards (PS, TK, KN, 01-12); Prior to AY 2023-24 (TD, PS, TK, KN, 01-12, UE, US) |
| 8 | SPRG 3.13 – Program Code = 191 and SPRG 3.23 – Homeless Dwelling Type = 100, 110, 120, 130 |
| 9 | SPRG 3.24 – Unaccompanied Youth Indicator = Y |
| 10 | SENR 1.23 – School Start Date is within Report Period |
| 12 | SENR 1.26 – Enrollment Exit Date is blank or with Report Period |
| 13 | SELA Effective Start Date is from the most recent SELA 12.13 – English Language Acquisition Status Code |
| 14 | SELA 12.13 – ELAS Code = EO, EL, IFEP, RFEP, TBD based on the most recent SELA effective start date |
| 15 | SPRG 3.13 Program Code = 135 |
| 16 | SPED record in ODS with Education Plan Type (Field 14.24) = 100 (IEP/IFP), 150 (IFSP), or 200 (ISP) AND (Plan Set Start Date <= Reporting Period Through (End) Date and either ((Plan Set has no End date) or (Plan Set Exit Date >= Reporting Period From (Start) Date))) |
Additional Resources
CALPADS File SpecificationsForm
Look for Student Enrollment (SENR) and Student Program (SPRG) tabs for the fields indicated in the report logic.
CALPADS Data Guide
Chapter 2.1.3 provides additional information on Student Programs .
CALPADS Code Sets
This document contains the current code values referenced in the file specifications for the coded value data elements. The Program codes and dwelling code definitions are listed in this document.