Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ALUM OCCUPATION DETAIL Table


XXX


Field Name

Description

Data Type

Length

ALUM_BIOGRAPHIC_KEY

Use this field to join together the ALUM_BIOGRAPHIC table to another Alumni fact table with this field to get specific information about a person.

VARCHAR2

10

MIT_OCCUPATION_CODE

Occupation Code

VARCHAR2

5

MIT_OCCUPATION_DESC

Description for Occupation Code

VARCHAR2

150

OCCUPATION_SEQUENCE

XXX

NUMBER

22

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8