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 |