| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ADMINISTRATIVE_GROUP
|
Organization-oriented identifier used to determine access authorization to this record. Institution defined.
|
VARCHAR2(108)
|
|
|
|
CARRIER_ROUTE
|
Address carrier route.
|
VARCHAR2(22)
|
|
|
|
CITY
|
Address, city, town or municipality of the entity.
|
VARCHAR2(50)
|
|
|
|
COMBINED_MAILING_NAME
|
Combined mailing name for the constituent.
|
VARCHAR2(42)
|
|
|
|
CONTACT_COUNT
|
Total number of contacts for this organization.
|
VARCHAR2(47)
|
|
|
|
CORRECTION_DIGIT
|
Address correction digit.
|
VARCHAR2(25)
|
|
|
|
COUNTY
|
County for this entity's address.
|
VARCHAR2(33)
|
|
|
|
COUNTY_DESC
|
County address name.
|
VARCHAR2(20)
|
|
|
|
DECEASED_IND
|
Indicates whether a person is deceased.
|
VARCHAR2(39)
|
|
|
|
DELIVERY_POINT
|
Address delivery point.
|
VARCHAR2(23)
|
|
|
|
ENTITY_IND
|
Indicates whether the entity is a person or an organization.
|
VARCHAR2(60)
|
|
|
|
ENTITY_UID
|
System generated unique internal identification number assigned to this person or organization.
|
VARCHAR2(95)
|
|
|
|
FIRST_NAME
|
First name of the person.
|
VARCHAR2(25)
|
|
|
|
ID
|
Person's or Organization's current identification number.
|
VARCHAR2(57)
|
|
|
|
LAST_NAME
|
Name of the Organization or last name of the person.
|
VARCHAR2(52)
|
|
|
|
MAILING_NAME
|
Name used with the preferred address type for the organization or person's last name.
|
VARCHAR2(85)
|
|
|
|
MIDDLE_NAME
|
Middle name of the person.
|
VARCHAR2(26)
|
|
|
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(103)
|
|
|
|
MULTI_SOURCE_DESC
|
Institution description for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(109)
|
|
|
|
NAME_PREFIX
|
Prefix used before a person's name.
|
VARCHAR2(35)
|
|
|
|
NAME_SUFFIX
|
Suffix for the person's name.
|
VARCHAR2(29)
|
|
|
|
NATION
|
Nation/country code associated with the entity's address.
|
VARCHAR2(57)
|
|
|
|
NATION_DESC
|
Address' nation/country description.
|
VARCHAR2(36)
|
|
|
|
PHONE_NUMBER_COMBINED
|
Combined values of the international access, area code, phone number and phone extensions.
|
VARCHAR2(90)
|
|
|
|
POSTAL_CODE
|
Address postal code of the entity.
|
VARCHAR2(34)
|
|
|
|
PRIMARY_CONTACT_FIRST_NAME
|
Organizational contact's first name.
|
VARCHAR2(36)
|
|
|
|
PRIMARY_CONTACT_JOB_TITLE
|
Organizational contact's job title.
|
VARCHAR2(35)
|
|
|
|
PRIMARY_CONTACT_LAST_NAME
|
Organizational contact's last name.
|
VARCHAR2(35)
|
|
|
|
PRIMARY_CONTACT_MIDDLE_INITIAL
|
Organizational contact's middle name.
|
VARCHAR2(37)
|
|
|
|
PRIMARY_CONTACT_NAME_PREFIX
|
Prefix for the person's name.
|
VARCHAR2(29)
|
|
|
|
PRIMARY_CONTACT_NAME_SUFFIX
|
Suffix for the person's name.
|
VARCHAR2(29)
|
|
|
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(118)
|
|
|
|
RELATED_UID
|
System generated, unique, internal identification number assigned to this cross referenced person or organization.
|
VARCHAR2(114)
|
|
|
|
SPOUSE_DECEASED_IND
|
Deceased status of spouse.
|
VARCHAR2(26)
|
|
|
|
SPOUSE_ID
|
Spouse unique identifier.
|
VARCHAR2(25)
|
|
|
|
SPOUSE_NAME
|
Full name of the constituents spouse LFM.
|
VARCHAR2(41)
|
|
|
|
STATE_PROVINCE
|
State or province associated with the entity's address.
|
VARCHAR2(55)
|
|
|
|
STATE_PROVINCE_DESC
|
State/province description.
|
VARCHAR2(27)
|
|
|
|
STREET_LINE1
|
First line of the entity's address.
|
VARCHAR2(35)
|
|
|
|
STREET_LINE2
|
Second line of the entity's address.
|
VARCHAR2(36)
|
|
|
|
STREET_LINE3
|
Third line of the entity's address.
|
VARCHAR2(35)
|
|
|
|
STREET_LINE4
|
Fourth line of the entity's address.
|
VARCHAR2(36)
|
|
|