Skip to main content
Skip table of contents

S_SC_STU_CATE_X (ver 18.8.0)

This table is an extension of the Students table.

Column Name

Version

Data Type

Description

StudentsDCID15.7.3Number(10,0)The foreign key that links this record to the Students table.

CATE_Cert1

15.7.3Varchar2(3)A certification the student earned. Migrated from [Students.SC_CATE_Cert1].

CATE_Cert10

15.7.3Varchar2(3)A certification the student earned. Migrated from [Students.SC_CATE_Cert10].

CATE_Cert2

15.7.3Varchar2(3)A certification the student earned. Migrated from [Students.SC_CATE_Cert2].

CATE_Cert3

15.7.3Varchar2(3)A certification the student earned. Migrated from [Students.SC_CATE_Cert3].

CATE_Cert4

15.7.3Varchar2(3)A certification the student earned. Migrated from [Students.SC_CATE_Cert4].

CATE_Cert5

15.7.3Varchar2(3)A certification the student earned. Migrated from [Students.SC_CATE_Cert5].

CATE_Cert6

15.7.3Varchar2(3)A certification the student earned. Migrated from [Students.SC_CATE_Cert6].

CATE_Cert7

15.7.3Varchar2(3)A certification the student earned. Migrated from [Students.SC_CATE_Cert7].

CATE_Cert8

15.7.3Varchar2(3)A certification the student earned. Migrated from [Students.SC_CATE_Cert8]..

CATE_Cert9

15.7.3Varchar2(3)A certification the student earned. Migrated from [Students.SC_CATE_Cert9].

CATE_CIPCode

15.7.3Varchar2(6)The CIP Code that identifies the CATE program in which the student is enrolled. Migrated from [Students.SC_CATE_CIPCode].
CATE_CIPCode218.4.0Varchar2(6)The CIP Code that identifies the CATE program in which the student is enrolled.

CATE_CompleterInd

15.7.3Varchar2(1)Choose Yes if the student completed the CIP course. Migrated from [Students.SC_CATE_CompleterInd].
CATE_CompleterInd218.4.0Varchar2(1)Choose Yes if the student completed the CIP course.

CATE_ConcntrInd

15.7.3Varchar2(1)Choose Yes if the student has a CATE Concentrator. Migrated from [Students.SC_CATE_ConcntrInd].
CATE_ConcntrInd218.4.0Varchar2(1)Choose Yes if the student has a CATE Concentrator.

CATE_DisplHomeMakerInd

15.7.3Varchar2(1)Choose Yes if the student meets the criteria for a displaced homemaker. Migrated from [Students.SC_CATE_DisplHomeMakerInd].

CATE_ExceptionsCode

15.7.3Varchar2(1)The reason the student did not earn a high school diploma. Migrated from [Students.SC_CATE_ExceptionsCode].

CATE_RemoteSchCode

15.7.3Varchar2(7)Enter the number identifying the remote school the student attends. Migrated from [Students.SC_CATE_RemoteSchCode].
CATE_RemoteSchCode218.4.0Varchar2(7)Enter the number identifying the remote school the student attends.

CATE_SingleParentInd

15.7.3Varchar2(1)Choose Yes if this student meets the criteria for a single parent. Migrated from [Students.SC_CATE_SingleParentInd].

CATE_Special_CIPCode

15.7.3Varchar2(6)The custom or cross-cluster CIP Code that identifies the CATE program in which the student is enrolled. Migrated from [Students.SC_CATE_Special_CIPCode].
CATE_Units18.4.0Varchar2(1)Select the number of CATE Units.
CATE_Units218.4.0Varchar2(1)Select the number of CATE Units.

CATE_YrCompleted

15.7.3Varchar2(4)The year the student completed the CIP program. Migrated from [Students.SC_CATE_YrCompleted].
CATE_YrCompleted218.4.0Varchar2(4)The year the student completed the CIP program.
Cert_Admin117.7.0Varchar2(4)

Certification that has been administered to the student.

Cert_Admin1017.7.0Varchar2(4)Certification that has been administered to the student.
Cert_Admin217.7.0Varchar2(4)Certification that has been administered to the student.
Cert_Admin317.7.0Varchar2(4)Certification that has been administered to the student.
Cert_Admin417.7.0Varchar2(4)Certification that has been administered to the student.
Cert_Admin517.7.0Varchar2(4)Certification that has been administered to the student.
Cert_Admin617.7.0Varchar2(4)Certification that has been administered to the student.
Cert_Admin717.7.0Varchar2(4)Certification that has been administered to the student.
Cert_Admin817.7.0Varchar2(4)Certification that has been administered to the student.
Cert_Admin917.7.0Varchar2(4)Certification that has been administered to the student.
Cert_AdminYear118.9.0Varchar2(4)The year the certification was administered to the student.
Cert_AdminYear1018.9.0Varchar2(4)The year the certification was administered to the student.
Cert_AdminYear218.9.0Varchar2(4)The year the certification was administered to the student.
Cert_AdminYear318.9.0Varchar2(4)The year the certification was administered to the student.
Cert_AdminYear418.9.0Varchar2(4)The year the certification was administered to the student.
Cert_AdminYear518.9.0Varchar2(4)The year the certification was administered to the student.
Cert_AdminYear618.9.0Varchar2(4)The year the certification was administered to the student.
Cert_AdminYear718.9.0Varchar2(4)The year the certification was administered to the student.
Cert_AdminYear818.9.0Varchar2(4)The year the certification was administered to the student.
Cert_AdminYear918.9.0Varchar2(4)The year the certification was administered to the student.
Cert_Date115.8.0DateThe date the accompanying Certification was awarded.
Cert_Date1015.8.0DateThe date the accompanying Certification was awarded.
Cert_Date215.8.0DateThe date the accompanying Certification was awarded.
Cert_Date315.8.0DateThe date the accompanying Certification was awarded.
Cert_Date415.8.0DateThe date the accompanying Certification was awarded.
Cert_Date515.8.0DateThe date the accompanying Certification was awarded.
Cert_Date615.8.0DateThe date the accompanying Certification was awarded.
Cert_Date715.8.0DateThe date the accompanying Certification was awarded.
Cert_Date815.8.0DateThe date the accompanying Certification was awarded.
Cert_Date915.8.0DateThe date the accompanying Certification was awarded.
Cert_Passed117.7.0Varchar2(4)

Student has passed the Administered Cert passed the Certification that was Administered.

Cert_Passed1017.7.0Varchar2(4)Student has passed the Administered Cert passed the Certification that was Administered.
Cert_Passed217.7.0Varchar2(4)

Student has passed the Administered Cert passed the Certification that was Administered.

Cert_Passed317.7.0Varchar2(4)Student has passed the Administered Cert passed the Certification that was Administered.
Cert_Passed417.7.0Varchar2(4)Student has passed the Administered Cert passed the Certification that was Administered.
Cert_Passed517.7.0Varchar2(4)Student has passed the Administered Cert passed the Certification that was Administered.
Cert_Passed617.7.0Varchar2(4)Student has passed the Administered Cert passed the Certification that was Administered.
Cert_Passed717.7.0Varchar2(4)Student has passed the Administered Cert passed the Certification that was Administered.
Cert_Passed817.7.0Varchar2(4)Student has passed the Administered Cert passed the Certification that was Administered.
Cert_Passed917.7.0Varchar2(4)Student has passed the Administered Cert passed the Certification that was Administered.
Cert_Year116.9.0Varchar2(4)The year the accompanying Certification was awarded.
Cert_Year1016.9.0Varchar2(4)The year the accompanying Certification was awarded.
Cert_Year216.9.0Varchar2(4)The year the accompanying Certification was awarded.
Cert_Year316.9.0Varchar2(4)The year the accompanying Certification was awarded.
Cert_Year416.9.0Varchar2(4)The year the accompanying Certification was awarded.
Cert_Year516.9.0Varchar2(4)The year the accompanying Certification was awarded.
Cert_Year616.9.0Varchar2(4)The year the accompanying Certification was awarded.
Cert_Year716.9.0Varchar2(4)The year the accompanying Certification was awarded.
Cert_Year816.9.0Varchar2(4)The year the accompanying Certification was awarded.
Cert_Year916.9.0Varchar2(4)The year the accompanying Certification was awarded.
CTSO_Membership117.7.0Varchar2(2)CTSO(Career Technical Student Organization) Membership to indicate what type of organization of CTSO member belongs to.
CTSO_Membership217.7.0Varchar2(2)CTSO(Career Technical Student Organization) Membership to indicate what type of organization of CTSO member belongs to.
PlaceEmployer15.7.3Varchar2(35)The name of the student's employer if employed. Migrated from [Students.SC_CATE_PlaceEmployer].

PlaceHigherEdName

15.7.3Varchar2(25)The name of the higher education facility if the student is enrolled in one. Migrated from [Students.SC_CATE_HigherEdName].
PlaceHigherEdProg15.7.3Varchar2(25)The name of the higher education program if the student is enrolled in one.. Migrated from [Students.SC_CATE_PlaceHigherEdProg].
PlaceJobTitle15.7.3 Varchar2(25)The student's job title if the student is employed. Migrated from[Students.SC_CATE_PlaceJobTitle].
PlaceLevelCode15.7.3 Varchar2(1)The student's placement after completing the CIP course. Migrated from [Students.SC_CATE_PlaceLevelCode].
PlaceMilitaryBranch15.7.3 Varchar2(30)The military branch the student joined if they joined the military. Migrated from [Students.SC_CATE_PlaceMilitaryBranch].
PlaceMilitaryTrain15.7.3Varchar2(30)The place where the student is receiving military training if the student joined the military. Migrated from [Students.SC_CATE_PlaceMilitaryTrain].
PlacePhone15.7.3 Varchar2(25)The student's work phone number if the student is employed. Migrated from [Students.SC_CATE_PlacePhone].
PlaceStartDate15.7.3 Varchar2(15)The date the student started work for this employer if employed. Migrated from [Students.SC_CATE_PlaceStartDate].
PlaceSupervisorName15.7.3Varchar2(25)The name of the student's supervisor if employed. Migrated from [Students.SC_CATE_PlaceSupervisorName].



JavaScript errors detected

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

If this problem persists, please contact our support.