Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
CAMPAIGN		Campaign associated with the gift from which memo credit is being disbursed.	VARCHAR2(5)		AGRGMMO	AGRGMMO_CAMPAIGN
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DESIGNATION		Designation associated with the gift from which memo credit is being disbursed.	VARCHAR2(10)		AGRGMMO	AGRGMMO_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)		AGRGMMO	AGRGMMO_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		AGRGMMO	AGRGMMO_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 memo credit is being disbursed.	VARCHAR2(7)		AGRGMMO	AGRGMMO_GIFT_NO
GIFT_TYPE		Type of gift or method of payment. For example, 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
MEMO_MATCH_GIFT_IND		Matching gift indicator.	VARCHAR2(1)		FUNCTION	F_MEMO_DETAIL_MATCHING_GIFT
MEMO_UID		Internal identification number for person/organization receiving the memo credit.	NUMBER(8)		AGRGMMO	AGRGMMO_XREF_PIDM
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
PAYMENT_3PP_AMOUNT		Third party amount.	NUMBER(11, 2)		AGRGMMO	AGRGMMO_3PP_AMT
PAYMENT_3PP_PLEDGE_NO		Third party pledge number.	VARCHAR2(7)		AGRGMMO	AGRGMMO_3PP_PLEDGE_NO
PLEDGE_NUMBER		Pledge number associated with the gift from which memo credit is being disbursed.	VARCHAR2(7)		AGRGMMO	AGRGMMO_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: