Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
AMOUNT	Amount of the gift or pledge.	NUMBER	AGRGSOL AGRPSOL	AGRGSOL_AMT AGRPSOL_AMT	NO NO	NO
AMOUNT_PLEDGE_PAID	Amount paid toward the pledge.	NUMBER	AGRPSOL	AGRPSOL_AMT_PAID	NO	NO
CAMPAIGN	Campaign that the constituent has responded to with a gift or pledge payment.	VARCHAR2(5)	AGRGSOL AGRPSOL	AGRGSOL_CAMPAIGN AGRPSOL_CAMPAIGN	NO NO	NO
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
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
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_NUMBER	Number of the gift.	VARCHAR2(7)	AGRGSOL	AGRGSOL_GIFT_NO	NO	NO
GIFT_PLEDGE_IND	Indicates whether the solicitation was for a gift or pledge.	VARCHAR2(1)	CONSTANT	SOURCE AGRGSOL THEN 'G'; SOURCE AGRPSOL THEN 'P'	NO	NO
MIF_DESC	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
PLEDGE_NUMBER	System-assigned pledge number.	VARCHAR2(7)	AGRGSOL AGRPSOL	AGRGSOL_PLEDGE_NO AGRPSOL_PLEDGE_NO	NO NO	NO
SOLICITATION_TYPE	Pledge solicitation type code.	VARCHAR2(15)	AGRGSOL AGRPSOL	AGRGSOL_SOLC_CODE AGRPSOL_SOLC_CODE	NO NO	NO
SOLICITATION_TYPE_DESC	Solicitation code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SOLICITOR_ORGANIZATION	Solicitor organization code.	VARCHAR2(5)	AGRGSOL AGRPSOL	AGRGSOL_SOL_ORG AGRPSOL_SOL_ORG	NO NO	NO
SOLICITOR_ORGANIZATION_NAME	Solicitor organization name.	VARCHAR2(30)	ASBSORG	ASBSORG_NAME	NO	NO
SOLICITOR_UID	System generated, unique, internal identification number assigned to the person.	NUMBER	AGRGSOL AGRPSOL	AGRGSOL_SOL_PIDM AGRPSOL_SOL_PIDM	NO NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: