| Data element |
Definition |
PE_RELATE_NBR
Indexed - Yes
Format - VARCHAR2
Nullable - N | One-up counter of relationships |
EXT_ORG_ID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Unique identifier for org (non-individual) records |
EMPLID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Unique identifier for individual (non-org) records. |
PE_RELATION
Indexed - Yes
Format - VARCHAR2
Nullable - N | Type of person to external org relationship. |
DESCR
Indexed - No
Format - VARCHAR2
Nullable - N | Name of the organization in the relationship. |
NAME
Indexed - No
Format - VARCHAR2
Nullable - N | Name of the person in the relationship. |
NAME_PREFIX
Indexed - No
Format - VARCHAR2
Nullable - N | Name Prefix |
NAME_SUFFIX
Indexed - No
Format - VARCHAR2
Nullable - N | Name Suffix |
SSN
Indexed - Yes
Format - VARCHAR2
Nullable - N | not used |
SEX
Indexed - No
Format - VARCHAR2
Nullable - N | Gender |
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 | 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 - 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 - 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 | Not populated |
IN_CITY_LIMIT
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
BEGIN_DT
Indexed - No
Format - DATE
Nullable - Y | Start date of relationship. |
END_DT
Indexed - No
Format - DATE
Nullable - Y | End date of relationship. |
SRC_DESCR
Indexed - No
Format - VARCHAR2
Nullable - N | The name of the person or publication that provided information about this relationship |
COMMENTS
Indexed - No
Format - LONG
Nullable - Y | Comments. |
