Tool Search: CTE_STUDENT_CREDENTIAL
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
| Field | Description |
|---|---|
| Submission Schedule | The 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.
|
Format | The format in which the report will generate. Options include State Format (CSV) or HTML. |
| Select Calendars | The 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 Name | Description | Location |
|---|---|---|
| District Code | The state district number. Alphanumeric, 20 characters | System Administration > Resources > District Information > State District Number Database: District.number |
| School Year Date | The 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 ID | Reports 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 Code | This 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
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
| 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 |
| Filler9 | Reports blank for all records. | N/A |
Delivery Method Code Setup
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.
- Go to System Administration > Custom > Attribute Dictionary > Campus Attributes/Dictionary Editor > Program Participation > Certification Name > Dictionary.
Campus Attributes/Dictionary Editor for Certification Name 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.
- Click Save.
