Career and Technical Enrollment Report
On this page:
Introduction
This extract collects the enrollment data for students enrolled in a CTE program during the current school year. The CTE student enrollment data collected in the extract is used for the distribution of CTE Technical Achievement data collection reports.
This report uses the State reporting Platform to generate results.
Selection Criteria
Selection criteria determine which database records are used in the report. For the Career and Technical Enrollment Extract, student enrollment records are selected.
School Selection
The report selects which school records to use based on the following criteria:
- The school must not be excluded from state reporting.
- The school must be associated with a student included in the report.
Student Selection
The report selects which student records to use based on the following criteria:
- The student must not be excluded from state reporting.
- The course must have a CIP code assigned.
- The course section enrollment date must be within the report start and report end dates.
Note: Dropped courses are not included.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
---|---|
Report Parameters | Select Set All; this will store your selections for this report which is helpful when you need to submit a new file and you are unsure of how you created your last file. |
Use Alternate School Numbers | Select Yes if you would like to use Alternate School Numbers when processing the report. |
Start Date | Enter the start date for this report. |
End Date | Enter the end date for this report. |
Submission Date | Enter the date the file was created. |
Use | If run at the district level, choose one of the following from the pop-up menu:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Trace Log (Internal Option) | Check the enabled button of you would like Trace Enabled. Do not need to Enable. |
Include Query Output in Trace (Internal Option) | If Trace is enabled you can enable the Query Output Row Number Limit. Do not need to set. |
Query Output Row Number Limit (Internal Option) | If Trace is enabled you can enable the Query Output Row Number Limit. Do not need to set. |
Sample Dataset Mode (Internal Option) | You do not need to check this box. |
Scheduling | Click the Run Now button to run this report immediately, or the Schedule button to schedule it to run later. |
Submit | Click the submit button. You will be taken to the Report Queue. Once your file is complete, click on the complete button and you will have a PDF file to assist you in compiling your spreadsheet for the State. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item | Data Element | Description | [Table]FieldName | Field Type | Field Length | Begin / End Position |
---|---|---|---|---|---|---|
1 | LEA Number | This field contains the two-digit local education agency code (LEA). This field is extracted from the District Information page, Start Page > District Setup > District Information. | [Pref]MD_DistrictLEA | Numeric | 2 | 1-2 |
2 | School Number | This field contains the four-digit code that identifies the school building. This field is extracted from the Edit School page, Start Page > District Setup > Schools/School Info > Edit School. | [Schools]School_Number Or [Schools] alternate_school_number | Alpha-numeric | 4 | 3-6 |
3 | SASID | This field contains the student identification number assigned by the Maryland State Department of Education. This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information. | [Students]State_StudentNumber | Numeric | 10 | 7-16 |
4 | Student ID Number | This field contains the student identification number assigned by the school. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics. | [Students]Student_Number | Numeric | 10 | 17-26 |
5 | Last Name | This field contains the student's last name. Extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics, or if the legal last name is populated on the Maryland State Information page, Start Page>Student Selection>Maryland State Information. | [Students]Last_Name OR | Alpha-numeric | 25 | 27-51 |
6 | First Name | This field contains the student's first name. Extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics, or if the legal first name is populated on the Maryland State Information page, Start Page>Student Selection>Maryland State Information. | [Students]First_Name OR | Alpha-numeric | 15 | 52–66 |
7 | Middle Name | This field contains the middle name of the student. Extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics , or if the legal middle name is populated on the Maryland State Information page, Start Page>Student Selection>Maryland State Information. | [Students]Middle_Name OR | Alpha-numeric | 15 | 67-81 |
8 | Generational Suffix | Reported Values: 1=Jr, 2=II, 3=III, 4=IV, 5=V, 6 =VI, 7=VII, 8=IIX, 9=IX, 10=X This field contains the student's Generational Suffix. This field value is extracted from the State/Province MD page, Start Page > Student Selection > State/Province MD. | [S_MD_STU_X]Generation OR [Students.StudentCoreFields]PSCore_Legal_Suffix | Alpha-numeric | 3 | 82-84 |
9 | Date of Birth | This field contains the student's birth date. This field value is extracted from the General Demographics page, Start Page > Student Selection > General Demographics. | [students]Dob Format of YYYYMMDD | Numeric | 8 | 85-92 |
10 | Grade | This field contains the student's grade level during the enrollment period. This field value is extracted from the General Demographics page, Start Page > Student Selection > General Demographics. | [students]Grade_level | Alpha-numeric | 2 | 93-94 |
11 | Gender | This field contains the student's gender code. 1 for male and 2 for female. This field value is extracted from the General Demographics page, Start Page > Student Selection > General Demographics, or if the legal gender is populated on the Maryland State Information page, Start Page>Student Selection>Maryland State Information. | [Students]Gender OR [Students.StudentCoreFields]PSCore_Legal_Gender | Alpha-numeric | 1 | 95 |
12 | Hispanic or Latino | A value of Y in this field indicates that this student is Hispanic or Latino. A value of N in this field indicates that this student is not Hispanic or Latino. This field value is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information. If the Hispanic or Latino field is blank on the Maryland State Reporting page, this field value is extracted from Edit Demographics page, Start Page > Student Selection> General Demographics. | [S_MD_STU_X]Hispan_Lat_TF OR [Students]FedEthnicity | Alpha-numeric | 1 | 96 |
13 | American Indian/Alaskan Native | A value of Y in this field identifies this student's ethnicity as American Indian/Alaskan Native. A value of N in this field indicates that this student's is not American Indian/Alaskan Native. This field value is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information. If the American Indian/Alaskan Native check box is blank on the Maryland State Reporting page, this field value is extracted from Edit Demographics page, Start Page > Student Selection> General Demographics. | [Students]MD_Eth_Amer_Ind OR [StudentRace]RaceCd =1 | Alpha-numeric | 1 | 97 |
14 | Asian | A value of Y in this field identifies this student's ethnicity as Asian. A value of N in this field indicates that this student's is not Asian. This field value is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information. If the American Indian/Alaskan Native check box is blank on the Maryland State Reporting page, this field value is extracted from Edit Demographics page, Start Page > Student Selection> General Demographics. | [Students]MD_Eth_Asian OR [StudentRace]RaceCd =2 | Alpha-numeric | 1 | 98 |
15 | Black or African American | A value of Y in this field identifies this student's ethnicity as Black or African American. A value of N in this field indicates that this student's is not Black or African American. This field value is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information. If the American Indian/Alaskan Native check box is blank on the Maryland State Reporting page, this field value is extracted from Edit Demographics page, Start Page > Student Selection> General Demographics. | [Students]MD_Eth_Black OR [StudentRace]RaceCd =3 | Alpha-numeric | 1 | 99 |
16 | Native Hawaiian or Other Pc. Isle | A value of Y in this field identifies this student's ethnicity as Native Hawaiian or Other Pacific Islander. A value of N in this field indicates that this student's is not American Indian/Alaskan Native. This field value is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information. If the Native Hawaiian or Other Pacific Islander check box is blank on the Maryland State Reporting page, this field value is extracted from Edit Demographics page, Start Page > Student Selection> General Demographics. | [Students]MD_Eth_Hawaiian OR [StudentRace]RaceCd =4 | Alpha-numeric | 1 | 100 |
17 | White | A value of Y in this field identifies this student's ethnicity as White. A value of N in this field indicates that this student's is not White. This field value is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information. If the White check box is blank on the Maryland State Reporting page, this field value is extracted from Edit Demographics page, Start Page > Student Selection> General Demographics. | [Students]MD_Eth_White OR [StudentRace]RaceCd =5 | Alpha-numeric | 1 | 101 |
18 | Social Security Number | This field contains the student's social security number. This field value is extracted from the General Demographics page, Start Page > Student Selection > General Demographics. | [Students]SSN | Numeric | 9 | 102-110 |
19 | Filler | No data is submitted. | Alpha-numeric | 1 | 111 | |
20 | Title 1 Indicator | A value of 1 in this field indicates that this student is a Title 1 Student. A value of 0 indicates that this student is not a Title 1 Student .This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information. | [S_MD_STU_X]Title_One | Alpha-numeric | 1 | 112 |
21 | Free/Reduced Meals | A value other than P in this field indicates that this student receives free or reduced meals. This field is extracted from the Lunch page, Start Page > Student Selection > Lunch. | [Students]LunchStatus | Alpha-numeric | 1 | 113 |
22 | Migrant | A value of 1 in this field indicates that this student is a Migrant. A value of 0 indicates that this student is not a Migrant. This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information. | [Students]Migrant | Alpha-numeric | 1 | 114 |
23 | Foreign Exchange Student | A value of 1 in this field indicates that this student is a Foreign Exchange Student. A value of 0 indicates that this student is not a Foreign Exchange Student. This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information. | [S_MD_STU_X]Foreign_Exchange | Alpha-numeric | 1 | 115 |
24 | Special Education | Reported Values: Y = Yes, 2=E, 3=3, 4=2 else N = No This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information | [Students]ST_SPED | Alpha-numeric | 1 | 116 |
25 | Special Education End Date | If the student's ST_SPED code is a 2 then this is submitted. This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information | [S_MD_STU_X]SpecEd_End_Date Format of YYYYMMDD | Numeric | 8 | 117-124 |
26 | Certificate of Program Completion | A value of 1 in this field indicates that this student has a Certificate of Program Completion. A value of 0 indicates that this student does not have a Certificate of Program Completion This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information. | [S_MD_STU_X]Special_Ed_Certificate | Alpha-numeric | 1 | 125 |
27 | ELL Indicator | Reported Values: 1 = Yes, 2=E, else N = No A value of 1 in this field indicates that this student qualifies for a limited English proficiency program. A value of 0 indicates that this student does not qualify for a limited English proficiency program. A value of 2 indicates the student exited a limited English proficiency program. This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information. | [S_MD_STU_X]ELL | Alpha-numeric | 1 | 126 |
28 | First Date in US School | If the student's ELL is a 1 or 2 then the student's First Date in US School is submitted. This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information | [S_MD_STU_X]First_Date_In_US_School Format of YYYYMMDD | Numeric | 8 | 127-134 |
29 | ELL End Date | If the student's ELL is a 1 or 2 then the student's ELL Begin date is submitted. This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information | [S_MD_STU_X]ELL_End_Date Format of YYYYMMDD | Numeric | 8 | 135-142 |
30 | Filler | No data is submitted. | Alpha-numeric | 1 | 143 | |
31 | Single Parent | A value of 4 in this field indicates that this student qualifies as a single parent. A value of 0 indicates that this student does not qualify as a single parent. This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information. | [MD_CTE]Single_Parent | Alpha-numeric | 1 | 144 |
32 | CIP Code | This field contains the Classification of Instructional Programs (CIP) code assigned to the course in which the student is enrolled. This field value is extracted from the Edit Course District Information page, Start Page > District Setup > Courses > Edit Course District Information. | [Courses]code | Alpha-numeric | 7 | 145-150 |
33 | Concentrator Designation | A value of C in this field indicates that the student is enrolled in a course identified as a concentrator course. A value of 0 displays in this field if the student is not enrolled in a course identified as a concentrator course. This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information. If this field is blank, this field value is extracted from the Edit Course District Information page, Start Page > District Setup > Courses > Edit Course District Information. | [S_MD_CRS_X]Concentrator_Designation [S_MD_STU_X]Concentrator_Designation | Alpha-numeric | 1 | 151 |
34 | LEA Course Code | The unique local course number that identifies the course as noted in the course catalog. | [Courses]Course_Number | Alpha-numeric | 10 | 152-161 |
35 | SCED Course Code | The unique Maryland course number that identifies the course as noted in the Maryland Course catalog. | [S_MD_CRS_MCC_X]SCED_Course_Code | Alphanumeric | 5 | 162-166 |
36 | Technical Assessment Available | This data element is not currently submitted. | Alpha-Numeric | 1 | 167 | |
37 | Technical Assessment Attempted | This data element is not currently submitted. | Alpha-Numeric | 1 | 168 | |
38 | Technical Assessment Passed | This data element is not currently submitted. | Alpha-Numeric | 1 | 169 | |
39 | Withdraw /Transfer /Complete (W/T/C) Status | This data element is not currently submitted. | Alpha-Numeric | 1 | 170 | |
40 | Withdraw /Transfer /Complete (W/T/C) Code | This data element is not currently submitted. | Alpha-Numeric | 2 | 172 | |
41 | Submission Date | The field contains the submission date entered on the report interface. | Format of YYYYMMDD | Numeric | 8 | 173-180 |