STUDENT CLRHSE CORE 2 DETAIL Table
View exposing student clrhse core 2 detail data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LOAD_SEQUENCE |
Load sequence associated with the record. |
VARCHAR2 |
20 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PROGRAM_1_BEGIN_DATE |
Date associated with program 1 begin. |
VARCHAR2 |
8 |
PROGRAM_1_CIP_CODE |
Code identifying program 1 cip. |
VARCHAR2 |
6 |
PROGRAM_1_CIP_YEAR |
Program 1 cip year associated with the record. |
VARCHAR2 |
4 |
PROGRAM_1_CREDENTIAL |
Program 1 credential associated with the record. |
VARCHAR2 |
2 |
PROGRAM_1_ENROLLMENT_STATUS |
Program 1 enrollment status associated with the record. |
VARCHAR2 |
8 |
PROGRAM_1_LENGTH |
Program 1 length associated with the record. |
VARCHAR2 |
6 |
PROGRAM_1_LENGTH_MEASUREMENT |
Program 1 length measurement associated with the record. |
VARCHAR2 |
1 |
PROGRAM_1_SPECIAL_INDICATOR |
Indicator identifying whether program 1 special (Y/N). |
VARCHAR2 |
1 |
PROGRAM_1_STATUS_DATE |
Date associated with program 1 status. |
VARCHAR2 |
8 |
PROGRAM_1_TITLE_IV_YEAR |
Program 1 title iv year associated with the record. |
VARCHAR2 |
6 |
PROGRAM_2_BEGIN_DATE |
Date associated with program 2 begin. |
VARCHAR2 |
8 |
PROGRAM_2_CIP_CODE |
Code identifying program 2 cip. |
VARCHAR2 |
6 |
PROGRAM_2_CIP_YEAR |
Program 2 cip year associated with the record. |
VARCHAR2 |
4 |
PROGRAM_2_CREDENTIAL |
Program 2 credential associated with the record. |
VARCHAR2 |
2 |
PROGRAM_2_ENROLLMENT_STATUS |
Program 2 enrollment status associated with the record. |
VARCHAR2 |
8 |
PROGRAM_2_LENGTH |
Program 2 length associated with the record. |
VARCHAR2 |
6 |
PROGRAM_2_LENGTH_MEASUREMENT |
Program 2 length measurement associated with the record. |
VARCHAR2 |
1 |
PROGRAM_2_SPECIAL_INDICATOR |
Indicator identifying whether program 2 special (Y/N). |
VARCHAR2 |
1 |
PROGRAM_2_STATUS_DATE |
Date associated with program 2 status. |
VARCHAR2 |
8 |
PROGRAM_2_TITLE_IV_YEAR |
Program 2 title iv year associated with the record. |
VARCHAR2 |
6 |
PROGRAM_3_BEGIN_DATE |
Date associated with program 3 begin. |
VARCHAR2 |
8 |
PROGRAM_3_CIP_CODE |
Code identifying program 3 cip. |
VARCHAR2 |
6 |
PROGRAM_3_CIP_YEAR |
Program 3 cip year associated with the record. |
VARCHAR2 |
4 |
PROGRAM_3_CREDENTIAL |
Program 3 credential associated with the record. |
VARCHAR2 |
2 |
PROGRAM_3_ENROLLMENT_STATUS |
Program 3 enrollment status associated with the record. |
VARCHAR2 |
8 |
PROGRAM_3_LENGTH |
Program 3 length associated with the record. |
VARCHAR2 |
6 |
PROGRAM_3_LENGTH_MEASUREMENT |
Program 3 length measurement associated with the record. |
VARCHAR2 |
1 |
PROGRAM_3_SPECIAL_INDICATOR |
Indicator identifying whether program 3 special (Y/N). |
VARCHAR2 |
1 |
PROGRAM_3_STATUS_DATE |
Date associated with program 3 status. |
VARCHAR2 |
8 |
PROGRAM_3_TITLE_IV_YEAR |
Program 3 title iv year associated with the record. |
VARCHAR2 |
6 |
PROGRAM_4_BEGIN_DATE |
Date associated with program 4 begin. |
VARCHAR2 |
8 |
PROGRAM_4_CIP_CODE |
Code identifying program 4 cip. |
VARCHAR2 |
6 |
PROGRAM_4_CIP_YEAR |
Program 4 cip year associated with the record. |
VARCHAR2 |
4 |
PROGRAM_4_CREDENTIAL |
Program 4 credential associated with the record. |
VARCHAR2 |
2 |
PROGRAM_4_ENROLLMENT_STATUS |
Program 4 enrollment status associated with the record. |
VARCHAR2 |
8 |
PROGRAM_4_LENGTH |
Program 4 length associated with the record. |
VARCHAR2 |
6 |
PROGRAM_4_LENGTH_MEASUREMENT |
Program 4 length measurement associated with the record. |
VARCHAR2 |
1 |
PROGRAM_4_SPECIAL_INDICATOR |
Indicator identifying whether program 4 special (Y/N). |
VARCHAR2 |
1 |
PROGRAM_4_STATUS_DATE |
Date associated with program 4 status. |
VARCHAR2 |
8 |
PROGRAM_4_TITLE_IV_YEAR |
Program 4 title iv year associated with the record. |
VARCHAR2 |
6 |
PROGRAM_5_BEGIN_DATE |
Date associated with program 5 begin. |
VARCHAR2 |
8 |
PROGRAM_5_CIP_CODE |
Code identifying program 5 cip. |
VARCHAR2 |
6 |
PROGRAM_5_CIP_YEAR |
Program 5 cip year associated with the record. |
VARCHAR2 |
4 |
PROGRAM_5_CREDENTIAL |
Program 5 credential associated with the record. |
VARCHAR2 |
2 |
PROGRAM_5_ENROLLMENT_STATUS |
Program 5 enrollment status associated with the record. |
VARCHAR2 |
8 |
PROGRAM_5_LENGTH |
Program 5 length associated with the record. |
VARCHAR2 |
6 |
PROGRAM_5_LENGTH_MEASUREMENT |
Program 5 length measurement associated with the record. |
VARCHAR2 |
1 |
PROGRAM_5_SPECIAL_INDICATOR |
Indicator identifying whether program 5 special (Y/N). |
VARCHAR2 |
1 |
PROGRAM_5_STATUS_DATE |
Date associated with program 5 status. |
VARCHAR2 |
8 |
PROGRAM_5_TITLE_IV_YEAR |
Program 5 title iv year associated with the record. |
VARCHAR2 |
6 |
PROGRAM_6_BEGIN_DATE |
Date associated with program 6 begin. |
VARCHAR2 |
8 |
PROGRAM_6_CIP_CODE |
Code identifying program 6 cip. |
VARCHAR2 |
6 |
PROGRAM_6_CIP_YEAR |
Program 6 cip year associated with the record. |
VARCHAR2 |
4 |
PROGRAM_6_CREDENTIAL |
Program 6 credential associated with the record. |
VARCHAR2 |
2 |
PROGRAM_6_ENROLLMENT_STATUS |
Program 6 enrollment status associated with the record. |
VARCHAR2 |
8 |
PROGRAM_6_LENGTH |
Program 6 length associated with the record. |
VARCHAR2 |
6 |
PROGRAM_6_LENGTH_MEASUREMENT |
Program 6 length measurement associated with the record. |
VARCHAR2 |
1 |
PROGRAM_6_SPECIAL_INDICATOR |
Indicator identifying whether program 6 special (Y/N). |
VARCHAR2 |
1 |
PROGRAM_6_STATUS_DATE |
Date associated with program 6 status. |
VARCHAR2 |
8 |
PROGRAM_6_TITLE_IV_YEAR |
Program 6 title iv year associated with the record. |
VARCHAR2 |
6 |
TERM_CODE |
Term code associated with the record. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |