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			AGRGSOL AGRPSOL	AGRGSOL_PIDM AGRPSOL_PIDM	NO NO	NO
GIFT_PLEDGE_IND	Gift Pledge Indicator	Indicates whether the solicitation was for a gift or pledge.	VARCHAR2(1)			CONSTANT	SOURCE AGRGSOL THEN 'G'; SOURCE AGRPSOL THEN 'P'	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
GIFT_NUMBER	Gift Number	Number of the gift.	VARCHAR2(63)			AGRGSOL	AGRGSOL_GIFT_NO	NO	NO
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PLEDGE_NUMBER	Pledge Number	System-assigned pledge number.	VARCHAR2(63)			AGRGSOL AGRPSOL	AGRGSOL_PLEDGE_NO AGRPSOL_PLEDGE_NO	NO NO	NO
CAMPAIGN	Campaign	Campaign that the constituent has responded to with a gift or pledge payment.	VARCHAR2(63)			AGRGSOL AGRPSOL	AGRGSOL_CAMPAIGN AGRPSOL_CAMPAIGN	NO NO	NO
CAMPAIGN_NAME	Campaign Name	Campaign name.	VARCHAR2(255)			AFBCAMP	AFBCAMP_NAME	NO	NO
SOLICITATION_TYPE	Solicitation Type	Pledge solicitation type code.	VARCHAR2(63)			AGRGSOL AGRPSOL	AGRGSOL_SOLC_CODE AGRPSOL_SOLC_CODE	NO NO	NO
SOLICITATION_TYPE_DESC	Solicitation Type Description	Solicitation code description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SOLICITOR_ORGANIZATION	Solicitor Organization	Solicitor organization code.	VARCHAR2(63)			AGRGSOL AGRPSOL	AGRGSOL_SOL_ORG AGRPSOL_SOL_ORG	NO NO	NO
SOLICITOR_ORGANIZATION_NAME	Solicitor Organization Name	Solicitor organization name.	VARCHAR2(255)			ASBSORG	ASBSORG_NAME	NO	NO
SOLICITOR_UID	Solicitor UID	System generated, unique, internal identification number assigned to this solicitor.	NUMBER			AGRGSOL AGRPSOL	AGRGSOL_SOL_PIDM AGRPSOL_SOL_PIDM	NO NO	NO
SOLICITOR_ID	Solicitor ID	Solicitor's current identification number.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
AMOUNT	Amount	Amount of the gift or pledge.	NUMBER			AGRGSOL AGRPSOL	AGRGSOL_AMT AGRPSOL_AMT	NO NO	NO
SOLICITOR_NAME	Solicitor Name	Name of the solicitor (last name, first name, middle initial) or organization name.	VARCHAR2(255)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SOLICITOR_LAST_NAME	Solicitor Last Name	Solicitor's last name.	VARCHAR2(255)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
AMOUNT_PLEDGE_PAID	Amount Pledge Paid	Amount paid toward the pledge.	NUMBER			AGRPSOL	AGRPSOL_AMT_PAID	NO	NO
SOLICITOR_FIRST_NAME	Solicitor First Name	Solicitor's first name.	VARCHAR2(255)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
CREDIT_UID	Credit UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER			AGRGSOL AGRPSOL	AGRGSOL_CREDIT_PIDM AGRPSOL_CREDIT_PIDM	NO NO	NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied for this table/column.	VARCHAR2(63)			NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	Institution description 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

Ver: 9.2