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.