Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT MINOR FIELD Table


View exposing student minor field data.


Field Name

Description

Data Type

Length

LAST_ACTIVITY_DATE

Date associated with last activity.

DATE

MINOR_DEPARTMENT

Minor department associated with the record.

VARCHAR2

4

MINOR_FIELD

Minor field associated with the record.

VARCHAR2

60

MINOR_FIELD_CODE

Code identifying minor field.

VARCHAR2

4

MINOR_FIELD_SORT

Minor field sort associated with the record.

VARCHAR2

4

MINOR_FIELD_STATUS

Minor field status associated with the record.

VARCHAR2

1

MINOR_SEQUENCE

Minor sequence associated with the record.

VARCHAR2

6

MINOR_TYPE

Minor type associated with the record.

VARCHAR2

31

MINOR_TYPE_CODE

Code identifying minor type.

VARCHAR2

6

SCHOOL

School associated with the record.

VARCHAR2

30

STUDENT_MINOR_FIELD_KEY

Surrogate key identifying the student minor field.

VARCHAR2

16

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE