S_PA_STU_CTE_X (ver 17.4.0)
This table is an extension of the [Students] table.
| 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 |
| Industry_Credential_Code2 | 23.5.1.0 | Varchar2(1050) | Data Entry field to record additional Industrial Credential Code |
| Industry_Credential_Code3 | 23.5.1.0 | Varchar2(1050) | Data Entry field to record additional Industrial Credential Code |
| Industry_Credential_Code4 | 23.5.1.0 | Varchar2(1050) | Data Entry field to record additional Industrial Credential Code |
| Industry_Credential_Code5 | 23.5.1.0 | Varchar2(1050) | Data Entry field to record additional Industrial Credential Code |
| Credential_Earned_Date2 | 23.5.1.0 | Date | Data Entry field to record additional Credential Earned Date |
| Credential_Earned_Date3 | 23.5.1.0 | Date | Data Entry field to record additional Credential Earned Date |
| Credential_Earned_Date4 | 23.5.1.0 | Date | Data Entry field to record additional Credential Earned Date |
| Credential_Earned_Date5 | 23.5.1.0 | Date | Data Entry field to record additional Credential Earned Date |