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 |