S_OR_STU_CTE_X (ver 14.4.0)
This table is an extension of the [Students] table. These fields are related to Career and Technical Education.
Column Name | Version | Data Type | Description |
---|---|---|---|
StudentsDCID | 14.4.0 | Number(10,0) | Primary key that relates the extended table back to the Students table. |
AcdmDsvntgFg | 15.10.3 | Number(1,0) | Indicates the student is academically disadvantaged and requires special services and assistance in order to succeed. Migrated from [Students.OR_PTEAcdmDisadv]. |
Asmt1AdminDt | 15.10.3 | Date | The date the first CTE assessment was administered. Migrated from [Students.OR_CTEAsmt1AdminDt]. |
Asmt1PassCd | 15.10.3 | Varchar2(1) | The pass status for the first CTE assessment. Migrated from [Students.OR_CTEAsmt1PassCd]. |
Asmt1TypCd | 15.10.3 | Varchar2(2) | Indicates the first CTE assessment type. Migrated from [Students.OR_CTEAsmt1TypCd]. |
Asmt2AdminDt | 15.10.3 | Date | The date the second CTE assessment was administered. Migrated from [Students.OR_CTEAsmt2AdminDt]. |
Asmt2PassCd | 15.10.3 | Varchar2(1) | The pass status for the second CTE assessment. Migrated from [Students.OR_CTEAsmt2PassCd]. |
Asmt2TypCd | 15.10.3 | Varchar2(2) | Indicates the second CTE assessment type. Migrated from [Students.OR_CTEAsmt2TypCd]. |
AssessmentIDCode1 | 15.10.3 | Varchar2(10) | CTE Technical Skill/Credential Identification Code for first assessment. |
AssessmentIDCode2 | 15.10.3 | Varchar2(10) | CTE Technical Skill/Credential Identification Code for the second assessment. |
CareerRltdLrnExp1 | 15.10.3 | Varchar2(1) | Code indicating the first type of Career-Related Learning Experience in which the student participated. Migrated from [Students.OR_PTECareerRltdLrnExp1]. |
CareerRltdLrnExp2 | 15.10.3 | Varchar2(1) | Code indicating the second type of Career-Related Learning Experience in which the student participated. Migrated from [Students.OR_PTECareerRltdLrnExp2]. |
CareerRltdLrnExp3 | 15.10.3 | Varchar2(1) | Code indicating the third type of Career-Related Learning Experience in which the student participated. Migrated from [Students.OR_PTECareerRltdLrnExp3]. |
CareerRltdLrnExp4 | 15.10.3 | Varchar2(1) | Code indicating the fourth type of Career-Related Learning Experience in which the student participated. Migrated from [Students.OR_PTECareerRltdLrnExp4]. |
CTEAsmt1CIPCd | 14.4.0 | Varchar2(7) | NCES Classification of Instructional Programs (CIP) code indicating the career area and program area for the first assessment taken by the student with one implied decimal point (format: XX.XXXX). |
CTEAsmt2CIPCd | 14.4.0 | Varchar2(7) | NCES Classification of Instructional Programs (CIP) code indicating the career area and program area for the second assessment taken by the student with one implied decimal point (format: XX.XXXX). |
StdntLdrOrg1 | 15.10.3 | Varchar2(1) | Code indicating the first type of Student Leadership Organization to which the student belongs. Migrated from [Students.OR_PTEStdntLdrOrg1]. |
StdntLdrOrg2 | 15.10.3 | Varchar2(1) | Code indicating the second type of Student Leadership Organization to which the student belongs. Migrated from [Students.OR_PTEStdntLdrOrg2]. |
StdntLdrOrg3 | 15.10.3 | Varchar2(1) | Code indicating the third type of Student Leadership Organization to which the student belongs. Migrated from [Students.OR_PTEStdntLdrOrg3]. |
StdntLdrOrg4 | 15.10.3 | Varchar2(1) | Code indicating the fourth type of Student Leadership Organization to which the student belongs. Migrated from [Students.OR_PTEStdntLdrOrg4]. |
YrEndStatus | 15.10.3 | Varchar2(1) | Code indicating the student's status as of the end of the school year. Migrated from [Students.OR_PTEYrEndStatus]. |
WBLTypCd1 | 20.12.2 | Varchar2(1) | Work-Based Learning Type Code 1 |
WBLHrsCd1 | 20.12.2 | Varchar2(7) | Work-Based Learning Hours Code 1 |
WBLTypCd2 | 20.12.2 | Varchar2(1) | Work-Based Learning Type Code 2 |
WBLHrsCd2 | 20.12.2 | Varchar2(7) | Work-Based Learning Hours Code 2 |
WBLTypCd3 | 20.12.2 | Varchar2(1) | Work-Based Learning Type Code 3 |
WBLHrsCd3 | 20.12.2 | Varchar2(7) | Work-Based Learning Hours Code 3 |
WBLTypCd4 | 20.12.2 | Varchar2(1) | Work-Based Learning Type Code 4 |
WBLHrsCd4 | 20.12.2 | Varchar2(7) | Work-Based Learning Hours Code 4 |
IRCCd1 | 20.12.2 | Varchar2(10) | CTE Industry-Recognized Credential Code 1 |
IRCAdmnDt1 | 20.12.2 | Date | CTE Industry-Recognized Credential Administration Date 2 |
IRCCIPCd1 | 20.12.2 | Varchar2(6) | CTE Industry-Recognized Credential CIP Code 1 |
IRCPassCd1 | 20.12.2 | Varchar2(1) | CTE Industry-Recognized Credential Pass Indicator 1 |
IRCCd2 | 20.12.2 | Varchar2(10) | CTE Industry-Recognized Credential Code 2 |
IRCAdmnDt2 | 20.12.2 | Date | CTE Industry-Recognized Credential Administration Date 2 |
IRCCIPCd2 | 20.12.2 | Varchar2(6) | CTE Industry-Recognized Credential CIP Code 2 |
IRCPassCd2 | 20.12.2 | Varchar2(1) | CTE Industry-Recognized Credential Pass Indicator 2 |
WBLCIPCd1 | 23.4.3.0 | Varchar2(7) | Work-Based Learning CIP Code 1 |
WBLCIPCd2 | 23.4.3.0 | Varchar2(7) | Work-Based Learning CIP Code 2 |
WBLCIPCd3 | 23.4.3.0 | Varchar2(7) | Work-Based Learning CIP Code 3 |
WBLCIPCd1 | 23.4.3.0 | Varchar2(7) | Work-Based Learning CIP Code 4 |