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 entity.	NUMBER			AGRPASC	AGRPASC_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)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NAME	Name	Name of the person (LFMI) or organization.	VARCHAR2(255)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ENTITY_IND	Entity Indicator	Indicates whether entity is a person or an organization.	VARCHAR2(1)			FUNCTION	MAKFUNC.F_GET_ENTITY_IND	NO	NO
PLEDGE_NUMBER	Pledge Number	Pledge number to which the entity is associated.	VARCHAR2(63)			AGRPASC	AGRPASC_PLEDGE_NO	NO	NO
ASSOCIATED_ENTITY_UID	Associated Entity UID	System generated unique internal identification number assigned to this person or organization entity.	NUMBER			AGRPASC	AGRPASC_ASSC_PIDM	NO	NO
ASSOCIATED_ID	Associated ID	Associated person's or organization's current identification number.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASSOCIATED_ENTITY_IND	Associated Entity Indicator	Indicates whether associated entity is a person or an organization.	VARCHAR2(1)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASSOCIATED_LAST_NAME	Associated Last Name	Indicates the last name of the associated entity.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASSOCIATED_FIRST_NAME	Associated First Name	Indicates the first name of the associated entity.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASSOCIATED_MIDDLE_NAME	Associated Middle Name	Indicates the middle name of the associated entity.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASSOCIATED_NAME_PREFIX	Associated Name Prefix	Indicates the prefix of the associated entity.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASSOCIATED_NAME_SUFFIX	Associated Name Suffix	Indicates the suffix of the associated entity.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ASSOCIATION	Association	The type of pledge association related to this entity.	VARCHAR2(63)			AGRPASC	AGRPASC_ASSC_CODE	NO	NO
ASSOCIATION_DESC	Association Description	Pledge association description.	VARCHAR2(255)			ATVASSC	ATVASSC_DESC	NO	NO
ASSOCIATION_DATE	Association Date	Date the gift was associated to this entity.	DATE			AGRPASC	AGRPASC_ASSC_DATE	NO	NO
ASSOCIATED_ADDRESS_TYPE	Associated Address Type	The Address Type Code associated with this association.	VARCHAR2(63)			AGRPASC	AGRPASC_ATYP_CODE	NO	NO
ASSOCIATED_ADDRESS_TYPE_DESC	Associated Address Type Description	Address type description.	VARCHAR2(255)			STVATYP	STVATYP_DESC	NO	NO
ASSOCIATION_COMMENT	Association Comment	Comments related to the pledge association.	VARCHAR2(255)			AGRPASC	AGRPASC_COMMENT	NO	NO
ASSOCIATED_STREET_LINE1	Associated Street Line 1	First line of the associated entity's address.	VARCHAR2(255)			SPRADDR	SPRADDR_STREET_LINE1	NO	NO
ASSOCIATED_STREET_LINE2	Associated Street Line 2	Second line of the associated entity's address.	VARCHAR2(255)			SPRADDR	SPRADDR_STREET_LINE2	NO	NO
ASSOCIATED_STREET_LINE3	Associated Street Line 3	Third line of the associated entity's address.	VARCHAR2(255)			SPRADDR	SPRADDR_STREET_LINE3	NO	NO
ASSOCIATED_STREET_LINE4	Associated Street Line 4	Fourth line of the associated entity's address.	VARCHAR2(255)			SPRADDR	SPRADDR_STREET_LINE4	NO	NO
ASSOCIATED_CITY	Associated City	Address, city, town or municipality of the associated entity's address.	VARCHAR2(63)			SPRADDR	SPRADDR_CITY	NO	NO
ASSOCIATED_COUNTY	Associated County	County of the associated entity's address.	VARCHAR2(63)			SPRADDR	SPRADDR_CNTY_CODE	NO	NO
ASSOCIATED_COUNTY_DESC	Associated County Description	County address name.	VARCHAR2(255)			STVCNTY	STVCNTY_DESC	NO	NO
ASSOCIATED_STATE_PROVINCE	Associated State Province	State or province of the associated entity's address.	VARCHAR2(63)			SPRADDR	SPRADDR_STAT_CODE	NO	NO
ASSOCIATED_STATE_PROVINCE_DESC	Associated State Province Description	State/province description.	VARCHAR2(255)			STVSTAT	STVSTAT_DESC	NO	NO
ASSOCIATED_POSTAL_CODE	Associated Postal Code	Address postal code of the associated entity.	VARCHAR2(63)			SPRADDR	SPRADDR_ZIP	NO	NO
ASSOCIATED_NATION	Associated Nation	Nation/country code of the associated entity's address.	VARCHAR2(63)			SPRADDR	SPRADDR_NATN_CODE	NO	NO
ASSOCIATED_NATION_DESC	Associated Nation Description	Address' nation/country description.	VARCHAR2(255)			STVNATN	STVNATN_NATION	NO	NO
ASSOCIATED_DELIVERY_POINT	Associated Delivery Point	Address delivery point of the associated entity's address.	NUMBER			SPRADDR	SPRADDR_DELIVERY_POINT	NO	NO
ASSOCIATED_CORRECTION_DIGIT	Associated Correction Digit	Address correction digit.	NUMBER			SPRADDR	SPRADDR_CORRECTION_DIGIT	NO	NO
ASSOCIATED_CARRIER_ROUTE	Associated Carrier Route	Address carrier route of the associated entity's address.	VARCHAR2(4)			SPRADDR	SPRADDR_CARRIER_ROUTE	NO	NO
USER_ID	User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)			AGRPASC	AGRPASC_USER	NO	NO
ACTIVITY_DATE	Activity Date	Date this record was entered or last updated in the system.	DATE			AGRPASC	AGRPASC_ACTIVITY_DATE	NO	NO
MULTI_SOURCE	Multi Source	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(63)			NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	The institution value of the process-oriented identifier for the record used to determine access authorization to this record.	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

Ver: 9.2