Skip to main content
Skip table of contents

Special Education Snapshot Extract

Introduction

This extract generates a comma-delimited file used to general information about special education students.

Selection Criteria

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

Student Selection

The report selects student records from the [Students] or [ReEnrollments] tables based on the following criteria:

  • The student must not be excluded from state reporting.

  • The student must have a school enrollment associated with a school included in the report.

  • The student must be enrolled in special education.

  • The student’s school enrollment must not be excluded from state reporting.

  • The date the student entered special education must be greater than or equal to the first day of the current year.

  • The school enrollment Exit Date must occur after the Entry Date.

  • The student is HSDA-flagged.

Snapshot Selection

The report selects student records from the [Students] or [ReEnrollments] tables based on the following criteria:

  • The student must not be excluded from state reporting.

  • The student must have a school enrollment associated with a school included in the report.

  • The student must be enrolled in special education.

  • The student’s school enrollment must not be excluded from state reporting.

  • The date the student exited special education program after End of Year last year must be blank, or occur on or after the report count date.

  • The student’s school enrollment Exit Date must occur after the report count date.

  • The student’s school enrollment Entry Date must occur on or before the report count date.

  • The school enrollment Exit Date must occur after the Entry Date.

  • The student is HSDA-flagged.

Back to Top

Report Input

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

Field

Description

Select Schools

Choose one of the following:

  • Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.

  • All Schools – Includes all student records on the PowerSchool server that meet selection criteria.

Note: The All Schools option is only available when running the report from the District Office.

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.

Report Period

Choose a reporting period from the pop-up menu:

  • 40D

  • 80D

  • 120D

  • EOY

  • Summer

Count Date

Note: This parameter is only applicable to the Special Education Snapshot.

Enter the count date of the report. This is the district’s specified date for the reporting period.

Back to Top

Report Output

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

Item #

Data Element

Description

[Table]FieldName

Begin / End Position

1

District Code

PED assigned three-digit district number.

[Prefs]Name=DistrictNumber

[Prefs]Value

1/8

2

Location Code

The PED assigned three-digit school number.

The alternate school number is extracted, if populated.

Otherwise, the report extracts the Location Code from the eScholar Programs Fact Record page, which is automatically populated with the school number.

Use the following Location Codes for special education students not enrolled at an actual district location:

993 – Students who are hospitalized

997 – Students who are enrolled in a private school 

998 – Students who are homebound

999 – Students who are home schooled (cannot be used for Special Ed students)

Logic for Off-Site Students only

The report displays the Location Code (if specified) under the Program Facts tab in student setup. If the Location Code is null, then the value specified for the Off-Site Student - Building Providing Services field under the Special ED tab is displayed. If both the Location Code and Off-Site Student - Building Providing Services fields are null, then the report displays the alternate school number, if specified. Else, the School ID is displayed.

Note: If reported values are less than three digits, 0 is used in left padding.  

[Schools]Alternate_School_Number

[S_NM_STU_X]LocationCode

[Schools]School_Number

For the Summer reporting period:

[S_NM_STU_X]LocationCode

[ReEnrollments]SchoolID

[Schools]Alternate_School_Number

9/14

3

School Year

This value is automatically extracted as June 30th. The report determines the year by referencing the school year selected for the report input.

The value is extracted in the format YYYY-MM-DD.

[Terms]LastDay

15/24

4

Social Security Number

Not collected.

N/A

25/36

5

Student ID

The state assigned student identification number.

[Students]State_StudentNumber

37/48

6

Last Name

Not collected.

N/A

37/48

7

First Name

Not collected.

N/A

49/73

8

Middle Initial

Not collected.

N/A

74/88

9

Current Grade

Not collected.

N/A

89/89

10

Special Ed Teacher Name

Not collected.

N/A

92/121

11

Primary Disability

The code indicating the primary disability condition which resulted in the special education enrollment.

[S_NM_STU_X]Disability

122/151

12

Secondary Disability

The code indicating the secondary disability, if applicable.

[S_NM_STU_X]OtherDisabilities1

152/181

13

Date of Last IEP

The date on which the student last received an Individual Education Plan (IEP).

The value is extracted in the format YYYY-MM-DD

[S_NM_STU_X]LastIEPDate

182/191

14

Last Evaluation Date

The date on which the student last received a formal special education evaluation.

The value is extracted in the format YYYY-MM-DD.

[S_NM_STU_X]SpEdEvalDate

192/201

15

Service Level

Not collected.

N/A

202/231

16

Related Services

Not collected.

N/A

232/261

17

Services Provided

Not collected.

N/A

262/291

18

Special Education Teacher ID

The staff ID of the caseload teacher. This value must also be associated with a teacher in the Staff extract.

The value is extracted without dashes.

