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 |