| Data element |
Definition |
EXT_ORG_ID
Indexed - Yes
Format - VARCHAR2
Nullable - N | unique identifier for org (non-individual) records |
ORG_LOCATION
Indexed - No
Format - NUMBER
Nullable - N | Counter of the organizations locations. Part of the key. |
DESCR
Indexed - No
Format - VARCHAR2
Nullable - N | Description of the location. |
DESCRSHORT
Indexed - No
Format - VARCHAR2
Nullable - N | Short description of the location. |
COUNTRY
Indexed - Yes
Format - VARCHAR2
Nullable - N | Three digit country abbreviation (ex. 'USA') |
ADDRESS1
Indexed - No
Format - VARCHAR2
Nullable - N | Address line 1. In a business address row, this field will often house the business name. |
ADDRESS2
Indexed - No
Format - VARCHAR2
Nullable - N | Address line 2. In a business address row, this field occasionally house the business name. |
ADDRESS3
Indexed - No
Format - VARCHAR2
Nullable - N | Address line 3. |
ADDRESS4
Indexed - No
Format - VARCHAR2
Nullable - N | Address line 4. |
CITY
Indexed - No
Format - VARCHAR2
Nullable - N | City description |
NUM1
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
NUM2
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
HOUSE_TYPE
Indexed - Yes
Format - VARCHAR2
Nullable - N | Not populated |
ADDR_FIELD1
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
ADDR_FIELD2
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
ADDR_FIELD3
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
COUNTY
Indexed - No
Format - VARCHAR2
Nullable - N | County within state; sparsely populated in database |
STATE
Indexed - Yes
Format - VARCHAR2
Nullable - N | Two digit state code (ex. PA) |
POSTAL
Indexed - Yes
Format - VARCHAR2
Nullable - N | Zip code (for domestic zips, either 5 or nine digits, not formatted). |
GEO_CODE
Indexed - Yes
Format - VARCHAR2
Nullable - N | Not populated |
IN_CITY_LIMIT
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
CHG_ADDR
Indexed - No
Format - VARCHAR2
Nullable - N | |
CHG_OTHER
Indexed - No
Format - VARCHAR2
Nullable - N | |
URL_ADDRESS
Indexed - No
Format - VARCHAR2
Nullable - N | URL |
EMAILID
Indexed - No
Format - VARCHAR2
Nullable - N | |
EDI_ADDRESS
Indexed - No
Format - VARCHAR2
Nullable - Y | Not populated |
