Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ALUM ADDRESS TYPE Table


View exposing reference values describing types of addresses associated with alumni constituents.


Field Name

Description

Data Type

Length

ADDRESS_STATUS

Address status as provided by the source.

VARCHAR2

40

ADDRESS_TYPE

Address type as provided by the source.

VARCHAR2

40

ALUM_ADDRESS_TYPE_KEY

Surrogate key identifying the alum address type.

VARCHAR2

3

IS_PREFERRED_ADDRESS

Indicator identifying whether preferred address (Y/N).

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE