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

StudentsDCID

15.7.3

Number(10,0)

The foreign key that links this record to the Students table.

CATE_Cert1

15.7.3

Varchar2(3)

A certification the student earned. Migrated from [Students.SC_CATE_Cert1].

CATE_Cert10

15.7.3

Varchar2(3)

A certification the student earned. Migrated from [Students.SC_CATE_Cert10].

CATE_Cert2

15.7.3

Varchar2(3)

A certification the student earned. Migrated from [Students.SC_CATE_Cert2].

CATE_Cert3

15.7.3

Varchar2(3)

A certification the student earned. Migrated from [Students.SC_CATE_Cert3].

CATE_Cert4

15.7.3

Varchar2(3)

A certification the student earned. Migrated from [Students.SC_CATE_Cert4].

CATE_Cert5

15.7.3

Varchar2(3)

A certification the student earned. Migrated from [Students.SC_CATE_Cert5].

CATE_Cert6

15.7.3

Varchar2(3)

A certification the student earned. Migrated from [Students.SC_CATE_Cert6].

CATE_Cert7

15.7.3

Varchar2(3)

A certification the student earned. Migrated from [Students.SC_CATE_Cert7].

CATE_Cert8

15.7.3

Varchar2(3)

A certification the student earned. Migrated from [Students.SC_CATE_Cert8]..

CATE_Cert9

15.7.3

Varchar2(3)

A certification the student earned. Migrated from [Students.SC_CATE_Cert9].

CATE_CIPCode

15.7.3

Varchar2(6)

The CIP Code that identifies the CATE program in which the student is enrolled. Migrated from [Students.SC_CATE_CIPCode].

CATE_CIPCode2

18.4.0

Varchar2(6)

The CIP Code that identifies the CATE program in which the student is enrolled.

CATE_CompleterInd

15.7.3

Varchar2(1)

Choose Yes if the student completed the CIP course. Migrated from [Students.SC_CATE_CompleterInd].

CATE_CompleterInd2

18.4.0

Varchar2(1)

Choose Yes if the student completed the CIP course.

CATE_CompleterInd3

24.8.2

Varchar2(1)

Choose Yes if the student completed the CIP course.

CATE_ConcntrInd

15.7.3

Varchar2(1)

Choose Yes if the student has a CATE Concentrator. Migrated from [Students.SC_CATE_ConcntrInd].

CATE_ConcntrInd2

18.4.0

Varchar2(1)

Choose Yes if the student has a CATE Concentrator.

CATE_DisplHomeMakerInd

15.7.3

Varchar2(1)

Choose Yes if the student meets the criteria for a displaced homemaker. Migrated from [Students.SC_CATE_DisplHomeMakerInd].

CATE_ExceptionsCode

15.7.3

Varchar2(1)

The reason the student did not earn a high school diploma. Migrated from [Students.SC_CATE_ExceptionsCode].

CATE_RemoteSchCode

15.7.3

Varchar2(7)

Enter the number identifying the remote school the student attends. Migrated from [Students.SC_CATE_RemoteSchCode].

CATE_RemoteSchCode2

18.4.0

Varchar2(7)

Enter the number identifying the remote school the student attends.

CATE_SingleParentInd

15.7.3

Varchar2(1)

Choose Yes if this student meets the criteria for a single parent. Migrated from [Students.SC_CATE_SingleParentInd].

CATE_Special_CIPCode

15.7.3

Varchar2(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_Units

18.4.0

Varchar2(1)

Select the number of CATE Units.

CATE_Units2

18.4.0

Varchar2(1)

Select the number of CATE Units.

CATE_YrCompleted

15.7.3

Varchar2(4)

The year the student completed the CIP program. Migrated from [Students.SC_CATE_YrCompleted].

CATE_YrCompleted2

18.4.0

Varchar2(4)

The year the student completed the CIP program.

CATE_YrCompleted3

24.7.3

Varchar2(4)

The year the student completed the CIP course.

Cert_Admin1

17.7.0

Varchar2(4)

Certification that has been administered to the student.

Cert_Admin10

17.7.0

Varchar2(4)

Certification that has been administered to the student.

Cert_Admin2

17.7.0

Varchar2(4)

Certification that has been administered to the student.

Cert_Admin3

17.7.0

Varchar2(4)

Certification that has been administered to the student.

Cert_Admin4

17.7.0

Varchar2(4)

Certification that has been administered to the student.

Cert_Admin5

17.7.0

Varchar2(4)

Certification that has been administered to the student.

Cert_Admin6

17.7.0

Varchar2(4)

Certification that has been administered to the student.

Cert_Admin7

17.7.0

Varchar2(4)

Certification that has been administered to the student.

Cert_Admin8

17.7.0

Varchar2(4)

Certification that has been administered to the student.

Cert_Admin9

17.7.0

Varchar2(4)

Certification that has been administered to the student.

Cert_AdminYear1

18.9.0

Varchar2(4)

The year the certification was administered to the student.

Cert_AdminYear10

18.9.0

Varchar2(4)

The year the certification was administered to the student.

Cert_AdminYear2

18.9.0

Varchar2(4)

The year the certification was administered to the student.

Cert_AdminYear3

18.9.0

Varchar2(4)

The year the certification was administered to the student.

Cert_AdminYear4

18.9.0

Varchar2(4)

The year the certification was administered to the student.

Cert_AdminYear5

18.9.0

Varchar2(4)

The year the certification was administered to the student.

Cert_AdminYear6

18.9.0

Varchar2(4)

The year the certification was administered to the student.

Cert_AdminYear7

18.9.0

Varchar2(4)

The year the certification was administered to the student.

Cert_AdminYear8

18.9.0

Varchar2(4)

The year the certification was administered to the student.

Cert_AdminYear9

18.9.0

Varchar2(4)

The year the certification was administered to the student.

Cert_Date1

15.8.0

Date

The date the accompanying Certification was awarded.

Cert_Date10

15.8.0

Date

The date the accompanying Certification was awarded.

Cert_Date2

15.8.0

Date

The date the accompanying Certification was awarded.

Cert_Date3

15.8.0

Date

The date the accompanying Certification was awarded.

Cert_Date4

15.8.0

Date

The date the accompanying Certification was awarded.

Cert_Date5

15.8.0

Date

The date the accompanying Certification was awarded.

Cert_Date6

15.8.0

Date

The date the accompanying Certification was awarded.

Cert_Date7

15.8.0

Date

The date the accompanying Certification was awarded.

Cert_Date8

15.8.0

Date

The date the accompanying Certification was awarded.

Cert_Date9

15.8.0

Date

The date the accompanying Certification was awarded.

Cert_Passed1

17.7.0

Varchar2(4)

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

Cert_Passed10

17.7.0

Varchar2(4)

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

Cert_Passed2

17.7.0

Varchar2(4)

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

Cert_Passed3

17.7.0

Varchar2(4)

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

Cert_Passed4

17.7.0

Varchar2(4)

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

Cert_Passed5

17.7.0

Varchar2(4)

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

Cert_Passed6

17.7.0

Varchar2(4)

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

Cert_Passed7

17.7.0

Varchar2(4)

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

Cert_Passed8

17.7.0

Varchar2(4)

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

Cert_Passed9

17.7.0

Varchar2(4)

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

Cert_Year1

16.9.0

Varchar2(4)

The year the accompanying Certification was awarded.

Cert_Year10

16.9.0

Varchar2(4)

The year the accompanying Certification was awarded.

Cert_Year2

16.9.0

Varchar2(4)

The year the accompanying Certification was awarded.

Cert_Year3

16.9.0

Varchar2(4)

The year the accompanying Certification was awarded.

Cert_Year4

16.9.0

Varchar2(4)

The year the accompanying Certification was awarded.

Cert_Year5

16.9.0

Varchar2(4)

The year the accompanying Certification was awarded.

Cert_Year6

16.9.0

Varchar2(4)

The year the accompanying Certification was awarded.

Cert_Year7

16.9.0

Varchar2(4)

The year the accompanying Certification was awarded.

Cert_Year8

16.9.0

Varchar2(4)

The year the accompanying Certification was awarded.

Cert_Year9

16.9.0

Varchar2(4)

The year the accompanying Certification was awarded.

CTSO_Membership1

17.7.0

Varchar2(2)

CTSO(Career Technical Student Organization) Membership to indicate what type of organization of CTSO member belongs to.

CTSO_Membership2

17.7.0

Varchar2(2)

CTSO(Career Technical Student Organization) Membership to indicate what type of organization of CTSO member belongs to.

PlaceEmployer

15.7.3

Varchar2(35)

The name of the student's employer if employed. Migrated from [Students.SC_CATE_PlaceEmployer].

PlaceHigherEdName

15.7.3

Varchar2(25)

The name of the higher education facility if the student is enrolled in one. Migrated from [Students.SC_CATE_HigherEdName].

PlaceHigherEdProg

15.7.3

Varchar2(25)

The name of the higher education program if the student is enrolled in one.. Migrated from [Students.SC_CATE_PlaceHigherEdProg].

PlaceJobTitle

15.7.3 

Varchar2(25)

The student's job title if the student is employed. Migrated from[Students.SC_CATE_PlaceJobTitle].

PlaceLevelCode

15.7.3 

Varchar2(1)

The student's placement after completing the CIP course. Migrated from [Students.SC_CATE_PlaceLevelCode].

PlaceMilitaryBranch

15.7.3 

Varchar2(30)

The military branch the student joined if they joined the military. Migrated from [Students.SC_CATE_PlaceMilitaryBranch].

PlaceMilitaryTrain

15.7.3

Varchar2(30)

The place where the student is receiving military training if the student joined the military. Migrated from [Students.SC_CATE_PlaceMilitaryTrain].

PlacePhone

15.7.3 

Varchar2(25)

The student's work phone number if the student is employed. Migrated from [Students.SC_CATE_PlacePhone].

PlaceStartDate

15.7.3 

Varchar2(15)

The date the student started work for this employer if employed. Migrated from [Students.SC_CATE_PlaceStartDate].

PlaceSupervisorName

15.7.3

Varchar2(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.