STUDENT DEGREE AWARDED Table
View exposing student degree awarded data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CIP_PROGRAM_CODE |
Code identifying cip program. |
VARCHAR2 |
6 |
DEGREE_AWARD_DATE |
Date associated with degree award. |
DATE |
|
DEGREE_AWARD_TERM |
Degree award term associated with the record. |
VARCHAR2 |
6 |
DEGREE_CATEGORY |
Degree category associated with the record. |
VARCHAR2 |
30 |
DEGREE_CODE |
Code identifying degree. |
VARCHAR2 |
8 |
DEGREE_DEPARTMENT |
Degree department associated with the record. |
VARCHAR2 |
4 |
DEGREE_DEPARTMENT_DESC |
Description of degree department. |
VARCHAR2 |
240 |
DEGREE_DESC |
Description of degree. |
VARCHAR2 |
240 |
DEGREE_GROUPING |
Degree grouping associated with the record. |
VARCHAR2 |
120 |
DEGREE_OPTION |
Degree option associated with the record. |
VARCHAR2 |
4 |
DEGREE_TYPE |
Degree type associated with the record. |
VARCHAR2 |
3 |
DEGREE_TYPE_DESC |
Description of degree type. |
VARCHAR2 |
100 |
DEPT_NAME_IN_COMMENCEMENT_BK |
Dept name in commencement bk associated with the record. |
VARCHAR2 |
80 |
FULL_NAME |
Full name associated with the person or organization. |
VARCHAR2 |
80 |
IS_DEGREES_CONFIDENTIAL |
Indicator identifying whether degrees confidential (Y/N). |
VARCHAR2 |
1 |
IS_DOUBLE_MAJOR |
Indicator identifying whether double major (Y/N). |
VARCHAR2 |
1 |
IS_PRIMARY_COURSE_OF_MAJOR |
Indicator identifying whether primary course of major (Y/N). |
VARCHAR2 |
1 |
MINOR_CODE_1 |
Minor code 1 associated with the record. |
VARCHAR2 |
4 |
MINOR_CODE_2 |
Minor code 2 associated with the record. |
VARCHAR2 |
4 |
MINOR_DESC_1 |
Minor desc 1 associated with the record. |
VARCHAR2 |
100 |
MINOR_DESC_2 |
Minor desc 2 associated with the record. |
VARCHAR2 |
100 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
|
SCHOOL_NAME_IN_COMMENCEMENT_BK |
School name in commencement bk associated with the record. |
VARCHAR2 |
60 |
THESIS_FIELD |
Thesis field associated with the record. |
VARCHAR2 |
300 |
THESIS_TITLE |
Thesis title associated with the record. |
VARCHAR2 |
500 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |