ADM GRAD REPLY ADDR GEO Table
View exposing graduate applicant reply-address geography reference data including nation, state, ZIP, and city attributes used for graduate admissions reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADM_GRAD_REPLY_ADDR_GEO_KEY |
Surrogate key identifying the adm grad reply addr geo. |
VARCHAR2 |
10 |
NATION |
Nation as provided by the source. |
VARCHAR2 |
28 |
NATION_CODE |
Code identifying nation. |
VARCHAR2 |
3 |
US_CITY |
Us city as provided by the source. |
VARCHAR2 |
25 |
US_STATE |
Us state as provided by the source. |
VARCHAR2 |
30 |
US_STATE_CODE |
Code identifying us state. |
VARCHAR2 |
2 |
US_ZIP_CODE |
Code identifying us zip. |
VARCHAR2 |
5 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |