Special Education Events Template (New Mexico)

Tool Search: Special Education Events

The Special Education Events Template reports special education events entered on the Event Detail Editor of the NM Exceptionality (state reporting) plan where the Event is considered reportable on the As-of Date as indicated by the Submission Schedule selected on the extract editor. 

Screenshot of Special Education Events Template Editor.Special Education Events Template Editor

Report Logic

  • A record reports for each reportable Special Ed Event entered on the NM Exceptionality (state reporting) plan > Events Editor.
  • To report, at least one student enrollment in the calendar/s selected must NOT be flagged State Exclude.
  • To report, the student must NOT be flagged as Enrollment > State Exclude or in a state excluded State Grade Level code.
  • To report, the Event must be active on/before the Reporting Date selected on the extract editor AND the State Reporting End Date MUST be NULL or fall on or after the Reporting Date selected on the extract editor.

Report Editor

FieldDescription
Submission Schedule

The Submission Schedule for which data is being submitted to the state.

Reporting Date

Records report cumulatively for events entered on the Event Detail Editor of the NM Exceptionality (state reporting) plan where the Event Date occurs on or before the Reporting Date selected here AND the State Reporting End Date MUST be NULL or fall on or after the Reporting Date.

Which students would you like to include in the report?

This option allows you to narrow your search results by using one of the following options.

  • Grade - Select a single grade or multiple grades (CTRL-click or SHIFT-click to select multiple).
  • Ad Hoc Filter - Select a filter to limit results to students included in the filter.
FormatThe format in which the report will generate. Options include State Format (CSV) and HTML.
Select CalendarsThe calendar(s) from which data is pulled for the report.
Generate Extract/Submit to BatchThe report can be marked to generate immediately using the Generate Extract button or can be marked to generate at a later time using the Submit to Batch button. See the Batch Queue article for additional guidance.

Report Layout

ElementLogicType, Format, and LengthCampus DatabaseCampus Path
DISTRICT CODE

A three character district code.

AlphanumericDistrict.numberDistrict Information > State District Number
LOCATION CODE

The Location Code from the Location Code field on the NM Exceptionality (state reporting) plan on which the event of record was entered.

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 Primarythis 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 PrimaryS:Partial reports.
more than one active enrollment is marked as S:Partialthis 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: PartialN: Sped and Location Code reports.
Otherwise, this field reports null.

Alphanumeric

SEPGenericForm.
vcMax2

Special Ed > General > Documents (NM Exceptionality (state reporting) > Education Plan > Location Code

OR

School Information > State School Number

SCHOOL YEAR DATE

Reports YYYY-06-30 where YYYY is the end year for the calendar/s selected on the extract editor.

Date field, 10 characters

YYYY-06-30

N/AN/A
STUDENT ID

The state-assigned identifier for the student.

Numeric

Person.stateID

Demographics > Student State ID
EVENT TYPE CODE

The code selected in the Event Type Code field on the Event Detail Editor for the reporting event of record.

AlphanumericSEPGenericForm.
vcMax1
Special Ed > General > Documents (NM Exceptionality (state reporting) > Event Detail > Event Type Code
EVENT DATE

Reports the Event Date selected on the Event Detail Editor for the reporting event of record.

Date field, 10 characters

YYYY-MM-DD

SEPGenericForm.
smallDate1
Special Ed > General > Documents (NM Exceptionality (state reporting) > Event Detail > Event Date 
EVENT REASON CODE 1

If an Event Reason Code 1 is selected on the Event Detail editor, that code reports. Otherwise, this field reports blank.

AlphanumericSEPGenericForm.
vcMax3
Special Ed > General > Documents (NM Exceptionality (state reporting) > Event Detail > Event Reason Code 1
FillerN/AN/AN/AN/A
NONCOMPLIANCE REASON

If a Non-compliance Reason is selected on the Event Detail editor, that code reports. Otherwise, this field reports blank.

AlphanumericSEPGenericForm.
vcMax4
Special Ed > General > Documents (NM Exceptionality (state reporting) > Event Detail > Non-compliance Reason
FillerN/AN/AN/AN/A

Save