CASEMIS Extract D

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.

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