Report 16.6: SELPA Students with Disabilities – Student Services Profile - List (Fall 1)

(Pending Update)

Description: Reports a list of students with disabilities within the SELPA receiving services and associated meeting and plan information

Report Type: Snapshot / Certification (Fall 1)

Security Roles: SELPA Reports

Data As Of: - Snapshot version Fall 1: Census Day

Basic selection criteria:

  • Students Included: SStudents with a qualifying enrollment who have an SWD Plan record (PLAN) and services (SERV records) effective on the Report Date (Census Date) at the same Reporting LEA as the qualifying enrollment and SWDS status of Eligible and Participating on the Report Date.

    • Qualifying Enrollment:

      • Most Recent Open Enrollment at any time during the Report Period (See CALPADS Glossary: Enrollment, Open; Report Period). Most Recent = 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 within an LEA, priority is given to Primary Enrollments, Short Term, then Non ADA 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.
      • Enrollment Status Code = Primary (10), or short-term (30), 50 (Non-ADA)
      • Default Grade Level = IN, TD, PS, KN-12
    • Qualifying Special Education Data:

      • SERV record overlapping report date (Census Date) and qualifying enrollment for same Reporting LEA where Plan effective start date <= the report date and (derived) Plan Effective End date > = the report date.
      • Most recent SWDS record on Census Date for the student has Status Code of Eligible and Participating where Status Effective Start date <= the report date and (derived) Status Effective End date > = the report 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:

    • For a student to appear in a SELPA count, they must have the SELPA code reported on the SERV record that overlaps the qualifying enrollment at the same reporting LEA as on the SENR record AND the SELPA code from the SERV record has a reporting relationship with the Reporting LEA.
    • This report displays LEA totals for the students within the SELPA. Please note, the LEA totals are only including aggregates from the students that belong to the SELPA.

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
  • SELPA
  • LEA
  • Status
  • Gender
  • Ethnicity/Race
  • Grade Level
  • Service Category
  • Education Plan Type
  • English Language Acquisition Status
  • Socio-Economically Disadvantaged
  • Title I Part C Migrant
  • Homeless Program Eligible
  • Foster Youth
  • Student Age – Defaults to 0 – 22 years. Calculation: Census Date minus Birth Date from the most recent SINF overlapping qualifying enrollment

Report Logic:


SELPA Report 16.16 Screenshot

Click image to expand


Column Rules
1 LEA Code - Reporting LEA
2 LEA Name - Use data element name from CALPADS Security Model
3 Revision ID - Unique ID created by the system to differentiate each revision
4 Revision Date - Revision Date is date/ time snapshot was refreshed(Revision Date/ time)
5 School Code: derived from user ID permission and Expected Schools table
6 School Name: determined by #3 and the CALPADS Security Model.
7 Nonpublic Agency Identifier (NPA) -Nonpublic Agency Identifier (NPA in Special Education Division's Nonpublic Agency Database)
8 District of Special Education Accountability
9 SSID: 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
10 Student Name: 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)
11 SENR Field 1.24 Grade Level
12 Local Record ID
13 SINF Field 2.19 Student Gender Code
14 Ethnicity/Race:
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,amd Student Race 1-5 Codes (Field 2.26 - 2.30) is indicated, then roll up as follows:
7) 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
8) If a single race = Filipino (400) roll up to Filipino(400)
9) 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)
10) 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.
11) If a single race = (600) Black or African American, roll up to Black or African American
12) If a single race = (700) White, roll up to White
13) 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
15 Birth Date: SINF 2.18 (Student Date of Birth)
16 Initial Service Start Date
17  Eligible and Participating Start Date From SWDS where Status code = 1(Eligible and Participating)
18  Plan Type Code & Description
19  Special Education Plan Effective Start Date
20  Reason for Plan Record Code
21  Primary Disability I Code
22  Disability Code 2
23  Service Code
24  Service Provider Code + Description
25  Service Location Code + Description
26  Service Frequency Code + Description
27  Service Duration (e.g., 0030)


Additional Resources

CALPADS Code Sets

List of frequently asked Special Education-related questions for CALPADS.

CALPADS File SpecificationsForm

Look for Special Education (SPED) tab for the fields indicated in the report logic.

CALPADS Data Guide

Provides additional information on Special Education and Student Services.

CALPADS Code Sets

This document contains the current code values referenced in the file specifications for the coded value data elements. The code definitions are listed in this document.