CTE Student Industry Credential Extract (New Mexico)

Classic View: NM State Reporting > CTE_STUDENT_CREDENTIAL

Search Term: CTE

This tool extracts data to complete the NM CTE Student Industry Credential Extract.

CTE Student Industry Credential Editor


Report Logic

  • Reports one record per reportable student's reportable CTE certification.
  • To report, the student must be actively enrolled in at least one of the selected calendars on/between the earliest calendar Start Date and the Standardized Reporting Date represented by the Submission Schedule selected on the extract editor.
  • The CTE Program must meet the following requirements to report.
    • The Certification Date must be prior to the Standardized Reporting Date represented by the Submission Schedule selected on the extract editor.
    • Certification Date must fall on or after the earliest selected calendar's Start Date.
    • Passed must be selected on the Certification of Record.

Report Editor

FieldDescription
Submission ScheduleThe Submission Schedule for which data is being submitted to the state.
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. This is the mapped state grade level code. (CTRL-click or SHIFT-click to select multiple). 
  • Ad Hoc Filter - Select a filter to limit results to students included in the filter.

Format

The format in which the report will generate. Options include State Format (CSV) or HTML.
Select CalendarsThe calendar(s) from which data is pulled for the report.
Generate Report/
Submit to Batch
Users have the option of submitting a report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This 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 NameDescriptionLocation
District CodeThe state district number.




Alphanumeric, 20 characters
System Administration > Resources > District Information > State District Number

Database:
District.number
School Year DateThe end year of the Year selected on the Campus tool bar plus the date 06-30. For example, 2018-06-30.

Date field, 10 characters YYYY-MM-DD

N/A
Student IDReports the state-assigned identifier for the student.



Numeric, 12 digits
Census > People > Demographics > State ID

Database:
Person.stateID
Location Code

This field reports 998 for SPED students. SPED students are defined as students that have an active NM Exceptionality (State Reporting) Plan that is active on the Standardized Date where Location = 998.

Otherwise, the State School Number reports.


Alphanumeric, 12 characters
System Administration > Resources > School > School Editor > School Detail > State School Number

Database:
School.number
CIP CodeThis field always reports 0.N/A
Delivery Method Code

The value stored in the Standard Code field in the Attribute Dictionary for the Certification Name of record.

Valid Values

  • CG - College Granted Certificate
  • IS - Industry Standard Third Party Assessment

See the following Delivery Method Code Setup for more information.


Alphanumeric, 12 characters
Student Information > Academic Planning > Academic Program Editor > Career Tech Program - Certifications > Name

Database:
ProgramParticipationCertification.name
Industrial Credential Code

The code for the CTE Certification of record.

To report, the Date MUST fall on or before the Standardized Reporting Date and Passed MUST be marked on the Certification of Record.

Valid Values 

  • State Appendix D.23
  • State Appendix D.24
Alphanumeric, 12 characters
Student Information > Academic Planning > Academic Program Editor > Career Tech Program - Certifications > Name

Database:
ProgramParticipationCertification.name
Credential Earned Date

The school year of the earned credential.

Reports as YYYY-06-30 all records. YYYY is the year value based on Calendar > End Date of the reporting school year in which the credential was earned.




Date field, 10 characters YYYY-MM-DD

Student Information > Academic Planning > Academic Program Editor > Career Tech Program - Certifications > Date

Database:
ProgramParticipationCertification.date
Filler9Reports blank for all records.N/A

Delivery Method Code Setup

PATH: System Administration > Custom > Attribute Dictionary > Attributes/Dictionary > Program Participation > Certification Name > Dictionary

The value stored in the Standard Code field in the Attribute Dictionary for the Certification Name of record reports in the Delivery Method Code element on this report.

To set up the Delivery Method Code, complete the following steps.

  1. Go to System Administration > Custom > Attribute Dictionary > Campus Attributes/Dictionary Editor > Program Participation > Certification Name > Dictionary.
     
  2. Enter the Delivery Method Code for each Certification in the Standard Code field for each Code.

    The Standard Code MUST be IS or CG for a Delivery Method Code to report.

  3. Click Save.