STUDENT MINOR DETAIL Table
This fact table contains all the proposed and completed minors of the students. It also includes the minor start term and expected graduation term.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COUNTER |
Numeric field used to count entries in a table. Can be summed on a report. Example - if this field appeared on a table of Person information, it could be used on reports to show headcounts. |
NUMBER |
1 |
EXPECTED_GRAD_TERM_CODE |
Term when the student is expected to graduate. |
VARCHAR2 |
6 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
MINOR_FIELD_DESC |
XXX |
VARCHAR2 |
60 |
MINOR_SEQ_CODE |
XXX |
VARCHAR2 |
6 |
MINOR_START_TERM_CODE |
Term when the minor field is either proposed or completed. |
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 |
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 |
XXX |
VARCHAR2 |
240 |
STUDENT_MINOR_FIELD_KEY |
Use this field to join together the tables STUDENT_MINOR_DETAIL and STUDENT_MINOR_FIELD. |
VARCHAR2 |
20 |
STUDENT_TERM_ENROLLMENT_KEY |
Use this field to join to the STUDENT TERM ENROLLMENT table |
VARCHAR2 |
15 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |