Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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