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_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. |
| 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]. |