[S_NM_STU_X]CaseloadTeacherSSN

292/303

19

Annual Review Date

Not collected.

N/A

304/313

20

Trienneal Review Date

Not collected.

N/A

314/323

21

Expected Diploma Type

The pathway determined in the student’s IEP.

[S_NM_STU_X]ExpectedDiplomaType

324/353

22

Second Language Exempt

Not collected.

N/A

354/356

23

Alternate Assessment

Indicates if the student is entitled to take an alternate assessment rather than the regular state assessment, as documented in their Service Plan (IEP).

[S_NM_STU_X]AltAssess

357/359

24

Instructional Language

Not collected.

N/A

360/375

25

Communication Mode

Not collected.

N/A

376/395

26

Braille Instruction

Indicates whether the student receives braille instruction.

[S_NM_STU_X]Braille_YN

396/398

27

Special Transportation

Not collected.

N/A

399/414

28

Extended School Year

Not collected.

N/A

415/417

29

Home Schooled

Not collected.

N/A

418/420

30

Programs Code

Not collected.

N/A

421/428

31

Primary Service Code

Not collected.

N/A

429/436

32

Primary Placement Type

Not collected.

N/A

437/452

33

Date Entered Special Education

The entry date of the student’s current IEP.

[S_NM_STU_X]SpEdEntryDate

453/462

34

Date Exited Special Education

Not collected.

N/A

463/472

35

Snapshot Date

Note: This is only reported in the Special Education Snapshot.

The snapshot date depends on the submission mode selected for the report input:

  • 40D: YYYY-10-01

  • 80D: YYYY-12-15

  • 120D: YYYY-03-01

  • EOY: YYYY-06-30

  • Summer Submission: YYYY-06-29

Calculated

473/482

36

IEP Compliance

Not collected.

N/A

483/485

37

Funding Disability Primary Code

Not collected.

N/A

486/515

38

Disability Primary Cause Code

Not collected.

N/A

516/523

39

Living Setting Code

Not collected.

N/A

524/531

40

Hearing Impairment Level Code

Not collected.

N/A

532/539

41

Vision Impairment Level Code

Not collected.

N/A

540/547

42

Tertiary Disability Code

Not collected.

N/A

548/577

43

Quaternary Disability Code

Not collected.

N/A

578/607

44

Primary Setting Code

The special education setting.

See the STARS Manual Volume 2 document for a complete list:http://ped.state.nm.us/ped/STARS.html

[S_NM_STU_X]PrimarySettingCode

608/615

45

Transition IEP Status Code

Not collected.

N/A

616/623

46

N/A

Not collected.

N/A

624/643

47

N/A

Not collected.

N/A

644/644

48

N/A

Not collected.

N/A

645/654

49

N/A

Not collected.

N/A

655/657

50

N/A

Not collected.

N/A

658/660

51

N/A

Not collected.

N/A

661/676

52

N/A

Not collected.

N/A

677/692

53

N/A

Not collected.

N/A

693/695

54

N/A

Not collected.

N/A

696/715

55

N/A

Not collected.

N/A

716/740

56

N/A

Not collected.

N/A

741/760

57

N/A

Not collected.

N/A

761/763

58

N/A

Not collected.

N/A

764/783

59

Primary Area of Exceptionality

Identify the student’s Primary Exceptionality

Valid values:

G = Gifted Only or Gifted as primary and Disability as secondary

SE = Disability Only or Disability as primary and Gifted as secondary

[S_NM_STU_X]PrimaryAreaDisability59

784/793

60

N/A

Not Collected

N/A

794/803

61

Enrolled at School Year Start Indicator

Not collected.

N/A

804/806

62

N/A

Not collected.

N/A


63

N/A

Not collected.

N/A


64

N/A

Not collected.

N/A


65

N/A

Not collected.

N/A


66

N/A

Not collected.

N/A


67

N/A

Not collected.

N/A


68

N/A

Not collected.

N/A


69

N/A

Not collected.

N/A


70

N/A

Not collected.

N/A


71

N/A

Not collected.

N/A


72

N/A

Not collected.

N/A


73

N/A

Not collected.

N/A


74

N/A

Not collected.

N/A


75

N/A

Not collected.

N/A


76

N/A

Not collected.

N/A


77

N/A

Not collected.

N/A


78

Annual Review Delay Reason Code

The Annual Review Delay Reason Code. If the field is blank, the element in the report will be blank

[]S_NM_STU_X.]AnnualDelayRsnCd


79

Triennial Review Delay Reason Code

The Triennial Review Delay Reason Code. If the source field is blank, the element in the report will be blank.

S_NM_STU_X.TriennialDelayRsnCd


Back to Top

JavaScript errors detected

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

If this problem persists, please contact our support.