Special Education Caseload Manager Extract

Select Students

Choose one of the following:

• The Selected [x] 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.

Select Caseload Manager

Select the caseload teacher of the students you wish to be extracted

Snapshot Date

Enter the report snapshot date

1

SchoolID

The student’s school ID..

[Students]SchoolID

[ReEnrollments]SchoolID

2

Student ID

The locally assigned student ID number

[Students]Student_Number

3

Name

The student’s name.

[Students]LastFirst

4

CaseMgr

The student’s caseload manager.

Note: The report translates the saved SSN to the appropriate teacher name.

[S_NM_STU_X]CaseloadTeacherSSN

5

Age

The student’s age as of the user defined snapshot date.

This value is calculated.

[Students]DOB

6

DOB

The student’s date of birth.

[Students]DOB

7

Grade

The student’s grade level.

[Students]Grade_Level

[ReEnrollments]Grade_Level

8

Gender

The student’s gender.

[Students]Gender

9

Ethnicity

The student’s primary race that is entered in the Scheduling/Reporting Ethnicity field.

Valid values:

• C – Caucasian
• B – Black or African American
• H – Hispanic or Latino
• A – Asian
• I – American Indian/Alaskan Native
• P – Native Hawaiian or Other Pacific Islander

[Students]Ethnicity

If [Students]Ethnicity is H then extract from [StudentRace]RaceCd

10

80-Gifted Participation

The student’s gifted participation indicator.

[S_NM_STU_X]GiftedPartCode80_YN

11

38-SpecialEducationFlag

The student’s special education indicator.

[S_NM_STU_X]SpEd38_YN

12

PrimaryAreaofExceptionality

The student’s primary area of exceptionality.

[S_NM_STU_X]PrimaryAreaDisability59

13

Disability 1

The student’s primary disability.

[S_NM_STU_X]Disability

14

Disability 2

The student’s secondary disability.

[S_NM_STU_X]OtherDisabilities1

15

Disability 3

The student’s tertiary disability.

[S_NM_STU_X]OtherDisabilities2

16

Disability 4

The student’s quaternary disability

[S_NM_STU_X]OtherDisabilities3

17

Level

The student’s level of integration.

[S_NM_STU_X]SpEdPercentage

18

Setting

The student’s primary setting code.

[S_NM_STU_X]PrimarySettingCode

19

Speech

Receiving speech as a related service indicator.

Note: This field is not necessary for New Mexico State Reporting. This field is for district use only.

[S_NM_STU_X]RecvSpeech_YN

20

PT

Receiving physical therapy as a related service.

Note: This field is not necessary for New Mexico State Reporting. This field is for district use only.

[S_NM_STU_X]RecvPhysicalTherapy_YN

21

OT

Receiving occupational therapy as a related service.

Note: This field is not necessary for New Mexico State Reporting. This field is for district use only.

[S_NM_STU_X]RecvOccupationalTherapy_YN

22

Psych

Receiving psychological services as a related service.

Note: This field is not necessary for New Mexico State Reporting. This field is for district use only.

[S_NM_STU_X]RecvPsychologicalSvc_YN

23

Audiology

Receiving audio logical services as a related service.

Note: This field is not necessary for New Mexico State Reporting. This field is for district use only.

[S_NM_STU_X]RecvAudiologistSvc_YN

24

Deaf Int

Receiving an interpreter for deaf as a related service.

Note: This field is not necessary for New Mexico State Reporting. This field is for district use only.

[S_NM_STU_X]RecvInterpreterForDeafSvc_YN

25

O & M

Receiving orientation as a related service.

Note: This field is not necessary for New Mexico State Reporting. This field is for district use only.

[S_NM_STU_X]RecvOrientation_YN

26

Soc Worker

Receiving social worker services.

Note: This field is not necessary for New Mexico State Reporting. This field is for district use only.

[S_NM_STU_X]RecvSocialWorkSvc_YN

27

HI Level

The student’s level of hearing impairment.

[S_NM_STU_X]HearingImpaired

28

VI Level

The student’s level of vision impairment.

[S_NM_STU_X]VisionImpaired

29

Last IEP

The student’s last IEP date.

[S_NM_STU_X]LastIEPDate

30

Last Eval

The student’s last evaluation date.

[S_NM_STU_X]SpEdEvalDate

31

14+ Transition

Statement on IEP that addresses transition services need for student 14 years or older.

[S_NM_STU_X]TransitionStatementOnIep_YN

32

Mental Health

Indicates the student will receive mental health services upon exit.

[S_NM_STU_X]MentalHealthSvc_YN

33

Voc. Rehab

Indicates the student will receive vocational rehabilitation services upon exit.

[S_NM_STU_X]VocRehabSvc_YN

34

DD Services

Indicates the student will be receiving developmental disabilities services upon exit.

[S_NM_STU_X]DevDisabilitiesSvc_YN

35

Ind. Living

Indicates the student will be receiving independent living services upon exit.

[S_NM_STU_X]ndependentLivingSvc_YN

36

Post-Sec. Ed

Indicates the student will be receiving postsecondary educational services upon exit.

[S_NM_STU_X]PostSecondaryEdSvc_YN

37

Diploma Type

The student’s expected diploma type.

[S_NM_STU_X]ExpectedDiplomaType

38

12^th Grade/Transition

The student’s transition IEP status code.

[S_NM_STU_X]TransitionIEPStatus

39

Expected Grad Date

The student’s expected graduation date.

[S_NM_STU_X]ExpectGradDate

Note: Data elements listed below are pulled from Services Fact records, if any exist. Students that have multiple Services Fact records will have multiple lines in the report output (1 per Services Fact record).

40

Service Code

The Services Fact service code

[S_NM_STU_Service_Fact_C]ServiceCode

41

Placement Type

The Services Fact placement type.

[S_NM_STU_Service_Fact_C]PlacementType

42

Service Size

The Services Fact service size.

[S_NM_STU_Service_Fact_C]ForeignKey_Alpha

43

Service Frequency

The Services Fact service frequency.

[S_NM_STU_Service_Fact_C]ServiceFrequency

44

Service Cycle

The Services Fact service cycle.

[S_NM_STU_Service_Fact_C]ServiceCycle

45

Integrated Service Status

The Services Fact integrated services status.

[S_NM_STU_Service_Fact_C]IntegratedServiceStatus

46

Service Provider Name

The Services Fact service provider name.

Note: The staff member’s name is reported based on the stored SSN.

[S_NM_STU_Service_Fact_C]StaffSSN

47

Service Provider Location

The Services Fact service provider location.

[S_NM_STU_Service_Fact_C]ServiceProviderName