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 |
StudentsDCID | 17.4.0 | Number(10,0) | Foreign Key to the Students table. |
CIP_Code | 17.4.0 | Varchar2(6) | Migrated from [Students]PA_CTE_CIP_Cd. |
Delivery_Method_Code | 17.4.0 | Varchar2(2) | Migrated from [Students]PA_CTE_Deliv_Meth_Cd. |
Status_Type_Code | 17.4.0 | Varchar2(2) | Migrated from [Students]PA_CTE_Stat_Type.. |
Reg_Apprenticeship_TF | 17.4.0 | Number(1,0) | Migrated from [Students]PA_CTE_Reg_App. |
Internship_TF | 17.4.0 | Number(1,0) | Migrated from [Students]PA_CTE_Intern_Ind |
Cooperative_Work_TF | 17.4.0 | Number(1,0) | Migrated from [Students]PA_CTE_Coop_Work. |
Job_Exploration_TF | 17.4.0 | Number(1,0) | Migrated from [Students]PA_CTE_Job_Explor. |
Agriculture_Experience_TF | 17.4.0 | Number(1,0) | Migrated from [Students]PA_CTE_Agr_Exper. |
Sch_Spon_Enterprise_TF | 17.4.0 | Number(1,0) | Migrated from [Students]PA_CTE_Sch_Spon_Ent. |
Program_Hours_Completed | 17.4.0 | Number(25,10) | Migrated from [Students]PA_CTE_Num_Prog_Hour. |
Percent_Program_Completed | 17.4.0 | Number(25,10) | Migrated from [Students]PA_CTE_Per_Prog. |
Cum_Post_Credits_Earned | 17.4.0 | Number(25,10) | Migrated from [Students]PA_CTE_Cum_Post_Cred. |
Work_Base_Experience_TF | 17.4.0 | Number(1,0) | Migrated from [Students]PA_CTE_Work_Base_Exp.. |
Industry_Credential_Code | 17.4.0 | Varchar2(1050) | Migrated from [Students]PA_CTE_Ind_Cred. |
Credential_Earned_Date | 17.4.0 | Date | Migrated from [Students]PA_CTE_Cred_Date. |
Program_Performance_Code | 17.4.0 | Varchar2(3) | Migrated from [Students]PA_CTE_Prog_Perf_Cd. |
PELL_Grant_YN | 17.4.0 | Varchar2(1) | Migrated from [Students]PA_Pell_Grant. |
Academic_Instruction_Code | 17.4.0 | Varchar2(3) | Migrated from [Students]PA_Academic_Instruct_CD. |
Perkins_Concentrator_YN | 20.5.2.0 | Varchar2(1) | Data entry field to record Perkins Concentrator value |
Perkins_Participant_YN | 20.5.2.0 | Varchar2(1) | Data entry field to record Perkins Participator value |
Simulated_WorkEnv_YN | 20.5.2.0 | Varchar2(1) | Data entry field to record Simulated Work Environment value |
Cert_of_Apprenticeship | 20.5.2.0 | Varchar2(3) | Data entry field to record Certificate of Apprenticeship value |
Degree_Awarded | 20.5.2.0 | Varchar2(5) | Data entry field to record Degree Awarded value |
Adult_Cum_CreditEquiv | 20.5.2.0 | Number(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 |