Special Education Services Fact Extract

Introduction

This extract generates a comma-delimited file used to track services provided to 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 student’s school enrollment Exit Date must occur after the Enroll Date.
The student’s school enrollment Entry Date must occur on or before the Enroll Date. The Enroll Date depends on the report period selected:
- 40D: 10/01/YYYY
- 80D: 12/15/YYYY
- 120D: 03/01/YYYY
- EOY: 06/30/YYYY
- Summer Submission: 06/29/YYYY
The school enrollment Exit Date must occur after the Entry Date.
The student is HSDA-flagged.

Note: Students with the SO code are only reported in the audit version of the output. They do not show up on the extract version of the output.

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 Mode	Choose one of the following: Extract – Choose this option to run the extract version this report, which includes only the columns/fields required for submission to the state. Audit – Choose this option to run the audit version of this report. In audit mode, additional student level data will be extracted. Run the audit version of the report to verify data before running the extract version.
Report Period	Choose a reporting period from the pop-up menu: 40D 80D 120D EOY Summer
Count Date	Enter the count date of the report. This is the district’s specified date for the reporting period.

Report Output – Audit Version

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)	[Schools]Alternate_School_Number [S_NM_SCH_X]LocationCode [Schools]School_Number	9/14
3	School Year	This value is automatically extracted as June 30^th. 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	Student ID	The state assigned student identification number.	[Students]State_StudentNumber	25/36
5	Service Code	Represents the type of service received by the student. Valid Values: SS - Speech Services PT - Physical Therapy OT - Occupational Therapy SW - Social Work Services PS - Psychological Services OR - Orientation IN - Interpreter AU - Audiologist RT - Recreational Therapy RF - Certified Residential Facility Services RC - Rehabilitation Counseling Services NMSD - Receiving services at both the district and New Mexico School for the Deaf NMSBVI - Receiving services at both the district and New Mexico School for the Blind and Visually Impaired	[S_NM_STU_Service_Fact_C]ServiceCode	37/44
6	Placement Type	Not collected.	N/A
7	Compliance Date	Not collected.	N/A
8	Service Start Date	Indicates the report date.	The Enroll Date depends on the report period selected: 40D: 10/01/YYYY 80D: 12/15/YYYY 120D: 03/01/YYYY EOY: 06/30/YYYY	71/80
9	Service End Date	Not collected.	N/A
10	Service Identifier	Not collected.	N/A
11	Service Size	Information on how services are provided, relative to size. Valid values: I – Individual G – Group IG – Individual and Group Setting	[S_NM_STU_Service_Fact_C]ForeignKey_Alpha	103/104
12	Service Frequency	Not collected.	N/A
13	Service Duration	Indicates the number of minutes a student receives services on a weekly basis.	[S_NM_STU_Service_Fact_C]ServiceDuration	108/11
14	Service Cycle	Not collected.	N/A
15	Integrated Service Status	Indicates whether the student receives services within the regular education environment. Valid values: Y or N	[S_NM_STU_Service_Fact_C]IntegratedServiceStatus	122/124
16	Integrated Location Status	Not Collected.	N/A
17	Section Number	Not Collected.	N/A
18	Non-Compliance Reason	Not Collected.	N/A
19	Placement Arranged Date	Not collected.	N/A
20	Placement Status	Not collected.	N/A
21	Not Collected	Not Collected.	N/A
22	Not Collected	Not Collected.	N/A
23	Not Collected	Not Collected.	N/A
24	Not Collected	Not Collected.	N/A
25	Not Collected	Not Collected.	N/A
26	Not Collected	Not Collected.	N/A
27	Service Provider Name	Not Collected.	N/A
28	Primary Staff ID	Indicates the ID of the staff member providing the service.		329/340

Report Output – Extract Version

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.

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)	[Schools]Alternate_School_Number [S_NM_STU_X]LocationCode [Schools]School_Number	9/14
3	School Year	This value is automatically extracted as June 30^th. 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	Student ID	The state assigned student identification number.	[Students]State_StudentNumber	25/36
5	Service Code	Represents the type of service received by the student. Valid Values: SS - Speech Services PT - Physical Therapy OT - Occupational Therapy SW - Social Work Services PS - Psychological Services OR - Orientation IN - Interpreter AU - Audiologist RT - Recreational Therapy RF - Certified Residential Facility Services RC - Rehabilitation Counseling Services NMSD - Receiving services at both the district and New Mexico School for the Deaf NMSBVI - Receiving services at both the district and New Mexico School for the Blind and Visually Impaired	[S_NM_STU_Service_Fact_C]ServiceCode	37/44
6	Placement Type	Not collected.	N/A
7	Compliance Date	Not collected.	N/A
8	Service Start Date	Indicates the report date.	The Enroll Date depends on the report period selected: 40D: 10/01/YYYY 80D: 12/15/YYYY 120D: 03/01/YYYY EOY: 06/30/YYYY	71/80
9	Service End Date	Not collected.	N/A
10	Service Identifier	Not collected.	N/A
11	Service Size	Information on how services are provided, relative to size. Valid values: I – Individual G – Group IG – Individual and Group Setting	[S_NM_STU_Service_Fact_C]ForeignKey_Alpha	103/104
12	Service Frequency	Not collected.	N/A
13	Service Duration	Indicates the number of minutes a student receives services on a weekly basis.	[S_NM_STU_Service_Fact_C]ServiceDuration	108/11
14	Service Cycle	Not collected.	N/A
15	Integrated Service Status	Indicates whether the student receives services within the regular education environment. Valid values: Y or N	[S_NM_STU_Service_Fact_C]IntegratedServiceStatus	122/124
16	Integrated Location Status	Not Collected.	N/A
17	Section Number	Not Collected.	N/A
18	Non-Compliance Reason	Not Collected.	N/A
19	Placement Arranged Date	Not collected.	N/A
20	Placement Status	Not collected.	N/A
21	Not Collected	Not Collected.	N/A
22	Not Collected	Not Collected.	N/A
23	Not Collected	Not Collected.	N/A
24	Not Collected	Not Collected.	N/A
25	Not Collected	Not Collected.	N/A
26	Not Collected	Not Collected.	N/A
27	Service Provider Name	Not Collected.	N/A
28	Primary Staff ID	Indicates the ID of the staff member providing the service.		329/340

Back to Top