| Data element |
Definition |
ORG_RELATE_NBR
Indexed - Yes
Format - VARCHAR2
Nullable - N | One-up counter of relationships. For reciprocal relationships, this number will appear in the ORG_RELATE_NBR_RCP field on the related entity. |
EXT_ORG_ID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Unique identifier for org (non-individual) records |
ORG_RELATION
Indexed - Yes
Format - VARCHAR2
Nullable - N | Type of org to org relationship. This is the relationship of the ext_org_id to the EXT_ORG_ID_RELATED. For example, the ext_org_id could be a subsidiary of the EXT_ORG_ID_RELATED. |
EXT_ORG_ID_RELATED
Indexed - Yes
Format - VARCHAR2
Nullable - N | Id of the related org. |
ORG_RELATE_RCP
Indexed - Yes
Format - VARCHAR2
Nullable - N | Reciprocal relationship type. This is the relationship of the EXT_ORG_ID_RELATED to the EXT_ORG_ID. For example, the reciprocal relationship of the Subsidiary type is Parent Company |
ORG_RELATE_NBR_RCP
Indexed - Yes
Format - VARCHAR2
Nullable - N | Reciprocal storage of the one-up counter of relationships. For reciprocal relationships, this number will appear in the ORG_RELATE_NBR field on the related entity. |
DESCR
Indexed - No
Format - VARCHAR2
Nullable - N | Name of the related org. |
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 | 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 |
PHONE_DAY
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
PHONE_EVE
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
PHONE_FAX
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
EMAILID
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
URL_ADDRESS
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. |
