Tool Search: Special Education Services Fact Template

The Special Education Services Fact Template tracks Special Education Services and contains details of services provided to special education students.

Special Education Services Fact Template Editor

Report Logic

Reports one record per enrolled student per active Service on the reporting date selected on the extract editor.
Students MUST have a student state ID to report.
Students MUST be actively enrolled in at least one qualifying calendar on the Reporting Date selected on the extract editor to report.
Students are NOT included if
- their enrollment record is marked as State Exclude;
- their enrollment record is marked as No Show;
- their Grade Level of enrollment is marked as State Exclude; or
- their Calendar of enrollment is marked as State Exclude.
Only data entered on the NM Exceptionality (state reporting) plan may report.
Plan must be active on the reporting date selected on the extract editor to report.
Service MUST be active on the reporting date selected on the extract editor to report.
Service MUST have a Service Code <> NULL to report.

Report Editor

Field	Description
Submission Schedule	The Submission Schedule for which data is being submitted to the state.
Reporting Date	The earliest date on which the student's Enrollment and Special Education Service must be active to report.
Which students would you like to include in the report?	Grade Ad Hoc Filter
Format	The format in which the report will generate. Options include HTML and State Format (CSV).
Select Calendars	The calendar(s) from which data is pulled for the report.
Generate Extract/ Submit to Batch	Users have the option of submitting a report request to the batch queue by clicking Submit to Batch instead of immediately generating the report by clicking Generate Extract. The batch process allows larger reports to generate in the background without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Report Layout

Element Name

Logic

Type, Format, and Length

Campus Database

Campus Location

District Code

A three character district code.

Numeric, 3 digits

District.number

System Administration > Resource > District Information > State District Number

Location Code

The state school number. Reports the code selected in the Location Code field on the NM Exceptionality record.

Otherwise, If the Location Code field is null, this element reports the State School Number from the student of record's active calendar of enrollment that is marked as Primary on the Reporting Date entered on the extract editor.

If...	Then...
there is more than one active enrollment marked as Primary	this value reports based on earliest start date. If the start dates are the same, the value reports based on the highest calendar ID.
there are no active enrollments marked as Primary	S:Partial reports.
more than one active enrollment is marked as S:Partial	this value reports based on earliest start date. If the start dates are the same, the value reports based on the highest calendar ID.
NONE are flagged S: Partial	N: Sped and Location Code reports.
Otherwise, this field reports null.

Numeric, 6 digits

nmExceptionalityService.
locationCode

Documents > Plan Outline nmGiftedPlan >Services Detail > Service Provided List >Services Detail > Location Code

System Administration > Resources > School > School Editor > School Detail > State School Number

School Year Date

The end year of the selected calendar(s) plus the date 06-30. For example, 2016-06-30.

Date field, 10 characters

YYYY-MM-DD

Calendar.endDate

N/A

Student ID

Reports the state-assigned identifier for the student.

Numeric, 9 digits

Person.stateID

Census > People > Demographics > State ID

Service Code

The Service Code selected on the student's reporting service of record: NM Exceptionality (state reporting) plan.

Numeric, 8 digits

nmExceptionalityService.
serviceCode

Documents>Plan Outline nmGiftedPlan >Services Detail> Service Provided List >Services Detail > Service Code

Filler6

N/A

Filler7

N/A

Service Start Date

This date reports based on the Submission Schedule selected on the extract editor. The End year value must fall within 7/1 & 6/30 of the calendar year selected.

YYYY-10-01 = 40D
YYYY-12-15 = 80D
YYYY-03-01 = 120D
YYYY-06-01 = EOY

Date field, 10 characters

YYYY-MM-DD

N/A

Filler9

N/A

Filler10

N/A

Filler11

N/A

Filler12

N/A

Service Duration

The number of minutes the service is occurring per week based on Service Frequency and Service Cycle selected.

Service Cycle	Reports...
W: Weekly	the value entered in Service Frequency Minutes.
D: Daily	the Service Frequency Minutes x 5.
M: Monthly	the Service Frequency Minutes ÷ 4.
S: Semester	the Service Frequency Minutes ÷ (the number of weeks scheduled for the full year in the student's calendar of enrollment ÷ 2) ONLY calculates when a student has an active enrollment marked as Primary in at least one calendar on the school selected in the Location field on the Services Editor; otherwise, reports blank.
Y: Yearly	the Service Frequency Minutes ÷ the number of weeks scheduled for the full year in the student's calendar of enrollment. ONLY calculates when a student has an active enrollment marked as Primary in at least one calendar on the school selected in the Location field on the Services Editor; otherwise, reports blank.

nmExceptionalityService.serviceFrequencyMinutes

nmExceptionalityService.serviceCycle

Documents > Plan Outline nmGiftedPlan > Services Detail > Service Provided List > Services Detail >

Service Frequency Minutes
Service Cycle

Filler14

N/A

Integrated Services Status

Indicates whether Integrated Services Status is selected on the student's reporting service of record: NM Exceptionality (state reporting) plan.

This field reports null if

Education Detail editor has a PRIMARY SETTING CODE in PPPS
Services Detail Editor has a SERVICE CODE in IHP, LIFT, NS, SECDEV, TRS, NMSD or NMSBVI

Alphanumeric, 1 character

Y or N

nmExceptionalityService.
integratedService

Documents >Plan Outline nmGiftedPlan > Services Detail > Service Provided List > Services Detail > Integrated Services Status

Filler16

N/A

Filler17

N/A

Filler18

N/A

Filler19

N/A

Filler20

N/A

Filler21

N/A

Filler22

N/A

Filler23

N/A

Filler24

N/A

Filler25

N/A

Filler26

N/A

Filler27

N/A

Primary Staff ID

The Staff State ID of the Staff person selected in the Service Provider Staff field.

Alphanumeric, 12 characters

Person.staffStateID

Student Information > Special Ed > General > NM Exceptionality Plan > Service Provider Staff

Census > People> Demographics > Person Identifiers > Staff State ID

Special Education Services Fact Template (New Mexico)

Report Logic

Report Editor

Report Layout

Related Articles