Report 16.3: Special Education (SPED) Student Profile-List (EOY 4)

(Updated as of 05/10/2021)

Description: Reports a list of students with disabilities, students evaluated for disabilities, and associated meeting, plan, and other SPED-related information. Report includes students enrolled and exited with N470 for purposes of evaluating for special education services.

Report Type: Snapshot/Certification (EOY 4)

Data As Of:

  • EOY 4 July 1 - June 30 of reporting year

Basic Selection Criteria:

Students Included: Students with a qualifying enrollment who have an associated qualifying Special Education Record (SPED) at any time during the report period.

  • Qualifying Enrollment:

    • Most recent Open Enrollment at any time during the Report Period. The “most recent” SENR record is defined as the last enrollment based on the last Student Enrollment End Date on or after the report period start date. In cases where more than one SENR record overlap the reports period, priority is given to Primary Enrollments. In cases where more than one SENR record for a student with the same Enrollment Exit Date exists, use the top record ordered by descending order by Student Enrollment Start Date, Grade Level Code (sorted on reference key), and CDS. Note: This includes N470 SENR records.
    • Enrollment Status Code = Primary (10), Secondary (20), or short-term (30), and Non-ADA (50)
    • Default Grade Level = IN, TD, PS, KN-12
  • Qualifying Special Education (SPED) Record:

    • Most recent SPED record, with overlapping qualifying enrollment, where:
    • Meeting Type is NOT = Triennial (40)
    • Education Plan Type = IEP (100), IFSP (150), ISP (200), Eligible-No Education Plan (Parent Declined) (700), Eligible-No Education Plan (Other Reasons) (800), and Not Eligible (900)
    • Most recent SPED record, overlapping qualifying enrollment (based on Initial Parent Consent Date), with Education Plan Type = Pending (300) and Initial Parent Consent is not Null.
    • Most recent is based on: SPED Exit Date descending (if populated), then Amendment Date descending (if populated), then Meeting Date descending, then Initial Parent Consent Date
  • Student Information (SINF), Student Program (SPRG) and Student English Language Acquisition (SELA) and Foster Youth data used for selecting student subgroups (e.g. Race/Ethnicity, Homeless, EL, etc.) are selected from the most recent record that overlaps the qualifying enrollment

Note: In order for a student to appear in a particular SELPA count, they must have the SELPA code reported on the SPED record that overlaps the qualifying enrollment at the same reporting LEA as on the SPED record AND the SELPA code from the SPED record has a reporting relationship with the Reporting LEA.


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
  • SELPA Code
  • Gender
  • Ethnicity/Race
  • Grade Level
  • Primary Disability Category Code
  • Education Plan Type
  • Special Education Program Setting
  • General Education Participation Percentage Range
  • English Language Acquisition Status
  • Socio-Economically Disadvantaged
  • Title 1 Part C Migrant
  • Homeless Program Eligible
  • Foster Youth
  • Student Age – Defaults to 0 – 22 years. Calculation: 6/30/ReportingYear minus Birth Date from the most recent SINF overlapping qualifying enrollment

Report Logic:


EOY 4 Report16.3 Column 1 to 12


Column Rules
1 Reporting SELPA from SPED Field 14.15.
2 SELPA Name: Use data element name from CALPAD Security Model.
3 SENR Field 1.05 School of Attendance.
4 School Name: Use data element name from CALPADS Security Model for School Code on SENR Record
5 SPED Field 14.16 District of Special Education Accountability.
6 SPED Field 14.08 SSID
7 SPED Field 14.11 SPED Field 14.12 Student First and Last Name.
8 SENR Field 1.24 Grade Level Code
9 SINF Field 2.19 Gender
10 1) If the Student Hispanic Ethnicity Indicator (SINF Field 2.24) = Y, always roll up to Hispanic, even if one or more races are selected or the Student Race Missing Indicator (SINF Field 2.31) = Y
2) If Student Ethnicity Missing Indicator (SINF Field 2.25) = Y, roll up to Missing even if one or more races are selected or if the Student Race Missing Indicator (SINF Field 2.31) = Y
3) If the Student Hispanic Ethnicity Indicator (SINF Field 2.24) = N and the Student Race Missing Indicator (SINF Field 2.31) = Y, then roll up to Missing
4) If the Student Hispanic Ethnicity Indicator (SINF Field 2.24) = N, and the Student Race Missing Indicator (SINF Field 2.31) = N, 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, (400) Filipino) and no other race category (100, 301, 302, 303, 304, 399, 600, 700) then roll up to Asian
• 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""
11 SINF Field 2.18 – Birth Date
12 SPED Field 14.26 Primary Residence Code

EOY 4 Report16.3 Column 13 to 25


Column Rules
13 SPED Field 14.17 Special Education Referral Date.
14 SPED Field 14.19 Initial Evaluation Parental Consent Date.
15 SPED Field 14.21 Special Education Meeting Date.
16 SPED Field 14.23 Meeting Delay Code.
17 SPED Field 14.20 Special Education Meeting Type Code.
18 SPED Field 14.25 Education Plan Amendment Date
19 SPED Field 14.22 Student Special Education Meeting or Amendment Identifier.
20 SPED Field 14.27 Special Education Initial Entry Start Date.
21 SPED Field 14.24 Education Plan Type Code.
22 SPED Field 14.46 Special Education Program Exit Date.
23 SPED Field 14.49 Special Education Program Exit Reason Code.
24 SPED Field 14.28 Disability 1 Code
25 SPED Field 14.29 Disability 2 Code

EOY 4 Report16.3 Column 26 to 35


Column Rules
26 SPED Field 14.31 Special Education Program Setting Code.
27 SPED Field 14.32 Preschool Program Setting Service Location Code.
28 SPED Field 14.33 Ten or More Weekly Hours in Setting Indicator.
29 SPED Field 14.34 General Education Participation Percentage Range Code.
30 SPED Field 14.44 Special Transportation Indicator.
31 SPED Field 14.45 Parental Involvement Facilitation Code.
32 SPED Field 14.30 Infant Regional Center Service Eligibility Indicator.
33 SPED Field 14.35 Special Education Program Type Code.
34 SPED Field 14.43 Agency Representative IEP Participation Code.
35 Concatenate and separate with a comma any of the following fields where the value = “Y”:
1. SPED Field 14.36 IEP Includes Postsecondary Goals Indicator display as “IEP incl Postsec Goals”
2. SPED Field 14.37 Postsecondary Goals Updated Annually Indicator display as “Postsec Goals Updt Annually”
3. SPED Field 14.38 Postsecondary Goals Age Appropriate Transition Assessment Indicator display as “Postsec Goals Age App Trans Assmt”
4. SPED Field 14.39 Transition Services in IEP Indicator display as “Trans Serv IEP”
5. SPED Field 14.40 Supportive Services Indicator display as “Supp Serv”
6. SPED Field 14.41 Transition Services Goals in IEP Indicator display as “Trans Serv Goals IEP”
7. SPED Field 14.42 Student IEP Participation Indicator display as “Stu IEP Partic”

User Roles for Access:


EOY 4 Reports


Additional Resources

CALPADS File SpecificationsForm

Look for Special Education (SPED) tab 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 code definitions are listed in this document.