Student Career and Technical Education (CTE) Records Report

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.

Students to Include

Indicate which students to include in the report by selecting one of the following options:

• The selected [number] students only – Run the report for students in the current selection.

• All students – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to runningreport.

Processing Options

Choose a time to run the report from the pop-up menu:

• In Background Now (Recommended) – Execute the report immediately in the background.

• ASAP – Execute the report in the order it is received in the Report Queue.

• At Night – Execute the report during the next evening.

• On Weekend – Execute the report during the next weekend.

• On Specific Time – Execute the report on the date and time specified.

Specific Date/Time

Enter a date using the format mm/dd/yyyyor mm-dd-yyyyto run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry.

Use the pop-up menus to schedule the report to be run at a specific hour and minute.

Example: 7/29/2008 @ 10 AM : 05.

Reporting Year

Select the academic year of the records to be reported.

Bypass Validation

Choose Yes or No from the pop-up menu to run the validation portion of extract, which is used to validate that specified fields used for the extract are populated correctly.

If the report identifies errors in student data, an HTML page displays the list of the errors. If the report does not identify any data errors, extract completes as expected.

See Extract Validations for a list of potential validation errors.

School Group 
Note: This overrides the Use selection above.

Choose a group of schools to override the above "Use" parameter indicating District Wide vs.Current School Only. The extract includes student records associated with the selected schools that meet the selection criteria.

Note: This parameter is optional. The “School Group“ Report parameter will only be available when the sub-district functionality is not enabled.

11.01

Record Type Code

The type of data record being submitted.

Always SCTE

4

CS

N/A

Y

11.02

Transaction Type Code

The action taken when the data record is submitted.

CALPADS processes the following Transaction Type Codes:

• Blank: Add or update the record

• D: Delete the current record

This value is calculated based on the updatable fields and operational keys.

1

CS

N/A

N

11.03

Local Record ID

A local use field to provide the system record identifier for a submitted record in any CALPADS file format.

This field is calculated by concatenating internal ID fields. The values for the internal fields may be separated by periods.

[S_CA_STU_StudentCTE_C]Unique_ID

255

CS

U

N

11.04

Reporting LEA

The district number; a unique identifier for the LEA responsible for obtaining and maintaining a student's SSID by way of an enrollment record in the CALPADS.

State Business Rules:

The county district (CD) code must be reported if the reporting LEA is a district or county office. The school (S) code must be reported if the reporting LEA is an independently reporting charter school.

[Prefs]Name=districtnumber

[Prefs]Value

7

CS

N/A

Y

11.05

School of Attendance

The school in which the student is enrolled.

State Business Rules:

The school (S) code must be reported if the reporting LEA is an independently reporting charter school.

If the student attends an NPS school, the School of Attendance must be 0000001.

[S_CA_STU_StudentCTE_C]SchoolID

[S_CA_SCH_X]StateSchoolNumber

[Schools]School_Number

The report locates the School of Attendance for a student based on the school associated with the CTE record. Each school is assigned a 7-digit School Number, which is used as the School of Attendance value.

7

CS

O

N

11.06

Academic Year ID

The unique identifier assigned to a specific academic year. An academic year is the period during which school is in regular session and provides a required number of days of instruction (175 days in California).

Extracted in the format CCYY-CCYY, such as 2010-2011.

[S_CA_STU_StudentCTE_C]AcademicYear

9

CS

O

Y

11.07

SSID

The unique identifier for the student assigned by the first California district in which the student is enrolled.

State Business Rules:

Must be a valid CALPADS SSID.

[Students]State_StudentNumber

10

CS

N/A

Y

11.08

Local Student ID

A unique identifier assigned to the student by an LEA.

State Business Rules:

Updates to this field must be made through the SSID Enrollment extract. The field is included in this extract to assist with the identification of the student.

[Students]Student_Number

15

CS

N/A

Y

11.09

Student Legal First Name

The first name given to the student after birth or through legal action.

State Business Rules:

Updates to this field must be made through the Student Information extract. The field is included in this extract to assist with the identification of the student.

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_First_Name

[Students]First_Name

30

CS

N/A

Y

11.10

Student Legal Last Name

The last name given to the student after birth or through legal action.

State Business Rules:

Updates to this field must be made through the Student Information extract. The field is included in this extract to assist with the identification of the student.

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_Last_Name

[Students]LastName

50

CS

N/A

Y

11.11

Student Birth Date

The student’s date of birth, extracted in the format CCYYMMDD, e.g. 20081025.

State Business Rules:

Updates to this field must be made through the Student Information extract. The field is included in this extract to assist with the identification of the student.

[Students]DOB

8

DT

N/A

Y

11.12

Student Gender Code

The student’s gender.

State Business Rules:

Updates to this field must be made through the Student Information extract. The field is included in this extract to assist with the identification of the student.

Notes: 

• If populated, the student's legal gender overrides the student's preferred gender.

• If the student's preferred gender is X, the student's legal gender must be M or F.

[StudentCoreFields]PSCore_Legal_Gender

[Students]Gender

1

CS

N/A

Y

11.13

CTE Pathway Code

A coded value representing a Career Technical Education Career Pathway. A Career Technical Education Career Pathway is the second level in a two-tier hierarchy of Career Technical Education Industry Sectors and Career Pathways.

Note: A pathway must be specified for each CTE concentrator.

[S_CA_STU_StudentCTE_C]PathwayCode

3

CS

O

Y

11.14

CTE Pathway Completion Academic Year ID

A unique identifier assigned to the Academic Year in which a Career Technical Education secondary concentrator completed a specific pathway.

When the Pathway Completer checkbox is checked (stored as a value of 1), CTE Pathway Completion Academic Year is populated with the Academic Year on the CTE record (Field 11.06).

[S_CA_STU_StudentCTE_C]Completer

9

CS

N