Report 16.14: SELPA Students with Disabilities – Plan Student List
(Updated as of 11/15/2023)
Description: Reports a list of students in the selected SELPA with disabilities and associated Education 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: Students with a qualifying enrollment who have an SWD Plan Record (PLAN) effective on the Report Date (Census Date) at the same Reporting LEA as the 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. 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, and CDS.
- Enrollment Status Code = Primary (10), Short-term (30), and Non-ADA (50)
- Default Grade Level = IN, TD, PS, TK-12
-
Qualifying Special Education (SPED) Record:
- PLAN record overlapping the report date (Census Date) and qualifying enrollment for the same Reporting LEA where Plan Effective Start Date is less than or equal to 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 is less than or equal to 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
-
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
- Primary Disability Category Code
- Education Plan Type
- Special Education Program Setting
- General Education Participation Percentage Range
- 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: Meeting Date minus Birth Date from the most recent SINF overlapping qualifying enrollment
Report Logic:
Click image to expand
Column | Rules |
---|---|
1 | PLAN Field 23.04 Reporting LEA |
2 | LEA Name – use data element name from CALPADS Security Model |
3 | Revision ID - Unique ID Created by system to differentiate each revision. |
4 | Revision Date - Date/Time snapshot was refreshed. |
5 | SENR Field 1.05 School of Attendance. |
6 | School Name: Use data element name from CALPADS Security Model for School Code on SENR Record |
7 | PLAN Field 23.10 District of Special Education Accountability. |
8 | SENR Field 1.08 SSID |
9 | SENR Field 1.10 - Field 1.12 Student First, Middle and Last Name. |
10 | SENR Field 1.24 Grade Level Code |
11 | PLAN Field 23.03 Local Record ID |
12 | SINF Field 2.19 Gender |
13 | 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 | |
• 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"" | |
14 | SINF Field 2.18 – Birth Date |
15 | PLAN Field 23.14 Primary Residence Code |
16 | SWDS Field 22.10 Special Education Initial Entry Start Date |
17 | SWDS Field 22.11 Special Education Status Effective Start Date where SWDS Field 22.12 Special Education Status Code = 1 (Eligible and Participating) |
18 | PLAN Field 23.11 Special Education Plan Type Code |
19 | PLAN Field 23.12 Special Education Plan Effective Start Date |
20 | PLAN Field 23.13 Reason For Plan Record Code |
21 | PLAN Field 23.15 Disability 1 Code |
22 | PLAN Field 23.16 Disability 1 Degree of Support |
23 | PLAN Field 23.17 Disability 2 Code |
24 | PLAN Field 23.18 Disability 2 Degree of Support |
25 | PLAN Field 23.20 Special Education Program Setting Code |
26 | PLAN Field 23.21 Preschool Program Setting Service Location |
27 | PLAN Field 23.22 Ten or More Weekly Hours in Setting Indicator |
28 | PLAN Field 23.23 General Education Participation Percentage value 00.00 format |
29 | PLAN Field 23.33 Special Transportation Indicator |
30 | PLAN Field 23.19 Infant Regional Center Services Eligibility Indicator |
31 | PLAN Field 23.24 Special Education Program Type Code |
32 | PLAN Field 23.25 IEP Includes Postsecondary Goals Indicator |
33 | PLAN Field 23.26 Postsecondary Goals Updated Annually Indicator |
34 | PLAN Field 23.27 Postsecondary Goals Age Appropriate Transition Assessment Indicator |
35 | PLAN Field 23.30 Transition Services Goals in IEP Indicator |
36 | PLAN Field 23.29 Supportive Services Indicator |
37 | PLAN Field 23.28 Transition Services in IEP Indicator |
38 | PLAN Field 23.32 Agency Representative IEP Participation Code |
39 | PLAN Field 23.31 Student IEP Participation Indicator |
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.