Course Template (New Mexico)

Tool Search: Course

The Course Template reports the attributes of each course.

Screenshot of Course Template Extract Editor.Course Template Extract Editor

Report Logic

  • Reports one record per unique Course > stateCode per School from the Calendar/s selected on the extract editor.
  • When the Submission Schedule is 40D, 80D, 120D, EOY, or K5P, to report the course must have at least one section that is actively scheduled on at least one day at any time the calendar/s selected.
  • When the Submission Schedule is Open Yr Round, to report the course must have at least one section that is actively scheduled on the selected Snapshot Date.

Report Editor

FieldDescription
Submission ScheduleThe Submission Schedule for which data is being submitted to the state.  The value selected determines the Standardized Date used for reporting logic.
Snapshot DateThis date field is only available if the Submission Schedule is Open Yr Round. This is the date on which the course must have at least one section actively scheduled in order to report.
Ad HocSelect a filter to limit results to those included in the filter.

Format

The format in which the report will generate. Options include HTML and Comma Separated.
Select Calendars

The calendar(s) from which data is pulled for the report.

Generate Extract/Submit to Batch

The 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.

The Submit to Batch option is NOT available if you are using the SSRS report service.

Report Example

Screenshto of Course Template Extract Example in HTML.Course Template Extract Example - HTML

Report Layout

#Element NameLogicLocation
1

 District Code 

A three character district code


Numeric, 3 digits.

District Information > District Number


District.number

2Location CodeThe state school number.

Numeric, 5 digits
School Information > State School Number

School.number
3School YearThe end year of the selected calendar(s) plus the date 06-30. For example, 2016-06-30.

Date field, 10 characters

YYYY-MM-DD

N/A
4Filler 4 N/AN/A
5Course NameThe name of the course.

Alphanumeric, 30 characters
Course > Name

Course.name
6-25Filler 6-25 N/AN/A
26Semester

Identifies the reporting period based on the Submission Schedule selected on the extract editor.

Submission ScheduleReports
40D1
80D2
120D3
EOY4
K5P5
Open Yr Round9

Numeric, 2 digits
N/A
27Course Code LongThe Course number.

Numeric, 12 digits
Course > Course Editor

Course.stateCode
28Filler 28 N/AN/A
29Alternative Course CodeThe alternative course code located on the course.

Numeric, 12 digits
Course > Course Editor

Course.number
30-77Filler 30-77N/AN/A


Save