CTE Student Fact Template - RE

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 running report.

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/yyyy or mm-dd-yyyy in order to 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.

Field Delimiter

Select the field delimiter for the extract file.

Show Column Field Headings

Choose Yes or No to indicate whether to include column headings in the extract file. Including column headers provides a heading for each type of data extracted in the report.

1

Submitting AUN

The unique 9-digit Administrative Unit Number assigned by the PDE. This field is extracted from Start Page > District Setup > District Information.

[Prefs]Value where [Prefs]Name=PA_districtAUN

If sub-districts are enabled:

[CST_SubDistricts]Subdistrict_Number

Alpha-numeric

9

2

School Year Date

This field is calculated based on the last day of the school year for the term selected at the top of the page when running the report.

[Terms]LastDay

Alpha-numeric

10

3

PASecureID

The PAsecureID assigned to the student. This field is extracted from Start Page > Student > State/Province - PA > PA SecureID.

[Students]State_StudentNumber

Alpha-numeric

10

4

CIP School Number

The 4-digit code identifying the school that owns the CTE program approval or registered adult affidavit program. This field is extracted from Start Page > District Setup > Schools/School Info > Edit School.

[S_PA_SCH_X]PIMS_Location_Code

[Schools]School_Number

If sub-districts are enabled:

[CST_SchoolSubDistricts]SchoolID

Alpha-numeric

4

5

Student School Number

The student’s school ID or the PIMS Location Code. This field is extracted from Start Page > District Setup > Schools/School Info > Edit School.

[S_PA_SCH_X]PIMS_Location_Code

[Schools]School_Number

If sub-districts are enabled:

[CST_SchoolSubDistricts]SchoolID

Alpha-numeric

4

6

CIP Code

The CIP code for the CTE program. This field is extracted from Start Page > Student > State/Province - PA > CTE.

[S_PA_STU_CTE_C]CIP_Code

Alpha-numeric

6

7

Delivery Method Code

The delivery method of the CTE program.

Valid values:

• 50 – Occupational
• 60 – Tech Prep
• 70 – Program of Study
• 80 – Adult Affidavit Program

This field is extracted from Start Page > Student > State/Province - PA > CTE.

Note: This field is required for the student to be included in this report.

[S_PA_STU_CTE_C]Delivery_Method_Code

Alpha-numeric

2

8

Reporting Date

The report end date entered on the report page.

N/A

Numeric

10

9

Reporting Date Period Level

This field defaults to Year.

N/A

Alpha-numeric

10

10

CTE Status Type Code

The CTE status for the student. This field is extracted from Start Page > Student > State/Province - PA > CTE.

[S_PA_STU_CTE_C]Status_Type_Code

Alpha-numeric

2

11

CTE Program Completion Plan Code

This field defaults to N/A.

N/A

Alpha-numeric

3

12

Registered Apprenticeship Indicator

Indicates (Y or blank) if the CTE student participates in a registered apprenticeship. The data from this checkbox field is extracted from Start Page > Student > State/Province - PA > CTE.

[S_PA_STU_CTE_C]Reg_Apprenticeship_TF

Alpha-numeric

1

13

Internship Indicator

Indicates (Y or blank) if the CTE student participates in an internship. The data from this checkbox field is extracted from Start Page > Student > State/Province - PA > CTE.

Note: LEAs may assign a value of N to all adult affidavit students.

[S_PA_STU_CTE_C]Internship_TF

Alpha-numeric

1

14

Cooperative Work Indicator

Indicates (Y or blank) if the CTE student participates in a cooperative work program. The data from this checkbox field is extracted from Start Page > Student > State/Province - PA > CTE.

[S_PA_STU_CTE_C]Cooperative_Work_TF

Alpha-numeric

1

15

Job Exploration Indicator

Indicates (Y or blank) if the CTE student participates in a job exploration program. The data from this checkbox field is extracted from Start Page > Student > State/Province - PA > CTE.

[S_PA_STU_CTE_C]Job_Exploration_TF

Alpha-numeric

1

16

Agriculture Experience Indicator

Indicates (Y or blank) if the CTE student participates in an agricultural experience program. The data from this checkbox field is extracted from Start Page > Student > State/Province - PA > CTE.

[S_PA_STU_CTE_C]Agriculture_Experience_TF

Alpha-numeric

1

17

School Sponsored Enterprise Indicator

Indicates (Y or blank) if the CTE student participates in a school-sponsored enterprise indicator. The data from this checkbox field is extracted from Start Page > Student > State/Province - PA > CTE.

[S_PA_STU_CTE_C]Sch_Spon_Enterprise_TF

Alpha-numeric

1

18

Number of Program Hours Completed

The number of program hours the secondary or AAP CTE student completed, reported in 9999.99 format.

This field is extracted from Start Page > Student > State/Province - PA > CTE.

[S_PA_STU_CTE_C]Program_Hours_Completed

Numeric

7 with 2 decimal places

19

Percentage of Program Completed

The percentage of the program the secondary or AAP CTE student completed. This field is extracted from Start Page > Student > State/Province - PA > CTE.

[S_PA_STU_CTE_C]Percent_Program_Completed

Numeric

6 with 2 decimal places

20

Cumulative Postsecondary Credits Earned

The total number of postsecondary credits the CTE student earned. This field defaults to 0 if the Cumulative Postsecondary Credits earned field is blank.

This field is extracted from Start Page > Student > State/Province - PA > CTE.

[S_PA_STU_CTE_C]Cum_Post_Credits_Earned

Numeric

6 with 2 decimal places

21

Not Collected

This field is not currently used.

N/A

N/A

N/A

22

Work-Based Experience Indicator

Indicates (Y or blank) if the CTE student participates in a work-based experience program. The data from this checkbox field is extracted from Start Page > Student > State/Province - PA > CTE.

[S_PA_STU_CTE_C]Work_Base_Experience_TF

Alpha-numeric

1

23

Not Collected

This field is not currently used.

N/A

N/A

N/A

24

Not Collected

This field is not currently used.

N/A

N/A

N/A

25

Not Collected

This field is not currently used.

N/A

N/A

N/A

26

Pell Grant Indicator

Indicates (Y/N) if the AAP student received a federal Pell need-based grant during the academic year.

[S_PA_STU_CTE_C]PELL_Grant_YN

Alpha-numeric

1

27

Not Collected

This field is currently not collected.

N/A

N/A

28

POS Task List Completion Indicator

Required for 12^th grade students

Indicates whether a secondary student has completed all the program of study (POS) competencies on the school’s task list that is maintained as students move through program, and demonstrates eligibility to receive articulated credits by way of a statewide POS articulation agreement by aligning secondary and postsecondary programs. This field does not apply to 9^th – 11^th grades students or AAP

[S_PA_STU_X]CTE_POSTaskListCompInd

Alpha

2

Perkins Concentrator

Valid values:

• Blank (default)
• Yes
• No

Valid values:

• Blank (default)
• Yes
• No

Valid values:

• Blank (default)
• Yes
• No

Valid values:

• Blank (default)
• (App) - Certificate of Completion of an Apprenticeship
• (Pre) - Participated in a Pre-Apprenticeship program

Valid values:

• Blank (default)
• (ASSOC) - Associate Degree
• (BACCA) - Baccalaureate Degree