Skip to main content
Skip table of contents

S_PA_STU_CTE_C (ver 20.12.1)

This table is a child table of the [Students] table.

Column Name

Version

Data Type

Description

Column Name

Version

Data Type

Description

StudentsDCID17.4.0Number(10,0)Foreign Key to the Students table.
CIP_Code17.4.0Varchar2(6)Migrated from [Students]PA_CTE_CIP_Cd.
Delivery_Method_Code17.4.0Varchar2(2)Migrated from [Students]PA_CTE_Deliv_Meth_Cd.
Status_Type_Code17.4.0Varchar2(2)Migrated from [Students]PA_CTE_Stat_Type..
Reg_Apprenticeship_TF17.4.0Number(1,0)Migrated from [Students]PA_CTE_Reg_App.
Internship_TF17.4.0Number(1,0)Migrated from [Students]PA_CTE_Intern_Ind
Cooperative_Work_TF17.4.0Number(1,0)Migrated from [Students]PA_CTE_Coop_Work.
Job_Exploration_TF17.4.0Number(1,0)Migrated from [Students]PA_CTE_Job_Explor.
Agriculture_Experience_TF17.4.0Number(1,0)Migrated from [Students]PA_CTE_Agr_Exper.
Sch_Spon_Enterprise_TF17.4.0Number(1,0)Migrated from [Students]PA_CTE_Sch_Spon_Ent.
Program_Hours_Completed17.4.0Number(25,10)Migrated from [Students]PA_CTE_Num_Prog_Hour.
Percent_Program_Completed17.4.0Number(25,10)Migrated from [Students]PA_CTE_Per_Prog.
Cum_Post_Credits_Earned17.4.0Number(25,10)Migrated from [Students]PA_CTE_Cum_Post_Cred.
Work_Base_Experience_TF17.4.0Number(1,0)Migrated from [Students]PA_CTE_Work_Base_Exp..
Industry_Credential_Code17.4.0Varchar2(1050)Migrated from [Students]PA_CTE_Ind_Cred.
Credential_Earned_Date17.4.0DateMigrated from [Students]PA_CTE_Cred_Date.
Program_Performance_Code17.4.0Varchar2(3)Migrated from [Students]PA_CTE_Prog_Perf_Cd.
PELL_Grant_YN17.4.0Varchar2(1)Migrated from [Students]PA_Pell_Grant.
Academic_Instruction_Code17.4.0Varchar2(3)Migrated from [Students]PA_Academic_Instruct_CD.
Perkins_Concentrator_YN20.5.2.0Varchar2(1)Data entry field to record Perkins Concentrator value
Perkins_Participant_YN20.5.2.0Varchar2(1)Data entry field to record Perkins Participator value
Simulated_WorkEnv_YN20.5.2.0Varchar2(1)Data entry field to record Simulated Work Environment value
Cert_of_Apprenticeship20.5.2.0Varchar2(3)Data entry field to record Certificate of Apprenticeship value
Degree_Awarded20.5.2.0Varchar2(5)Data entry field to record Degree Awarded value
Adult_Cum_CreditEquiv20.5.2.0Number(25,10)Data entry field to record Adult Cumulative Credit Equivalency value
PDE408_IndicatorYN
20.12.1
Varchar2(1)
This field is used to store Yes or No value if form PDE-408 or locally developed form has been completed and signed. Required for CTE inclusion
PDE408_INDICATORDATE
20.12.1
Date
This field is used to store the date when form PDE-408 or locally developed form has been completed and signed. Required for CTE inclusion
YEAR_ID
20.12.1
Number(11,0)
This field is used to store the year ID of the selected Term Year
JavaScript errors detected

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

If this problem persists, please contact our support.