Skip to main content
Skip table of contents

CASEMIS Extract D

Contents

Introduction

This extract is designed to report student level data, including post-secondary plans, to the CDE. The extract file contains one record for each student who exited a CASEMIS program or SELPA during the previous school year, excluding those students who returned to regular education, transferred to another program, or who are deceased.

Note: The report date range is defined by the first and last day of the previous school year, defined via Start Page > School Setup > Years & Terms. Verify that you are logged into the correct school and the current school year when running the report.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The report selects which student records to use based on the following criteria:

  • The student must not be excluded from state reporting.
  • The student's school of enrollment must not be excluded from state reporting.
  • The student must have exited a CALPADS Program Record with an Education Program Code equal to 144 during the previous school year.
  • The student must have a valid Special Education Exit Code for the 144 program record during the previous school year (excluding codes 70, 76, and 77).
  • The student must be assigned an IEP Type of 10 (IEP or IFSP) or 20 (ISP, grade K and higher).

Report Input

This report is run at the School and District level.

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Use

If run at the district level, choose one of the following from the pop-up menu:

  • Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria.
  • Current School Only – Includes all records associated with the current school that meet the selection criteria.
  • District Wide – Includes all records on the PowerSchool server that meet the selection criteria.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Students to Include

Indicate which students to include in the report by selecting one of the following options:

  • The selected [number] students only – Run the report for students in the current selection.
  • All students – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to running the ]report.

Data to be Filled

Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.

SELPA Code

Enter the Special Education Local Plan Area (SELPA) Code.

Back to top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Report Output Format: The report output format for this report is comma delimited.

Item #

Data Element

Description

 [Table]FieldName

Field Type

Field Length

D-1

REPT_DATE

The date of the report.

Note: This field is required.

N/A

D

8

D-2

SELPA_CODE

The Special Education Local Plan Area (SELPA) code entered at report runtime. This is the administrative unit under which a student receives special education and related services and through which special education funding is allocated.

Note: This field is required.

N/A

C

4

D-3

DIST_SERV

The district, county office, or state-operating program site providing the majority of services and/or receiving funds.

This field is reported as the District of Services on the CASEMIS page, if populated, otherwise the district code is reported.

Note: This field is required.

[S_CA_STU_X]DistrictOfServices

C

7

D-4

DIST_RESI

The student’s district of residence.

Note: This field is required.

[Students]DistrictOfResidence

C

7

D-5

SCH_CODE

The 7-digit code of the school where the student is enrolled.

Note: This field is required.

[S_CA_SCH_X]StateSchoolNumber

[Students]SchoolID

C

7

D-6

SCH_TYPE

The type of school or program where the student receives the majority of instructional service.

Note: This field is required.

[S_CA_SCH_X]SchoolType

C

2

D-7

LAST_NAME

The student’s last name.

Note: This field is required.

[Students]Last_Name

C

15

D-8

FIRST_NAME

The student’s first name.

Note: This field is required.

[Students]First_Name

C

15

D-9

STUDENT_ID

The student’s locally assigned identifier.

Note: This field is required.

[Students]Student_Number

C

16

D-10

SSID

The student’s statewide student identifier.

[Students]State_StudentNumber

C

10

D-11

SSN

The student’s social security number.

Note: If the student’s SSN is not available, leave this field blank.

[Students]SSN

C

9

D-12

BIRTHDATE

The student’s date of birth.

Note: This field is required.

[Students]DOB

D

8

D-13

GENDER

The student’s gender.

Note: This field is required.

[Students]Gender

C

1

D-14

ETHNICITY

The student’s ethnicity. If this field is blank for the student, then the value 900 is reported.

Valid values:

  • 500 – Yes, Hispanic or Latino
  • 501 – Not Hispanic or Latino
  • 900 – Intentionally left blank

[Students]Fedethnicity = 1, reported as 500

[Students]FedEthnicity = 0, reported as 501

[Students]FedEthnicity = 2, value reported as 900

C

3

D-15

RACE1

The student’s first race identification.

[StudentRace]Racecd = 100

[StudentRace]Racecd = 600

[StudentRace]Racecd = 700

[StudentRace]Racecd = 299

[StudentRace]Racecd = 205

[StudentRace]Racecd = 301

[StudentRace]Racecd = 399

[StudentRace]Racecd = 208

[StudentRace]Racecd = 303

[StudentRace]Racecd = 207

[StudentRace]Racecd = 202

[StudentRace]Racecd = 304

[StudentRace]Racecd = 201

[StudentRace]Racecd = 203

[StudentRace]Racecd = 204

[StudentRace]Racecd = 400

[StudentRace]Racecd = 206

[StudentRace]Racecd = 302

C

3

D-16

RACE2

The student’s second race identification.

See D-15.

C

3

D-17

RACE3

The student’s third race identification.

See D-15.

C

3

D-18

DISABILIT1

The student’s primary disability.

[S_CA_STU_CALPADSProgramsC]ProgramCode = 144

[S_CA_STU_CALPADSProgramsC] PrimaryDisabilityCode

 

 

D-19

DISABILIT2

The student’s secondary disability, if any.

[S_CA_STU_CALPADSProgramsC]ProgramCode = 144

[S_CA_STU_CALPADSProgramsC] PrimaryDisabilityCode

 

 

D-20

PST_SECPRG

The student’s post-secondary program participation, e.g. community college, GED program, military training, etc. The program may be full or part-time.

Note: This field is required.

[S_CA_STU_X]Post2ndProgram

C

3

D-21

PST_SECMP

Indicates whether the student is employed in a competitive labor market on a full or part-time basis with compensation at or above minimum wage and commensurate with the position. If the student is employed, but their employment does not meet the competitive employment criteria, report 30 (Some other employment). If the student is not employed, report 29 (No).

Valid values:

  • 10 – Yes
  • 20 – No
  • 30 – Some other employment
  • 80 – Not able to contact
  • 85 – Refused to answer

Note: This field is required.

[S_CA_STU_X]CompEmployment

C

2

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.