Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ADM GRAD HOME ADDR GEO Table


The geographical region of the applicant's home address.


Field Name

Description

Data Type

Length

ADM_GRAD_HOME_ADDR_GEO_KEY

Graduate Admissions Home Address Geo Key. Use this field to join the ADM GRAD HOME ADDR GEO table to Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL).

VARCHAR2

12

NATION

Nation/Country

VARCHAR2

28

NATION_CODE

Nation/country code.

VARCHAR2

5

US_CITY

City

VARCHAR2

25

US_STATE

US State

VARCHAR2

30

US_STATE_CODE

A standard 2 character US State Code.

VARCHAR2

2

US_ZIP_CODE

US Zip code

VARCHAR2

5

WAREHOUSE_LOAD_DATE

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

DATE

8