| Data element |
Definition |
EMPLID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Unique identifier for individual (non-org) records. |
ADDRESS_TYPE
Indexed - Yes
Format - VARCHAR2
Nullable - N | Type of address (home, business, preferred mailing…) |
EFFDT
Indexed - Yes
Format - DATE
Nullable - N | Effective date of the table row. Tells you which data is most "up to date", and which rows have been changed. By definition, tables with an "MV" suffix only show the "most effective dated row", i.e. the current valid row. |
EFF_STATUS
Indexed - No
Format - VARCHAR2
Nullable - N | Effective status of data row ("A" = active, "I" = inactive). |
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 - Yes
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 - No
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 |
ADDRESS1_AC
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
ADDRESS2_AC
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
ADDRESS3_AC
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
CITY_AC
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
REG_REGION
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
LOC_ADDR
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
LOC_ADDR_DATA
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
LOC_ADDR_LINE
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
LOC_ADDR_TYPE
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
EXT_ORG_ID
Indexed - No
Format - VARCHAR2
Nullable - N |
Unique identifier for org (non-individual) records |
ORG_LOCATION
Indexed - No
Format - NUMBER
Nullable - N | Not populated |
DESCR_EXT_ORG
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
DESCR_ORG_LOCATION
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
MAINT_ADDR_MANUAL
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
MAINT_OTHER_MANUAL
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
ORG_CONTACT
Indexed - No
Format - NUMBER
Nullable - N | Not populated |
CONTACT_NAME
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
DATA_SOURCE
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
SEASONAL_ADDR
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
