Report 8.1 Student Profile List (EOY3)

(Updated as of 05/10/2021)

Description: Reports a list of individual student data that supports aggregate view in the cumulative enrollment report.

Data As Of:

  • Snapshot version, any time in the reported academic year (7/1 – 6/30)

Basic selection criteria:

  • Open or closed enrollment record within the LEA at any time during the Report Period (7/1/2020 – 6/30/2021)
  • Enrollment Status = 10, 20, or 30
  • Grade level = KN-12

Report Filters: Filters can be selected resulting in only totals for the selected filter being displayed

  • 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
  • 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


Report 8.1 Student Profile List EOY 3 Column 1 to 12

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 - 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 Field 2.11 and 2.13 - The Student Legal first and last name of the student identified from birth verification document or through legal adoption, or name change)
5 SENR Field 1.09 - Identifier assigned to the student by a local educational agency.
6 SINF Field 2.19 - A coded value representing the person's gender
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 SENR Field 1.24 – Grade Level Code
9 SINF Field 2.18 – Student Birth Date
10 SINF Field 2.17 – Student Alias Last Name, SINF Field 2.15 Student Alias First Name, SINF Field 2.16 Student Alias Middle Name
11 SINF Field 2.44 – Student Preferred Last Name, SINF Field 2.43 Student Preferred First Name
12 SENR Field 1.22 – Enrollment Start Date
13 SENR Field 1.23 – Enrollment Status Code

Report 8.1 Student Profile List EOY 3 Column 13 to 24

Column Rules
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
21 SELA Field 12.14 – English Language Acquisition Status Start Date
22 SINF Field 2.22 – Student Birth Country Code
23 SINF Field 2.21 – Student Birth State Province Code
24 SINF Field 2.20 – Student Birth City
25 SINF Field 2.36 – Student Initial US School Enrollment Date K – 12
26 SINF Field 2.37 – Enrolled in US School Less Than Three Cumulative Years Indicator
27 SENR Field 1.25 - Grade Level Code equal to KN - 12, and SINF Field 2.18 - Student Birth Date equal to (determines age to be 3-21) and SINF Field 2.22 – Student Birth Country not equal to US (United States) or PR (Puerto Rico) and SINF Field 2.46 - Enrolled in US School less than 3 Cumulative Years equal to Y

Report 8.1 Student Profile List EOY 3 Column 13 to 24

Column Rules
28 SENR Field 1.29 – Student Met all UC/CSU Requirements Indicator
29 SPRG Field 3.13 - Ed Program Code = 127 (Gifted and Talented)
30 SPRG Field 3.13 - Ed Program Code = 135 (Migrant)
31 SPRG Field 3.13 - Ed Program Code = 191 (Homeless)
32 SPED Field 14.24 - Ed Plan Type = 100 (IEP), 150 (IFSP) or 200 (ISP) – overlapping qualifying enrollment
33 SELA Field 12.13 - English Language Acquisition Status Code = EL (English Learner) status effective during the report period (using effective date) regardless of Reporting LEA
34 A yes or no indication of whether the student meets socio-economically disadvantage criteria
SINF Field 2.50 – Parent Guardian Highest Grade Level Code equal to 14 - OR
SPRG Field 3.13 - Ed Program Code equal to 181 (Free NSLP) or 182 (Reduced NSLP) and SPRG 3.15 – Ed Program Membership Start Date equal to or greater than 7/1/of reporting year and SPRG 3.16 – Ed Program Membership End date blank or equal to or greater than Fall 1 Census Day – OR
SPRG Field 3.13 - Ed Program Code = 135 (Migrant) or 191 (Homeless) and SPRG 3.15 – Ed Program Membership Start Date equal to or greater than Fall 1 Census Day and SPRG 3.16 – Ed Program Membership End date blank or equal to or greater than Fall 1 Census Day – OR
Foster Youth Indicator equal to Y AND Episode Start date less than or equal to Fall 1 Census Day and Episode End Date is blank or greater than or equal to Fall 1 Census Day – OR
Direct Certification Indicator equal to Y AND Direct Certification Date less than or equal to November results – OR
Student enrolled at a Juvenile Court School on Fall 1 Census
35 SPED 14.28 - The disability category that best describes an student's condition based on the Primary Disability Code value
36 A yes or no indication of whether the student exit meets dropout criteria
SENR 1.26 – Enrollment Exit Date within Graduate/Dropout reporting window and no subsequent enrollment between 8/16 and Census day of Current Reporting Year and SENR 1.27 – Student Exit Reason Code = E140, E300, E400, T270 or T380 - OR
SENR 1.27 – Student Exit Reason Code = E230 and SENR 1.28 – Student School Completion Status = 104 or 360
37 SINF 3.13 - A yes or no indication of whether the student meets program eligibility criteria for Transitional Kindergarten program (185)
38 SPRG 3.13 – Program Code equal 192 – Armed Forces Family Member

User Roles for Access:

EOY 3 Reports


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.