Skip to main content
Skip table of contents

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.

Back to Top

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:

  • Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria.
  • Current School Only – Includes all records associated with the current school that meet the selection criteria.
  • District Wide – Includes all records on the PowerSchool server that meet the selection criteria.

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.

Back to Top

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
[Students.StudentCoreFields]PSCore_Legal_Last_Name

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
[Students.StudentCoreFields]PSCore_Legal_First_Name

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
[Students.StudentCoreFields]PSCore_Legal_Middle_Name

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

35SCED Course CodeThe unique Maryland course number that identifies the course as noted in the Maryland Course catalog.[S_MD_CRS_MCC_X]SCED_Course_CodeAlphanumeric5162-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

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.