Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT MINOR DETAIL Table


View exposing student minor detail data.


Field Name

Description

Data Type

Length

COUNTER

Counter associated with the record.

NUMBER

EXPECTED_GRAD_TERM_CODE

Code identifying expected grad term.

VARCHAR2

6

LAST_ACTIVITY_DATE

Date associated with last activity.

DATE

MINOR_FIELD_DESC

Description of minor field.

VARCHAR2

60

MINOR_SEQ_CODE

Code identifying minor seq.

VARCHAR2

6

MINOR_START_TERM_CODE

Code identifying minor start term.

VARCHAR2

6

MINOR_TYPE

Minor type associated with the record.

VARCHAR2

31

MINOR_TYPE_CODE

Code identifying minor type.

VARCHAR2

6

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

REQUIREMENT_COMMENT

Requirement comment associated with the record.

VARCHAR2

240

STUDENT_MINOR_FIELD_KEY

Surrogate key identifying the student minor field.

VARCHAR2

16

STUDENT_TERM_ENROLLMENT_KEY

Surrogate key identifying the student term enrollment.

VARCHAR2

15

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE