Skip to main content
Skip table of contents

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.

AcdmDsvntgFg15.10.3Number(1,0)Indicates the student is academically disadvantaged and requires special services and assistance in order to succeed. Migrated from [Students.OR_PTEAcdmDisadv].
Asmt1AdminDt15.10.3DateThe date the first CTE assessment was administered. Migrated from [Students.OR_CTEAsmt1AdminDt].
Asmt1PassCd15.10.3Varchar2(1)The pass status for the first CTE assessment. Migrated from [Students.OR_CTEAsmt1PassCd].
Asmt1TypCd15.10.3Varchar2(2)Indicates the first CTE assessment type. Migrated from [Students.OR_CTEAsmt1TypCd].
Asmt2AdminDt15.10.3DateThe date the second CTE assessment was administered. Migrated from [Students.OR_CTEAsmt2AdminDt].
Asmt2PassCd15.10.3Varchar2(1)The pass status for the second CTE assessment. Migrated from [Students.OR_CTEAsmt2PassCd].
Asmt2TypCd15.10.3Varchar2(2)Indicates the second CTE assessment type. Migrated from [Students.OR_CTEAsmt2TypCd].
AssessmentIDCode115.10.3Varchar2(10)CTE Technical Skill/Credential Identification Code for first assessment.
AssessmentIDCode215.10.3Varchar2(10)CTE Technical Skill/Credential Identification Code for the second assessment.
CareerRltdLrnExp115.10.3Varchar2(1)Code indicating the first type of Career-Related Learning Experience in which the student participated. Migrated from [Students.OR_PTECareerRltdLrnExp1].
CareerRltdLrnExp215.10.3Varchar2(1)Code indicating the second type of Career-Related Learning Experience in which the student participated. Migrated from [Students.OR_PTECareerRltdLrnExp2].
CareerRltdLrnExp315.10.3Varchar2(1)Code indicating the third type of Career-Related Learning Experience in which the student participated. Migrated from [Students.OR_PTECareerRltdLrnExp3].
CareerRltdLrnExp415.10.3Varchar2(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).

StdntLdrOrg115.10.3Varchar2(1)Code indicating the first type of Student Leadership Organization to which the student belongs. Migrated from [Students.OR_PTEStdntLdrOrg1].
StdntLdrOrg215.10.3Varchar2(1)Code indicating the second type of Student Leadership Organization to which the student belongs. Migrated from [Students.OR_PTEStdntLdrOrg2].
StdntLdrOrg315.10.3Varchar2(1)Code indicating the third type of Student Leadership Organization to which the student belongs. Migrated from [Students.OR_PTEStdntLdrOrg3].
StdntLdrOrg415.10.3Varchar2(1)Code indicating the fourth type of Student Leadership Organization to which the student belongs. Migrated from [Students.OR_PTEStdntLdrOrg4].
YrEndStatus15.10.3Varchar2(1)Code indicating the student's status as of the end of the school year. Migrated from [Students.OR_PTEYrEndStatus].
WBLTypCd120.12.2Varchar2(1)Work-Based Learning Type Code 1
WBLHrsCd120.12.2Varchar2(7)Work-Based Learning Hours Code 1
WBLTypCd220.12.2Varchar2(1)Work-Based Learning Type Code 2
WBLHrsCd220.12.2Varchar2(7)Work-Based Learning Hours Code 2
WBLTypCd320.12.2Varchar2(1)Work-Based Learning Type Code 3
WBLHrsCd320.12.2Varchar2(7)Work-Based Learning Hours Code 3
WBLTypCd420.12.2Varchar2(1)Work-Based Learning Type Code 4
WBLHrsCd420.12.2Varchar2(7)Work-Based Learning Hours Code 4
IRCCd120.12.2Varchar2(10)CTE Industry-Recognized Credential Code 1
IRCAdmnDt120.12.2DateCTE Industry-Recognized Credential Administration Date 2
IRCCIPCd120.12.2Varchar2(6)CTE Industry-Recognized Credential CIP Code 1
IRCPassCd120.12.2Varchar2(1)CTE Industry-Recognized Credential Pass Indicator 1
IRCCd220.12.2Varchar2(10)CTE Industry-Recognized Credential Code 2
IRCAdmnDt220.12.2DateCTE Industry-Recognized Credential Administration Date 2
IRCCIPCd220.12.2Varchar2(6)CTE Industry-Recognized Credential CIP Code 2
IRCPassCd220.12.2Varchar2(1)CTE Industry-Recognized Credential Pass Indicator 2
WBLCIPCd123.4.3.0Varchar2(7)Work-Based Learning CIP Code 1
WBLCIPCd223.4.3.0Varchar2(7)Work-Based Learning CIP Code 2
WBLCIPCd323.4.3.0Varchar2(7)Work-Based Learning CIP Code 3
WBLCIPCd123.4.3.0Varchar2(7)Work-Based Learning CIP Code 4




JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.