Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
CAMPAIGN		Campaign associated with the gift from which multiple credit is being disbursed.	VARCHAR2(5)		AGRGMLT	AGRGMLT_CAMPAIGN
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DESIGNATION		Designation associated with the gift.	VARCHAR2(10)		AGRGMLT	AGRGMLT_DESG
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
ENTITY_UID		System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)		AGRGMLT	AGRGMLT_PIDM
FISCAL_YEAR		Unique identifier or code for the fiscal year.	NUMBER(4)		AGBGIFT	AGBGIFT_FISC_CODE
FISCAL_YEAR_DESC		Fiscal year code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
GIFT_AMOUNT		Gift designation amount.	NUMBER(11, 2)		AGRGDES	AGRGDES_AMT
GIFT_CLASS		Category of the gift - anonymous, memorial, etc.	VARCHAR2(4)		AGBGIFT	AGBGIFT_GCLS_CODE
GIFT_CLASS_DESC		Gift class code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
GIFT_CREDIT		Amount of the gift for this designation being disbursed as memo (soft) credit to the cross-referenced credit recipient identification number.	NUMBER		AGRGMLT	AGRGMLT_CREDIT
GIFT_DATE		Date a gift is received. Date defaults to the system date if no date is entered.	DATE		AGBGIFT	AGBGIFT_GIFT_DATE
GIFT_NUMBER		Gift number from which the multiple credit is being disbursed.	VARCHAR2(7)		AGRGMLT	AGRGMLT_GIFT_NO
GIFT_TYPE		Type of gift or method of payment, i.e., check, credit card, bequest, property.	VARCHAR2(2)		AGBGIFT	AGBGIFT_GIFT_CODE
GIFT_TYPE_DESC		Gift type code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
GIFT_VEHICLE		Pledge gift vehicle code associated with this gift.	VARCHAR2(5)		AGBGIFT	AGBGIFT_PGVE_CODE
GIFT_VEHICLE_DESC		Pledge gift vehicle code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
MIF_DESC		Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
MULTIPLE_MATCH_GIFT_IND		Indicates whether this gift has multiple matching gifts recorded.	VARCHAR2(1)		FUNCTION	F_MEMO_DETAIL_MATCHING_GIFT
MULTIPLE_UID		Internal identification number for person/organization receiving the multiple credit.	NUMBER(8)		AGRGMLT	AGRGMLT_XREF_PIDM
PAYMENT_3PP_AMOUNT		Third party amount.	NUMBER(11, 2)		AGRGMLT	AGRGMLT_3PP_AMT
PAYMENT_3PP_PLEDGE_NO		Third party pledge number.	VARCHAR2(7)		AGRGMLT	AGRGMLT_3PP_PLEDGE_NO
PLEDGE_NUMBER		Pledge number associated with the gift from which the multiple credit is being disbursed.	VARCHAR2(7)		AGRGMLT	AGRGMLT_PLEDGE_NO
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: