Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
CAMPAIGN	Campaign that the constituent has responded to with a gift or pledge payment.	VARCHAR2(5)	AGRGMMO	AGRGMMO_CAMPAIGN	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DESIGNATION	Designation associated with the gift from which memo credit is being disbursed.	VARCHAR2(10)	AGRGMMO	AGRGMMO_DESG	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	AGRGMMO	AGRGMMO_PIDM	NO	NO
FISCAL_YEAR	Unique identifier or code for the fiscal year.	NUMBER	AGBGIFT	AGBGIFT_FISC_CODE	NO	NO
FISCAL_YEAR_DESC	Fiscal year code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
GIFT_AMOUNT	Gift designation amount.	NUMBER	AGRGDES	AGRGDES_AMT	NO	NO
GIFT_CLASS	Category of the gift - anonymous, memorial, etc.	VARCHAR2(4)	AGBGIFT	AGBGIFT_GCLS_CODE	NO	NO
GIFT_CLASS_DESC	Gift class code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
GIFT_DATE	Date a gift is received. Date defaults to the system date if no date is entered.	DATE	AGBGIFT	AGBGIFT_GIFT_DATE	NO	NO
GIFT_NUMBER	Gift number from which memo credit is being disbursed.	VARCHAR2(7)	AGRGMMO	AGRGMMO_GIFT_NO	NO	NO
GIFT_TYPE	Gift vehicle for example in honor of, In memory of, anonymous.	VARCHAR2(2)	AGBGIFT	AGBGIFT_GIFT_CODE	NO	NO
GIFT_TYPE_DESC	Gift type code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
GIFT_VEHICLE	Pledge gift vehicle code associated with this gift.	VARCHAR2(5)	AGBGIFT	AGBGIFT_PGVE_CODE	NO	NO
GIFT_VEHICLE_DESC	Pledge gift vehicle code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MEMO_MATCH_GIFT_IND	Matching gift indicator.	VARCHAR2(1)	FUNCTION	F_MEMO_DETAIL_MATCHING_GIFT	NO	NO
MEMO_UID	Internal identification number for person/organization receiving the memo credit.	NUMBER	AGRGMMO	AGRGMMO_XREF_PIDM	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
PAYMENT_3PP_AMOUNT	Third party amount.	NUMBER	AGRGMMO	AGRGMMO_3PP_AMT	NO	NO
PAYMENT_3PP_PLEDGE_NO	Third party pledge number.	VARCHAR2(7)	AGRGMMO	AGRGMMO_3PP_PLEDGE_NO	NO	NO
PLEDGE_NUMBER	Pledge number associated with the gift from which memo credit is being disbursed.	VARCHAR2(7)	AGRGMMO	AGRGMMO_PLEDGE_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: