CASEMIS Extract A

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 report.

Submission

Choose the appropriate submission from the pop-up menu:

• December – Choose this submission to run the report for students who were enrolled in the school on December 1^st of the reported school year.

• End of Year – Choose this submission to run the report for students who were enrolled in the school between July 1^st and June 30^th of the year selected in the years and terms dropdown.

SELPA Code

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

A-1

REPT_DATE

The date of the report.

N/A

D

6

A-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.

N/A

C

4

A-3

SELPA_FROM

The SELPA from which the student transferred.

[S_CA_STU_X]PreviousSelpa

C

4

A-4

DIST_SERV

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

[S_CA_STU_X]DistrictOfServices

C

7

A-5

DIST_RESI

The student’s district of residence.

[Students]DistrictOfResidence

C

7

A-6

SCH_CODE

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

[S_CA_SCH_X]StateSchoolNumber

[Students]SchoolID

C

7

A-7

SCH_TYPE

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

[S_CA_SCH_X]SchoolType

C

2

A-8

LAST_NAME

The student’s last name.

[Students]Last_Name

C

15

A-9

FIRST_NAME

The student’s first name.

[Students]First_Name

C

15

A-10

STUDENT_ID

The student’s local identification number.

[Students]Student_Number

C

16

A-11

SSID

The student’s statewide student identifier.

[Students]State_StudentNumber

C

10

A-12

Filler

As of the 2016-17 CASEMIS, this field is no longer collected and was deprecated March 1, 2017

N/A

N/A

N/A

A-13

BIRTHDATE

The student’s date of birth.

[Students]DOB

D

8

A-14

GENDER

The student’s gender.

[Students]Gender

C

1

A-15

ETHNICITY

Indicates whether the student is Hispanic or Latino.

Valid values:

(1) Yes is reported as 500

(0) No is reported as 501

If is neither Y or N is selected, then 900 – Intentionally Left Blank is reported.

[Students]FedEthnicity

C

3

A-16

RACE1

Student's race identification or background.

Note: The report extracts the first three ethnicities in fields A-16 – A-18.

If no race is selected, 900 – Intentionally Left Blank will be reported.

[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

A-17

RACE2

Student's race identification or background.

See A-16.

C

3

A-18

RACE3

Student's race identification or background.

See A-16.

C

3

A-19

EL

Indicates whether the student is an English learner.

[S_CA_STU_X]ELAStatus = EL

C

1

A-20

NATIV_LANG

The student’s home or birth language.

[S_CA_STU_X]PrimaryLanguage

C

2

A-21

EARLY_INT

Indicates whether the student received pre-referral early intervening services in the past years.

[S_CA_STU_X]EarlyIntervening

C

1

A-22

IN_RFRDATE

The date of infant referral (ages birth – 3) to assess and determine eligibility for special education services.

[S_CA_STU_X]InfRefAge2Date

D

8

A-23

IN_RFRBY

The name of the person who initiated infant student referral.

[S_CA_STU_X]InfReferredByCode

C

2

A-24

IN_PRNTCST

The date the district received parental consent for initial infant evaluation for Part C (ages birth – 3).

[S_CA_STU_X]InfParentConsentDate

D

8

A-25

IN_INTEVAL

The date of the IFSP Team meeting to review initial infant evaluation and determine eligibility for special education services for Part C (ages birth – 3).

[S_CA_STU_X]InfInitEvaluationDate

D

8

A-26

REFR_DATE

The date of the referral to assess and determine eligibility for Part B special education services. The student must be at least three years old for this field to be reported.

[S_CA_STU_X]RefAge2Date

D

8

A-27

REFR_BY

The person who initiated the student referral to assess and determine eligibility for Part B special education services. The student must be at least three years old for this field to be reported.

[S_CA_STU_X]ReferredByCode

C

2

A-28

PRNT_CSNT

The date the district received parental consent for the initial evaluation for Part B special education services. The student must be at least three years old for this field to be reported.

[S_CA_STU_X]ParentConsentDate

D

8

A-29

INIT_EVAL

The date of the IEP meeting to review initial evaluation and determine eligibility for Part B special education services. The student must be at least three years old for this field to be reported.

[S_CA_STU_X]InitEvaluationDate

D

8

A-30

EVLDLAY

The reason the initial evaluation is beyond the 60-day timeline.

[S_CA_STU_X]Gt60DaysReasonCode

C

2

A-31

TBDLAY

The reason for IEP to be in place after the child’s third birthday.

[S_CA_STU_X]After3rdBD

C

2

A-32

PLAN_TYPE

The type of education plan for special education services.

[S_CA_STU_X]IEPType

C

2

A-33

MIGRANT

Indicates whether the student is eligible for or participating in the Migrant Program.

[S_CA_STU_CALPADSPrograms_C]ProgramCode = 135

C

1

A-34

RESID_STAT

Indicates the student’s residential status.

[S_CA_STU_X]ResStatus

C

2

A-35

ENTRY_DATE

The date the student first entered special education.

[S_CA_STU_X]SpEntryDate

D

8

A-36

LAST_IEP

The date of the student’s last complete IEP meeting.

[S_CA_STU_X]LastIEPDate

D

8

A-37

LAST_EVAL

The date of the latest determination of initial or continued eligibility for special education.

[S_CA_STU_X]LatestEvalDate

D

8

A-38

DISABILIT1

The student’s primary disability.

[S_CA_STU_CALPADSPrograms_C]ProgramCode = 144

C

3

A-39

DISABILIT2

The student’s secondary disability, if any.

[S_CA_STU_CALPADSPrograms_C]SecondaryDisabilityCode

C

3

A-40

SOLE_LOW

The solely low incidence disability (ages infant – 2).

[S_CA_STU_X]SoleLow

C

1

A-41

INFANT_SET

The program setting for infant service (ages 0 – 2).

[S_CA_STU_X]InfSetting

C

2

A-42

FEDSET_INF

The federal program setting for infant services (ages 0 – 2).

[S_CA_STU_X]InfFedSetting

C

3

A-43

FEDSET_PRS

The federal program setting for preschool services (ages 3 – 5).

[S_CA_STU_X]PreFedSetting

C

3

A-44

FEDSET_SCH

The federal program setting for school age children. The student must be at least six years old for this field to be reported.

[S_CA_STU_X]FedSetting

C

3

A-45

IN_REGCLS

The percentage of time the student participates in general education during the school day. The student must be at least three years old for this field to be reported.

[S_CA_STU_X]RegClassPercent

C

3

A-46

GRADE

The student’s grade level.

If the Special Ed Grade Equivalency is populated on the Transfer Information page, that value will be extracted.  Otherwise, the student’s grade level will be extracted.

[S_CA_STU_X]SpEdGradeLevel

[S_CA_REN_X]SpEdGradeLevel

[Students]Grade_Level

[ReEnrollments]Grade_Level

C

2

A-47

TRAN_REG1

The student’s IEP includes appropriate measurable postsecondary goal or goals that covers education or training, employment, and, as needed, independent living?

Valid Values:

10 - Yes

20 - No

[S_CA_STU_X]TranReg1

C

2

A-48

TRAN_REG2

Is (are) the postsecondary goal(s) updated annually?

Valid Values:

10 - Yes

20 - No

[S_CA_STU_X]TranReg2

C

2

A-49

TRAN_REG3

Is there evidence that the measurable postsecondary goal(s) were based on age appropriate transition assessment?

Valid Values:

10 - Yes

20 - No

[S_CA_STU_X]TranReg3

C

2

A-50

TRAN_REG4

Are there transition services in the IEP that will reasonably enable the student to meet his or her postsecondary goal(s)?

Valid Values:

10 - Yes

20 - No

[S_CA_STU_X]TranReg4

C

2

A-51

TRAN_REG5

Do the transition services include courses of study that will reasonably enable the student to meet his or her postsecondary goal(s)?

Valid Values:

10 - Yes

20 - No

[S_CA_STU_X]TranReg5

C

2

A-52

TRAN_REG6

Is (are) there annual IEP goal(s) related to the student’s transition services needs?

Valid Values:

10 - Yes

20 - No

[S_CA_STU_X]TranReg6

C

2

A-53

TRAN_REG7

Is there evidence that the student was invited to the IEP Team meeting where transition services were discussed?

Valid Values:

10 - Yes

20 - No

[S_CA_STU_X]TranReg7

C

2

A-54

TRAN_REG8

If appropriate, is there evidence that a representative of any participating agency was invited to the IEP Team meeting with the prior consent of the parent or student who has reached the age of majority?

Valid Values:

10 - Yes

20 - No

30 - Not applicable

[S_CA_STU_X]TranReg8

C

2

A-55

SPEC_TRANS

Indicates whether special transportation is needed by the student according to the IEP.

[S_CA_STU_X]SpTrans

C

1

A-56

PARINPUT

Parent response to the question, "Did the school district facilitate parent involvement as a means of improving services and results for your child?"

[S_CA_STU_X]ParentInput

2

A-57

Filler

As of the 2016-17 CASEMIS, this field is no longer collected and was deprecated March 1, 2017

N/A

N/A

N/A

A-58

Filler

As of the 2016-17 CASEMIS, this field is no longer collected and was deprecated March 1, 2017

N/A

N/A

N/A

A-59

Filler

As of the 2016-17 CASEMIS, this field is no longer collected and was deprecated March 1, 2017

N/A

N/A

N/A

A-60

Filler

As of the 2016-17 CASEMIS, this field is no longer collected and was deprecated March 1, 2017

N/A

N/A

N/A

A-61

Filler

As of the 2016-17 CASEMIS, this field is no longer collected and was deprecated March 1, 2017

N/A

N/A

N/A

A-62

Filler

As of the 2016-17 CASEMIS, this field is no longer collected and was deprecated March 1, 2017

N/A

N/A

N/A

A-63

GRAD_PLAN

The student’s graduation plan as indicated in the IEP (grade level 8 and higher).

[S_CA_STU_X]GraduationPlan

N/A

N/A

A-64

EXIT_DATE

The date the student exited the special education program or left the SELPA.

[S_CA_STU_CALPADSPrograms_C]EndDate

D

8

A-65

EXIT_REASON

The reason the student exited the special education program or the left the SELPA.

[S_CA_STU_CALPADSPrograms_C]ExitCode

C

2