| Data element |
Definition |
EMPLID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Unique identifier for individual (non-org) records. |
RELATIONSHIP_NBR
Indexed - Yes
Format - NUMBER
Nullable - N | |
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). |
PEOPLE_RELATION
Indexed - Yes
Format - VARCHAR2
Nullable - N | |
GUARDIAN_RELATIONS
Indexed - Yes
Format - VARCHAR2
Nullable - N | |
NAME
Indexed - No
Format - VARCHAR2
Nullable - N | Name field (format ex. Mr. John Smith) |
EMPLID_RELATED
Indexed - Yes
Format - VARCHAR2
Nullable - N | |
RELATION_NBR_RCP
Indexed - No
Format - NUMBER
Nullable - N | |
HIGHEST_EDUC_LVL
Indexed - No
Format - VARCHAR2
Nullable - N | |
GUARDIAN_OCC
Indexed - No
Format - VARCHAR2
Nullable - N | |
EXT_ORG_ID
Indexed - Yes
Format - VARCHAR2
Nullable - N | unique identifier for org (non-individual) records |
EMPLOYER
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
RELATIONS_INCOME
Indexed - No
Format - NUMBER
Nullable - N | |
MAR_STATUS
Indexed - No
Format - VARCHAR2
Nullable - N | One digit marital status code (ex. 'D' = Divorced). |
RESIDENCY_DT
Indexed - No
Format - DATE
Nullable - Y | |
STATE_RESIDENCY
Indexed - No
Format - VARCHAR2
Nullable - N | |
COUNTRY_RESIDENCY
Indexed - No
Format - VARCHAR2
Nullable - N | |
NID_COUNTRY
Indexed - No
Format - VARCHAR2
Nullable - N | |
NATIONAL_ID_TYPE
Indexed - No
Format - VARCHAR2
Nullable - N | |
NATIONAL_ID
Indexed - No
Format - VARCHAR2
Nullable - N | |
CURRENCY_CD
Indexed - No
Format - VARCHAR2
Nullable - N | Country code for currency (most often USD) |
COUNTRY
Indexed - No
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 | |
ADDRESS4
Indexed - No
Format - VARCHAR2
Nullable - N | |
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 - No
Format - VARCHAR2
Nullable - N | |
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 - No
Format - VARCHAR2
Nullable - N | Two digit state code (ex. PA) |
POSTAL
Indexed - No
Format - VARCHAR2
Nullable - N | Zip code (for domestic zips, either 5 or nine digits, not formatted). |
GEO_CODE
Indexed - No
Format - VARCHAR2
Nullable - N | |
IN_CITY_LIMIT
Indexed - No
Format - VARCHAR2
Nullable - N | |
CHG_ADDR
Indexed - No
Format - VARCHAR2
Nullable - N | |
CHG_OTHER
Indexed - No
Format - VARCHAR2
Nullable - N | |
NAME_PREFIX
Indexed - No
Format - VARCHAR2
Nullable - N | |
NAME_SUFFIX
Indexed - No
Format - VARCHAR2
Nullable - N | |
SALUTATION
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
CONTACT_THRU
Indexed - No
Format - NUMBER
Nullable - N | |
PHONE_DAY
Indexed - No
Format - VARCHAR2
Nullable - N | |
PHONE_EVE
Indexed - No
Format - VARCHAR2
Nullable - N | |
PHONE_FAX
Indexed - No
Format - VARCHAR2
Nullable - N | |
EMAILID
Indexed - No
Format - VARCHAR2
Nullable - N | |
URL_ADDRESS
Indexed - No
Format - VARCHAR2
Nullable - N | |
SEX
Indexed - No
Format - VARCHAR2
Nullable - N | |
CITIZEN_COUNTRY
Indexed - No
Format - VARCHAR2
Nullable - N | |
CITIZENSHIP_STATUS
Indexed - No
Format - VARCHAR2
Nullable - N | |
ALL_COMMUNICATIONS
Indexed - No
Format - VARCHAR2
Nullable - N | |
JOINT_RECORD
Indexed - No
Format - VARCHAR2
Nullable - N | |
JOINT_ADDRESS
Indexed - No
Format - VARCHAR2
Nullable - N | |
JOINT_ADDRESS_RCP
Indexed - No
Format - VARCHAR2
Nullable - N | |
ADDR_TYPE3
Indexed - No
Format - VARCHAR2
Nullable - N | |
ADDRESS_TYPE
Indexed - No
Format - VARCHAR2
Nullable - N | Type of address (home, business, preferred mailing…) |
DISSOLVE_REASON
Indexed - No
Format - VARCHAR2
Nullable - N | |
UP_PHONE_DAY
Indexed - No
Format - VARCHAR2
Nullable - N | |
EXTENSION
Indexed - No
Format - VARCHAR2
Nullable - N | |
UP_PHONE_EVE
Indexed - No
Format - VARCHAR2
Nullable - N | |
UP_EXTENSION
Indexed - No
Format - VARCHAR2
Nullable - N | |
UP_FAX
Indexed - No
Format - VARCHAR2
Nullable - N | |
