ALUM MAJOR Table
This table contains information about the courses of major as used in the Alumni's system.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALUM_MAJOR_KEY |
Use this field to join together the ALUM_MAJOR table with another Alumni fact table that contains this field to get more information about the courses of major of a person. |
VARCHAR2 |
6 |
MAJOR_CODE |
XXX |
VARCHAR2 |
6 |
MAJOR_DESCRIPTION |
XXX |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |