P-TECH Enrollment File (Maryland)

Classic View: MD State Reporting > P-TECH Extracts > Report Type > P-Tech Enrollment

Search Terms: P-Tech

This collection captures student level information for the entire school year and includes student demographics, P-TECH year of enrollment, CIP information and CTE course enrollment information.

Enrollment File Editor Example


Report Logic

  • Reports a record for each unique CTE CIP Code/Course combination for all P-TECH students.
  • To report, a student must have an enrollment in at least one of the selected calendars and their enrollment's
    • Start Date is less than or equal to the extract editor Effective Date.
    • Service Type is Primary, Partial or Special Ed Services. (Data reports from the most recent Primary enrollment. If no Primary enrollment exists, the most recent recent enrollment is used.)
    • Grade is mapped to a State Grade Level Code of 09-12.
  • To report, a student must have at least one CTE Program Participation record where all of the following are met:

    • CTE Start Date is prior to the extract editor Effective Date.
    • CTE End Date is NULL or after the Calendar Start Date.
    • The record must be associated with a CTE Program where the State Code (CIP) is not NULL, State Reported is marked, AND P-TECH Indicator is marked.
  • If the student is scheduled in a CTE Course, a record reports when all of the following statements are true.

    • The Course is associated with the Calendar selected on the extract editor.
    • The Roster Start Date is prior to or equal to the extract editor Effective Date.
    • The Course StateCode is not NULL.
    • The Course is Active.
    • The Course Number matches a CTE Course Requirement's Transcript/Course Number and is associated with the CTE State Code (CIP) of one of the student’s CTE records.
      • If there are multiple Roster records for a single course, a distinct record for each Course reports.
      • If the student is not scheduled in any P-TECH courses, a record reports for the CTE Program and the course data elements will be blank.
  • Students are NOT included if
    • their enrollment record is marked as State Exclude;
    • their Course is marked as Exclude;
    • their Grade Level of enrollment is marked as State Exclude; or
    • their Calendar of enrollment is marked as State Exclude. This requirement does NOT apply to Summer School calendars.

Report Editor Fields

FieldDescription
Report TypeDetermines which P-TECH file is generated.
Effective DateData is pulled as of the date selected in this field.

Run Date

The date on which the report was generated. This date appears in the Submission Date field on the report.

File Identifier

Uniquely identifies the individual submission.

State Grade Level

Determines specific grades to include in the report. Only grade levels from schools active during the report date range display.

Ad Hoc Filter

Select a filter to limit results to students included in the filter.

Format

Determines the format for the report.

  • CSV (Comma Separated)
  • TXT (Fixed Width State Format)
  • 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 the 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.

Each batch queue file is limited to 10 calendars.

Report Layout

FieldDescription
Report TypeDetermines which P-TECH file is generated.
Effective DateData is pulled as of the date selected in this field.

Run Date

The date on which the report was generated. This date appears in the Submission Date field on the report.

File Identifier

Uniquely identifies the individual submission.

State Grade Level

Determines specific grades to include in the report. Only grade levels from schools active during the report date range display.

Ad Hoc Filter

Select a filter to limit results to students included in the filter.

Format

Determines the format for the report.

  • CSV (Comma Separated)
  • TXT (Fixed Width State Format)
  • 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 the 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.

Each batch queue file is limited to 10 calendars.

Report Layout

Element
Description
Location
LEA Number
The two-digit state designation of the local education agency.





Numeric, 2 digits
System Administration > Resources > District Information > State District Number

Database:
District.number
School Number

The four-digit code assigned to the school building.

This value reports from the Enrollment associated with the Calendar: If the School Type = 99, the Providing School from the Enrollment reports. Otherwise, this value reports the Home School or the State School Number.









Numeric, 4 digits

System Administration > Resources > School > Type

Student Information > General > Enrollment > Special Ed Fields > Providing School

Student Information > General > Enrollment > State Reporting Fields > Home School

System Administration > Resources > School > State School Number


Database:

EnrollmentMD.providingSchool

EnrollmentMD.homeSchool

School.number

State Assigned Student ID (SASID)
The state assigned Student State ID.




Numeric, 10 digits
Census > People > Demographics > Student State ID

Database:
Person.stateID
Local Student ID Number (LASID)
The unique number assigned by the local education agency.




Numeric, 10 digits
Census > People > Demographics > Student Number


Person.studentNumber
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.



Alphanumeric, 25 characters
Census > People > Identities > Current Identity > Legal Last Name or Last Name

Database:
Identity.legalLastName
Identity.lastName
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.



Alphanumeric, 15 characters
Census > People > Identities > Current Identity > Legal First Name or First Name

Database:
Identity.legalFirstName
Identity.firstName
Middle Name
The student's middle name. Reports the middle name from the current Identity record. Legal Middle Name reports. If Legal Middle Name is null, the Middle Name reports.

Alphanumeric, 15 characters
Census > People > Identities > Current Identity > Middle Name

Database:
Identity.middleName
Generational Code or Suffix
Any suffix tied to the student's name. Reports the suffix from the current Identity record. If the Legal First Name and Legal Name are not null, Legal Suffix reports. If the Legal First Name and Legal Middle Name are null, Suffix reports.


Alphanumeric, 3 characters
Census > People > Identities > Current Identity > Legal Suffix or Suffix

Database:
Identity.legalSuffix
Identity.Suffix
Preferred Name (OPTIONAL)
An alternative first name preferred by the student.




Alphanumeric, 3 characters
Census > People > Identities > Current Identity > Preferred Name

Database:
Identity.alias
Date of Birth
The student's date of birth.



Date field, 8 characters YYYYMMDD

Census > People > Identities > Current Identity > Birth Date

Database:
Identity.birthDate
Grade
The student's grade level.




Numeric, 2 digits
Student Information > General > Enrollments > General Enrollment Information > Grade

Database:

Enrollment.grade

GradeLevel.stateGrade

Gender

The student's gender.

M: Male

F: Female

X: Non-Binary

Reports the gender from the current Identity record. Legal Gender reports. If Legal Gender is null, Gender reports.

Alphanumeric, 1 character
Census > People > Identities > Current Identity > Legal Gender or Gender

Database:
Identity.legalGender
Identity.gender
Hispanic/Latino Ethnicity

Indicates if the student is considered Hispanic/Latino.

If Is the individual Hispanic/Latino = Yes, a value of Y is reported. Otherwise, a value of N is reported.





Alphanumeric, 1 character
Census > People > Identities > Current Identity > Race/Ethnicity > Is the individual Hispanic/Latino?

Database:
Identity.hispanicEthnicity
American Indian/Alaskan Native

Indicates whether the person has origins in any of original peoples of North and South America (including Central America) and who maintains cultural identification through tribal affiliation or community attachment.

1 = Yes

0 = No or Null



Numeric, 1 digit
Census > People > Identities > Current Identity > Race/Ethnicity > American Indian or Alaska Native

Database:
IdentityRaceEthnicity. federalCode
Asian

Indicates whether the person has origins in any of original peoples of the Far East, Southeast Asia, or the Indian Subcontinent. This area includes Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, Philippine Islands, Thailand, and Vietnam.

2 = Yes

0 = No or Null


Numeric, 1 digit
Census > People > Identities > Current Identity > Race/Ethnicity > Asian

Database:
IdentityRaceEthnicity. federalCode
Black or African American

Indicates whether the person has origins in any of the black racial groups of Africa.

3 = Yes

0 = No or Null





Numeric, 1 digit
Census > People > Identities > Current Identity > Race/Ethnicity > Black or African American

Database:
IdentityRaceEthnicity. federalCode
Native Hawaiian or Other Pacific Islander

Indicates whether the person has origins in any of original peoples of Hawaii, Guam, Samoa, or other Pacific Islands.

4 = Yes

0 = No or Null






Numeric, 1 digit
Census > People > Identities > Current Identity > Race/Ethnicity > Native Hawaiian or Other Pacific Islander

Database:
IdentityRaceEthnicity. federalCode
White

Indicates whether the person has origins in any of original peoples of Europe, Middle East, or North Africa.

5 = Yes

0 = No or Null




Numeric, 1 digit
Census > People > Identities > Current Identity > Race/Ethnicity > White

Database:
IdentityRaceEthnicity. federalCode
Filler
N/A
N/A
P-TECH CIP
The State Code (CIP) associated with the student’s CTE Program.






Alphanumeric, 6 characters

Student Information > Academic Planning > Career Tech Program Detail > Program

Program Admin > Programs > Career Tech Programs > Career Tech Program Detail > State Code (CIP)


Database:
Program.code
P-TECH Yr

The number of years the student has been enrolled in P-TECH program.

Campus calculates the number of years from the CTE Start Date of the program.


If the CTE Start Date is...
Reports...
less than one year from the Effective Date
1
at least one year and less than two years from the Effective Date
2
at least two years and less than three years from the Effective Date
3
at least three years and less than four years from the Effective Date
4
at least four years and less than five years from the Effective Date
5
at least five years from the Effective Date
6



Numeric, 1 digit
Student Information > Academic Planning > Career Tech Program > Start Date

Database:
ProgramParticipation. startDate
Filler
N/A
N/A
SCED Course Code

The School Courses for the Exchange of Data (SCED) code.

Campus reports the full SCED Course Code for each unique Course associated with the P-TECH CIP code in the school year selected in the extract editor by concatenating SCED Subject Area and SCED Course Identifier. The student does not report If they dropped the course within the first 5 instructional days of the term when the course began.

All others report blank.



Alphanumeric, 5 characters

Scheduling > Courses > Course > NCES Data > SCED Subject Area


Scheduling > Courses > Course > NCES Data > SCED Course Identifier


Database:

Course.scedSubjectArea

Course.scedCourseID

Local Course Code

The Local Course code designation corresponding with the assigned SCED code. 

Campus reports each unique Course Number associated with the P-TECH CIP code in the school year selected in the extract editor. The student does not report If they dropped the course within the first 5 instructional days of the term when the course began.

All others report blank.


Alphanumeric, 10 characters
Scheduling > Courses > Course > Number



Database:
Course.number
Filler
N/A
N/A
Report Yr
The End Year of the Calendar of the student’s enrollment.


Numeric, 4 digits YYYY

N/A

Database:
Enrollment.endYear
Submission Date
The date entered in the Run Date field on the extract editor.

Date field, 8 characters YYYYMMDD

MD State Reporting > P-TECH Extracts > Run Date