Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ALUM SIC 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_SIC_CODE

Standard Industrial Code

VARCHAR2

5

MIT_SIC_DESC

Description for Standard Industrial Code

VARCHAR2

150

SIC_SEQUENCE

XXX

NUMBER

22

WAREHOUSE_LOAD_DATE

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

DATE

8