| Data element |
Definition |
EXT_ORG_ID
Indexed - Yes
Format - VARCHAR2
Nullable - N |
Unique identifier for org (non-individual) records |
ORG_CONTACT
Indexed - No
Format - NUMBER
Nullable - N |
One-up number / counter of organization contacts. |
EMPLID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Unique identifier for individual (non-org) records. |
CONTACT_NAME
Indexed - No
Format - VARCHAR2
Nullable - N | Name of individual
who is the contact at the organization. |
JOBTITLE
Indexed - No
Format - VARCHAR2
Nullable - N | Title of contact. |
ORG_LOCATION
Indexed - No
Format - NUMBER
Nullable - N |
Number of the org location record of where the contact is located. |
ORG_DEPARTMENT
Indexed - No
Format - NUMBER
Nullable - N | Number of the
org department record of where the contact is located. |
EMAILID
Indexed - No
Format - VARCHAR2
Nullable - N | email address
of contact |
ORG_CONTACT_TYPE
Indexed - Yes
Format - VARCHAR2
Nullable - N |
Type of conctact, e.g. matching gift contact, primary contact,
etc. |
URL_ADDRESS
Indexed - No
Format - VARCHAR2
Nullable - N | URL_ADDRESS |
CHG_OTHER
Indexed - No
Format - VARCHAR2
Nullable - N |
Yes/no field |
