Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ALUM ADDRESS GEO Table


View exposing geographic attributes associated with alumni addresses including location classifications used for geographic analysis.


Field Name

Description

Data Type

Length

ALUM_ADDRESS_GEO_KEY

Surrogate key identifying the alum address geo.

VARCHAR2

11

DATE_ADDED

Date added as provided by the source.

DATE

DATE_MODIFIED

Date modified as provided by the source.

DATE

GEO_CODE

Code identifying geo.

VARCHAR2

5

GEO_DESCRIPTION

Description of geo.

VARCHAR2

60

GEO_TYPE

Geo type as provided by the source.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE