Tool Search: CTE
The CTE Data Collections extract reports students in state grades 09 - 12 who are enrolled in a CTE Program. Students report once per CTE Program in which they are enrolled when the Report Type is Enrollment File. Students only report once when the Report Type is Outcome File.
CTE Data Collections Editor
Read - Access and generate the CTE report.
Write - N/A
Add - N/A
Delete - N/A
See the Tool Rights article for more information about Tool Rights and how they function.
Report Logic
- Reports all students that meet both of the following:
- Enrolled in state grade 09-12 (any enrollment type) at any time from the extract editor start date through the extract editor end date.
- .Enrolled in a CTE program from the extract editor start date to the extract editor end date.
- Program Admin > Academic Programs > Program Type = CTE
- Enrollment File
- Reports one record per student, per CTE active program within extract editor start and end dates.
- Reports one record per unique course/CIP code combination.
- Outcome File
- Students only report one time.
- If a student has more than one CTE program, the most recent CTE Program information reports.
- If the student has more than one CTE program with the same start and end dates, the program with the highest ID reports.
Report Editor Fields
| Field | Description |
|---|---|
| Report Type | Enrollment File: Students report once per CTE Program in which they are enrolled. Outcome File: Students only report one time. |
| Start Date | The Start Date of the testing window. Students must be enrolled during the testing window date range. |
| End Date | The End Date of the testing window. Students must be enrolled during the testing window date range. |
| Run Date | Defaults to the current date. |
| File Identifier | The submission number. |
| Format | The format in which the report generates:
|
| Which students would you like to include in the report? |
|
| Select Calendars | The calendar(s) from which data is pulled for the report. |
| Generate Report | The report appears in a separate window in the designated format. |
| Submit to Batch | This process allows larger reports to be generated in the background without disrupting the use of Campus. See the Batch Queue article for more information about submitting a report to the batch queue. |
Report Layout
| Element | Logic | Location | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LEA | The two-digit State designation of the LEA. | District Info > State District Number | |||||||||||||||||||||
School Number | The school number associated with the student’s enrollment. If the Home School field is null, this element reports from the State School field from the school tied to the enrollment. | Enrollment > State Reporting Fields > Home school School Information > State School | |||||||||||||||||||||
Statewide Unique Identifier | Unique student statewide identifier (MSDE Assigned). | Demographics > Student State ID | |||||||||||||||||||||
Local Student Number | Unique locally assigned student number. | Demographics > Student Number | |||||||||||||||||||||
Last Name | The student's last name. Reports the last name from the current Identity record. Legal Last Name reports. If Legal Last Name is null, the Last Name reports. | Identities > Current Identity > Legal Last Name or Last Name | |||||||||||||||||||||
First Name | The student's first name. Reports the first name from the current Identity record. Legal First Name reports. If Legal First Name is null, the First Name reports. | Identities > Current Identity > Legal First Name or First Name | |||||||||||||||||||||
Middle Name | The student's middle name. Reports the middle name from the current Identity record. Legal Middle Name reports. If the Legal Middle Name is null, the Middle Name reports. | Identities > Current Identity > Legal Middle Name or Middle Name | |||||||||||||||||||||
Generational Suffix | A three-character generational suffix. Reports the suffix from the current Identity record. Legal Suffix reports if the Legal First Name and Legal Name are not null. Suffix reports if the Legal First Name and Legal Middle Name are null. | Identities > Current Identity > Legal Suffix or Suffix | |||||||||||||||||||||
Birth Date | The student's date of birth. | Identities > Current Identity > Birth Date | |||||||||||||||||||||
Grade | The two-digit number of the grade in which the student is placed. | Enrollments > Grade, associated state grade level | |||||||||||||||||||||
Gender | The one-character code for the student's gender. M: Male F: Female X: Non-Binary Reports the gender from the current Identity record. The Legal Gender reports. If Legal Gender is null, Gender reports. | Identities > Current Identity > Legal Gender or Gender | |||||||||||||||||||||
Hispanic/Latino Ethnicity | Identifies whether the student is Hispanic/Latino. Y = Yes N = No or null | Demographics > Race Ethnicity > Is the individual Hispanic/Latino | |||||||||||||||||||||
Race | A five-digit code used to designate a student's race(s) must contain at least one non-zero element.
Reports all values selected. Example 02000 = Asian Example 12000= American Indian and Asian | Demographics > Race Ethnicity > Race | |||||||||||||||||||||
Social Security Number | The student's Social Security Number. Nine zeros report for students who do not have a Social Security Number. | Identity > SSN | |||||||||||||||||||||
Filler | N/A | N/A | |||||||||||||||||||||
Title 1 | Indicates the student's Title 1 status as of the report generation end date or last enrollment if the student is no longer enrolled. If the student has a value in the Home School field on their enrollment AND there is a school in the district with that state school code, then the report finds the school record that falls within the Effective Date on the extract editor and reports the value from the Title 1 field on that school. Otherwise, this element reports from the school to which the student’s enrollment is tied. If the school history table does not contain a value AND the student has a flag that was active as of the effective date, Y reports.
| School Information > Title 1 and Enrollments > State Reporting Fields > Title 1 OR School Information > Title 1 = School wide program | |||||||||||||||||||||
Free/Reduced Price Meals | Indicates whether a student is eligible to receive free/reduced-price meals. Reports from the FRAM record as of the enrollment End Date. If the enrollment End Date is null, the value reports as of the End Date on the extract editor.
| Eligibility > Eligibility | |||||||||||||||||||||
Migrant | Indicates the student's migrant status. Y reports if the Migrant checkbox is marked on the most recent enrollment that meets the report selection criteria. Otherwise, N reports. | Enrollments > State Reporting Fields > Migrant | |||||||||||||||||||||
| Foreign Exchange Student | Indicates whether the student is a foreign exchange student. This category includes students who are returning to their home country for graduation. Grades 9-12 only. Reports Y when Yes, F, or J is selected as of the report generation end date.
| Enrollments > State Reporting Fields > Foreign Exchange | |||||||||||||||||||||
Special Education Services | Indicates the student's special education status when the file was created.
| N/A | |||||||||||||||||||||
SPED Exit Date | Identifies the date on which the student exited Special Education. The date reports from the most recent locked IEP as of the End Date entered on the report editor. | Special Ed Documents > IEP > MD SPED Print Format > Special Ed Exit Date | |||||||||||||||||||||
Certificate of Program Completion | For Students with a Special Education indicator of Y, if the student's IEP, indicates that the student is on track to receive a Certificate of Program Completion. Y reports when the Special Ed Status is Y AND the student has an active certificate tracked program/flag marked state reported as of the end date on the extract editor. Otherwise, N reports. | Student Information > General > Flags > Flag | |||||||||||||||||||||
ELL Indicator | Indicates the student has a primary or Home language other than English and was assessed as having limited or no ability to understand, speak, or read English. The following values report based on the student’s most recent EL record where the identified date is on or before the report end date on the extract editor.
| English Learners (EL) > EL > Program Status | |||||||||||||||||||||
ELL Begin Date | The date the student began ELL services or entered the U.S. for the first time. Reports the identified date from the student’s most recent record that meets the Y or E criteria on the EL tab. | EL > Identified Date | |||||||||||||||||||||
ELL Exit Date | The date when the student's ELL services ended. | EL > Program Exit Date | |||||||||||||||||||||
Filler | N/A | N/A | |||||||||||||||||||||
Single Parent | Indicates whether the student is a single parent. | Enrollment > Single Parent | |||||||||||||||||||||
CIP | The CIP code from the student’s CTE program. | Student Information > General > Career Tech Program Detail > Program Program Admin > Programs > Career Tech Programs > Career Tech Program Detail > State Code (CIP) | |||||||||||||||||||||
Concentrator | The one-character code that indicates whether the student is enrolled in a course identified as a concentrator course.
| Schedule Course Information > CTE Concentration Course | |||||||||||||||||||||
LEA Course Code | The unique course number that identifies the course noted in the course catalog. Find all of a student’s courses for the school year selected in the extract editor:
Reports one record per unique course code/CIP combination. Otherwise, the element reports blank. | Schedule Course Master > Course > CIP Code Academic Planning > CTE Programs Program Admin > Programs > Career and Tech | |||||||||||||||||||||
The following elements are for the CTE Outcome Extract ONLY. | |||||||||||||||||||||||
Technical Assessment Available | Indicates whether the Technical Assessment was available. | Student Information > General > Career Tech Program Detail > Certificate | |||||||||||||||||||||
Technical Assessment Attempted | Indicates whether the Technical Assessment was attempted. Y reports if the Attempted checkbox is marked on the certification student’s career tech program detail screen. Otherwise, N reports. | Student Information > General > Career Tech Program Detail > Student Status | |||||||||||||||||||||
Technical Assessment Passed | Indicates whether the Technical Assessment was passed. Y reports if the Attempted checkbox is marked on the certification student’s career tech program detail screen. Otherwise, N reports. | Student Information > General > Career Tech Program Detail > Student Status | |||||||||||||||||||||
Withdraw/Transfer/ | Reports the Enrollment Exit Code from the left-most justified alpha in the End Status dictionary Code (Attribute dictionary > Enrollments > End Status > Code). | Enrollments > State Reporting Fields > Exit Status Code | |||||||||||||||||||||
Withdraw/Transfer/ | Reports the Enrollment Exit Code from the 2nd and 3rd left justified positions End Status dictionary Code (Attribute dictionary > Enrollments > End Status > Code). | Enrollments > End Status > code area of the dictionary | |||||||||||||||||||||
Submission Date | The Run Date entered on the extract editor. | CTE > Run Date | |||||||||||||||||||||
