STUDENT MINOR FIELD Table
A dimension table used together with fact table STUDENT_MINOR_DETAIL. It contains the characteristics of a minor field, including the minor field (eg. Music, Compartive Media Studies, Architecture, Biomedical Engineering, Chinese, Economics), minor type (Proposed, Completed), minor sequence (Minor 1 or Minor 2), the department offers the minor (eg. HASS, Sloan, Physics, etc.)
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
MINOR_DEPARTMENT |
Department (eg. HASS, Sloan, Physics) which offers the minor. |
VARCHAR2 |
4 |
MINOR_FIELD |
Descriptive name of the minor field. |
VARCHAR2 |
60 |
MINOR_FIELD_CODE |
Minor field (eg. "14" for Economics, "15" for Management) |
VARCHAR2 |
4 |
MINOR_FIELD_SORT |
Use to sort Minor Fields |
VARCHAR2 |
4 |
MINOR_FIELD_STATUS |
Status of the minor field. |
VARCHAR2 |
1 |
MINOR_SEQUENCE |
Sequence number for the minor field. |
VARCHAR2 |
6 |
MINOR_TYPE |
Descriptive name for MINOR_TYPE_CODE. |
VARCHAR2 |
50 |
MINOR_TYPE_CODE |
Types of Minor: MCFORM (Minor Completed), MPROP (Minor Proposed) |
VARCHAR2 |
6 |
SCHOOL |
The name of the school from which the person earned the highest or most recent degree. |
VARCHAR2 |
50 |
STUDENT_MINOR_FIELD_KEY |
Use this field to join together the tables STUDENT_MINOR_DETAIL and STUDENT_MINOR_FIELD. |
VARCHAR2 |
20 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |