Report 8.1 Student Profile List (EOY)
(Updated 5/1/2026)
Description: Reports a list of individual student data that supports aggregate views in other reports
Report Type: Snapshot (EOY 3)
Security Roles: EOY Reports
Data As Of:
- Snapshot version, any time in the reported academic year (7/1 – 6/30)
Basic Selection criteria:
- Enrollment Status = Primary (10), Secondary (20) or Short Term (30)
- Grade Level = TK – 12
- Open enrollment at any time during the Report Period (7/1/2025 – 6/30/2026)
- Excludes one-day enrollments where Enrollment Start Date is between 7/1 – 8/15 and Completion Status is populated (aka summer grads)
- PLAN record effective during the qualifying enrollment for the same reporting LEA
Note: If a student has more than one enrollment in the LEA, both enrollments will appear in the report
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
- School Type
- School
- Grade
- Gender
- Ethnicity/Race
- Enrollment Status
- Gifted and Talented Education
- Transitional Kindergarten Program
- Socio-economically Disadvantaged
- English Language Acquisition Status
- Long-Term English Learner
- Title I Part C Migrant
- Title III Eligible Immigrant
- Students with Disabilities
- Exit Reason
- Completion Status
- Homeless Program Eligible
- Cumulative Enrollment Type
- Student School Transfer Code
- District of Geographic Residence
Report Logic
| # | Column | Description |
|---|---|---|
| 1 | School Code | Derived from user ID permission and Expected Schools table |
| 2 | School Name | Determined by #1 and the Expected Schools Table |
| 3 | SENR Field 1.08 | Unique identifier for the student assigned by the first California district of enrollment. This number follows the student throughout their enrollment within the California educational system |
| 4 | SINF Fields 2.13, 2.11, 2.12 | Student Legal Last Name, Legal First Name, and Legal Middle Name |
| 5 | SENR Field 1.09 | Identifier assigned to the student by a local educational agency |
| 6 | SINF Field 2.19 | Student Gender Code |
| 7 | Ethnicity/Race | Identified using SINF fields 2.24 (Student Hispanic Ethnicity Indicator), 2.25 (Student Ethnicity Missing Indicator), 2.26–2.30 (Student Race 1–5 Code), and 2.31 (Student Race Missing Indicator) per the following rules: 1. If Field 2.24 = Y, always roll up to Hispanic, even if one or more races are selected or Field 2.31 = Y 2. If Field 2.25 = Y, roll up to Missing, even if one or more races are selected or Field 2.31 = Y 3. If Field 2.24 = N and Field 2.31 = Y, roll up to Missing 4. If Field 2.24 = N and Field 2.31 = N: • Single race = 100 → American Indian or Alaska Native • One or more Asian subgroups (201–208, 299, 400) and no other race category (100, 301–304, 399, 600, 700) → Asian • One or more Hawaiian/Pacific Islander subgroups (301–304, 399) and no other race category (100, 201–208, 299, 400, 600, 700) → Hawaiian/Pacific Islander • Single race = 600 → Black or African American • Single race = 700 → White • More than one of the above race categories → Multiple |
| 8 | SENR Field 1.24 | Grade Level Code |
| 9 | SINF Field 2.18 | Student Birth Date |
| 10 | SINF Fields 2.17, 2.15, 2.16 | Student Alias Last Name, Alias First Name, and Alias Middle Name |
| 11 | SINF Fields 2.44, 2.43 | Student Preferred Last Name and Preferred First Name |
| 12 | SENR Field 1.22 | Enrollment Start Date |
| 13 | SENR Field 1.23 | Enrollment Status Code |
| # | Column | Description |
|---|---|---|
| 14 | SENR Field 1.25 | Enrollment Exit Date |
| 15 | SENR Field 1.26 | Student Exit Reason Code |
| 16 | SENR Field 1.27 | Student School Completion Status |
| 17 | SENR Field 1.30 | Student School Transfer Code |
| 18 | SENR Field 1.31 | District of Geographic Residence Code |
| 19 | SELA Field 12.15 | Primary Language Code |
| 20 | SELA Field 12.13 | English Language Acquisition Status Code — most recent status in report period |
| 21 | SELA Field 12.14 | English Language Acquisition Status Start Date |
| 22 | EL Enrollment Indicator | Yes/No indicator of whether the student was EL during qualifying enrollment |
| 23 | SELA Field 12.14 | If EL Enrollment Indicator = Y, the most recent ELAS Start Date where Status Code = EL within the qualifying enrollment |
| 24 | SINF Field 2.22 | Student Birth Country Code |
| 25 | SINF Field 2.21 | Student Birth State/Province Code |
| 26 | SINF Field 2.20 | Student Birth City |
| 27 | SINF Field 2.36 | Student Initial US School Enrollment Date (K–12) |
| 28 | SINF Field 2.37 | Enrolled in US School Less Than Three Cumulative Years Indicator |
| 29 | Recently Arrived EL Criteria | SENR Field 1.25 (Grade Level) = KN–12, AND SINF Field 2.18 (Birth Date) determines age to be 3–21, AND SINF Field 2.22 (Birth Country) ≠ US or PR, AND SINF Field 2.46 (Enrolled in US School Less Than 3 Cumulative Years) = Y |
| # | Column | Description |
|---|---|---|
| 30 | Student Met All UC/CSU Requirements Indicator | SENR Field 1.29 Student Met All UC/CSU Requirements Indicator |
| 31 | Gifted and Talented | SPRG Field 3.13 Ed Program Code = 127 (Gifted and Talented) |
| 32 | Title I Part C Migrant | Includes students eligible for the Migrant Program, identified via weekly Migrant Student Information Network (MSIN) data file provided to CDE. For AY 2024–25 and prior, SPRG Program Code 135 is used to populate this field. |
| 33 | Homeless | SPRG Field 3.13 Ed Program Code = 191 |
| 34 | SWDS Field 22.12 | Special Education Status Code = 1 (Eligible and Participating) — effective on or during the report period |
| 35 | EL + RFEP Indicator | SELA Field 12.13 (ELAS Code) = EL (English Learner) or RFEP (Reclassified Fluent English Proficient), effective during the report period regardless of Reporting LEA. Note: Represents a student considered EL + RFEP if identified as such at any point during the reporting period, even if that status was later corrected. This aligns with cohort definition and maintains the integrity of the original EL designation. |
| 36 | Socioeconomically Disadvantaged | Yes/No indication of whether the student meets socioeconomically disadvantaged criteria via any of the following: • SINF Field 2.50 (Parent/Guardian Highest Grade Level Code) = 14 (Not a High School Graduate) • SPRG Field 3.13 = 181 (Free NSLP) or 182 (Reduced NSLP), AND SPRG Field 3.15 ≥ 7/1 of reporting year, AND SPRG Field 3.16 is blank • SPRG Field 3.13 = 191 (Homeless) or 193 (Tribal Foster Youth), AND SPRG Field 3.15 ≥ Fall 1 Census Day, AND SPRG Field 3.16 is blank or ≥ Fall 1 Census Day • Student identified as migrant via weekly MSIN data file • Foster Youth Indicator = Y, AND Episode Start Date ≤ Fall 1 Census Day, AND Episode End Date is blank or ≥ Fall 1 Census Day • Direct Certification Indicator = Y, AND Direct Certification Date ≤ January results • Student enrolled at a Juvenile Court School on Fall 1 Census Day |
| 37 | SPED Field 14.25 | Disability Code 1 — from the most recent PLAN record during the report period that overlaps the most recent SWDS record where Status = 1 (Eligible and Participating) |
| 38 | Dropout Indicator | Yes/No indication of whether the student exit meets dropout criteria: SENR Field 1.26 (Enrollment Exit Date) falls within the Graduate/Dropout reporting window with no subsequent enrollment between 8/16 and Census Day of the current reporting year, AND SENR Field 1.27 (Exit Reason Code) = E140, E300, E400, or T380 — OR — Exit Reason Code = E230 AND SENR Field 1.28 (Student School Completion Status) = 360 |
| # | Column | Description |
|---|---|---|
| 39 | Armed Forces Family Indicator | SPRG Field 3.13 Ed Program Code = 192 (Armed Forces Family Member) |
| 40 | Parent Education Indicator | Yes/No indicator based on Parent/Guardian 1 (SINF Field 2.38) and Parent/Guardian 2 (SINF Field 2.50) Highest Education Level: • If both = 14 (Not a HS Graduate) → N • If at least one = 13 (HS Graduate), 12 (Some College or Associate's Degree), 11 (College Graduate), or 10 (Graduate Degree or Higher) → Y |
| 41 | Parent Guardian 1 Education | SINF Field 2.38 = 14 (Not HS Graduate). |
| 42 | Parent Guardian 2 Education | SINF Field 2.50 = 14 (Not HS Graduate). |
| 43 | Long-Term EL Indicator | Yes/No if EL for ≥7 years prior to end of cohort period. |
| 44 | LTEL Start Date | The date the student was or will possibly be an EL for seven years after initially becoming an EL. Calculated as the earliest of the following three dates plus 7 years: (1) Earliest SELA where Status = EL; (2) Earliest SENR record where Enrollment Status = 10 or 30 and exit reason ≠ N470 and grade level is TK or higher; (3) Initial US Enrollment Start Date from most recent SINF. Note: Populated if: (1) the most recent ELAS status = EL, RFEP, or ADEL, and (2) the LTEL Start Date is before the student becomes RFEP or ADEL (if applicable). |
| 45 | Initial US Enrollment Date (LTEL) | SINF Field 2.36 Student Initial US Enrollment Date (K–12), from the most recent SINF record during the report period. Populated only if the LTEL Start Date is populated. |
| 46 | Earliest Enrollment Start Date | SENR Field 1.22 Enrollment Start Date from the student's earliest SENR record where Enrollment Status = 10 or 30 and Enrollment Exit Reason ≠ N470. Populated only if the LTEL Start Date is populated, derived from CALPADS records regardless of which LEA submitted the record. |
| 47 | Earliest ELAS Start Date | SELA Field 12.14 English Language Acquisition Status Start Date — earliest for the student where Status = EL. Populated only if the LTEL Start Date is populated. |
Additional Resources
CALPADS File SpecificationsForm
Look for Student Enrollment (SENR) and Student Information (SINF) tabs for the fields indicated in the report logic.
CALPADS Data Guide
Chapter 2.1.6 provides additional information on Cumulative Enrollment and Student Absence.
CALPADS Code Sets
This document contains the current code values referenced in the file specifications for the coded value data elements. The program code definitions are listed in this document.