Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
ENTITY_UID	Entity UID	System generated unique internal identification number assigned to this person or organization.	NUMBER			SPRIDEN	SPRIDEN_PIDM	NO	NO
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)			SPRIDEN	SPRIDEN_ID	NO	NO
ENTITY_IND	Entity Indicator	Indicates whether the entity is a person or an organization.	VARCHAR2(1)			CONSTANT CONSTANT	'O' 'P'	NO NO	NO
LAST_NAME	Last Name	Name of the Organization or last name of the person.	VARCHAR2(63)			SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
FIRST_NAME	First Name	First name of the person.	VARCHAR2(63)			SPRIDEN	SPRIDEN_FIRST_NAME	NO	NO
MIDDLE_NAME	Middle Name	Middle name of the person.	VARCHAR2(63)			SPRIDEN	SPRIDEN_MI	NO	NO
NAME_PREFIX	Name Prefix	Prefix used before a person's name.	VARCHAR2(20)			SPBPERS	SPBPERS_NAME_PREFIX	NO	NO
NAME_SUFFIX	Name Suffix	Suffix for the person's name.	VARCHAR2(20)			SPBPERS	SPBPERS_NAME_SUFFIX	NO	NO
MAILING_NAME	Mailing Name	Name used with the preferred address type for the organization or person's last name.	VARCHAR2(255)			APBCONS SPRIDEN	APBCONS_ADDR_NAME SPRIDEN_LAST_NAME	NO NO	NO
COMBINED_MAILING_NAME	Combined Mailing Name	Combined mailing name for the constituent.	VARCHAR2(255)			APBCONS	APBCONS_CM_NAME	NO	NO
CONTACT_COUNT	Contact Count	Total number of contacts for this organization.	NUMBER			FUNCTION	MAKFUNC.F_COUNT_ORGN_CONTACT	NO	NO
PRIMARY_CONTACT_LAST_NAME	Primary Contact Last Name	Organizational contact's last name.	VARCHAR2(255)			AOBORGN	AOBORGN_LAST_NAME_CONTACT	NO	NO
PRIMARY_CONTACT_FIRST_NAME	Primary Contact First Name	Organizational contact's first name.	VARCHAR2(255)			AOBORGN	AOBORGN_FIRST_NAME_CONTACT	NO	NO
PRIMARY_CONTACT_MIDDLE_INITIAL	Primary Contact Middle Initial	Organizational contact's middle name.	VARCHAR2(255)			AOBORGN	AOBORGN_MI_CONTACT	NO	NO
PRIMARY_CONTACT_NAME_PREFIX	Primary Contact Name Prefix	Prefix for the person's name.	VARCHAR2(255)			AOBORGN	AOBORGN_PREFIX_CONTACT	NO	NO
PRIMARY_CONTACT_NAME_SUFFIX	Primary Contact Name Suffix	Suffix for the person's name.	VARCHAR2(255)			AOBORGN	AOBORGN_SUFFIX_CONTACT	NO	NO
PRIMARY_CONTACT_JOB_TITLE	Primary Contact Job Title	Organizational contact's job title.	VARCHAR2(255)			AOBORGN	AOBORGN_TITLE_CONTACT	NO	NO
BIRTH_DATE	Birth Date	Person's date of birth.	DATE			SPBPERS	SPBPERS_BIRTH_DATE	NO	NO
DECEASED_IND	Deceased Indicator	Indicates whether a person is deceased.	VARCHAR2(1)			SPBPERS	SPBPERS_DEAD_IND	NO	NO
STREET_LINE1	Street Line 1	First line of the entity's address.	VARCHAR2(255)			SPRADDR	SPRADDR_STREET_LINE1	NO	NO
STREET_LINE2	Street Line 2	Second line of the entity's address.	VARCHAR2(255)			SPRADDR	SPRADDR_STREET_LINE2	NO	NO
STREET_LINE3	Street Line 3	Third line of the entity's address.	VARCHAR2(255)			SPRADDR	SPRADDR_STREET_LINE3	NO	NO
STREET_LINE4	Street Line 4	Fourth line of the address.	VARCHAR2(255)			SPRADDR	SPRADDR_STREET_LINE4	NO	NO
CITY	City	Address, city, town or municipality of the entity.	VARCHAR2(63)			SPRADDR	SPRADDR_CITY	NO	NO
COUNTY	County	County for this entity's address.	VARCHAR2(63)			SPRADDR	SPRADDR_CNTY_CODE	NO	NO
COUNTY_DESC	County Description	County address name.	VARCHAR2(255)			STVCNTY	STVCNTY_DESC	NO	NO
STATE_PROVINCE	State Province	State or province associated with the entity's address.	VARCHAR2(63)			SPRADDR	SPRADDR_STAT_CODE	NO	NO
STATE_PROVINCE_DESC	State Province Description	State/province description.	VARCHAR2(255)			STVSTAT	STVSTAT_DESC	NO	NO
POSTAL_CODE	Postal Code	Address postal code of the entity.	VARCHAR2(63)			SPRADDR	SPRADDR_ZIP	NO	NO
NATION	Nation	Nation/country code associated with the entity's address.	VARCHAR2(63)			SPRADDR	SPRADDR_NATN_CODE	NO	NO
NATION_DESC	Nation Description	Address' nation/country description.	VARCHAR2(255)			STVNATN	STVNATN_NATION	NO	NO
DELIVERY_POINT	Delivery Point	Address delivery point.	NUMBER			SPRADDR	SPRADDR_DELIVERY_POINT	NO	NO
CORRECTION_DIGIT	Correction Digit	Address correction digit.	NUMBER			SPRADDR	SPRADDR_CORRECTION_DIGIT	NO	NO
CARRIER_ROUTE	Carrier Route	Address carrier route.	VARCHAR2(4)			SPRADDR	SPRADDR_CARRIER_ROUTE	NO	NO
PHONE_NUMBER_COMBINED	Phone Number Combined	Combined values of the international access, area code, phone number and phone extensions.	VARCHAR2(63)			CALCULATION	SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA||SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT	NO	NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)			NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
PREF_ADDRESS_TYPE	Preferred Address Type	This field indicates the preferred address type associated with the Organization record.	VARCHAR2(63)			AOBORGN	AOBORGN_PREF_ATYP_CODE	NO	NO
PREF_ADDRESS_TYPE_DESC	Preferred Address Type Description	This field identifies the address type associated with the type code.	VARCHAR2(255)			STVATYP	STVATYP_DESC	NO	NO
PREF_ADDRESS_NUMBER	Preferred Address Number	This field indicates the preferred address type sequence number associated with the Organization record.	NUMBER			AOBORGN	AOBORGN_PREF_ATYP_SEQNO	NO	NO

Ver: 9.2