Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVE_IND		Indicates if the matching gift is active (Y = active, N = inactive).	VARCHAR2(1)		CALCULATION	DECODE(AGBMGID_DELETE_IND,'I','N','Y'),
ACTIVITY_DATE		Date this record was entered or last updated in the system.	DATE		AGBMGID	AGBMGID_ACTIVITY_DATE
CAMPAIGN		Campaign code associated with the matching gift.	VARCHAR2(5)		AGRMDES	AGRMDES_CAMPAIGN
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DESIGNATION		Designation associated with the matching gift.	VARCHAR2(10)		AGRMDES	AGRMDES_DESG
DESIGNATION_ACTIVITY_DATE		Date the designation record was entered or last updated in the system.	DATE		AGRMDES	AGRMDES_ACTIVITY_DATE
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 the donor whose gift/payment was the source of this anticipated matching gift.	NUMBER(8)		AGRMDES	AGRMDES_EMPL_PIDM
GIFT_NUMBER		Number of the gift/payment that was the source of this anticipated matching gift.	VARCHAR2(7)		AGRMDES	AGRMDES_GIFT_NO
MATCH_DESIGNATION_ANTICIPATED		Anticipated amount for the matching gift designation.	NUMBER(11, 2)		AGRMDES	AGRMDES_AMT
MATCH_EMPLOYER_UID		Internal identification number for the matching gift employer or organziation.	NUMBER(8)		AGRMDES	AGRMDES_EMPR_PIDM
MATCH_FORM_SENT_IND		Indicates if the match form has been sent.	VARCHAR2(1)
MATCH_GIFT_ACTIVITY_DATE	Match Gift Activity Date	Date this record was entered or last updated in the system.	DATE		AGRMGIF	AGRMGIF_ACTIVITY_DATE
MATCH_GIFT_AMOUNT	Match Gift Amount	Amount paid toward the matching gift.	NUMBER		AGRMGIF	AGRMGIF_GIFT_AMT
MATCH_GIFT_ANTICIPATED		Anticipated amount of the matching gift.	NUMBER(11, 2)		AGBMGID	AGBMGID_AMT
MATCH_GIFT_BALANCE		Balance due for the matching gift.	NUMBER		CALCULATION	AGBMGID_AMT - AGBMGID_AMT_PAID
MATCH_GIFT_FULLY_PAID_IND		Indicates if the matching gift has been paid in full.	VARCHAR2(1)		FUNCTION	AOKODSF.F_GIFT_MATCH_PAID
MATCH_GIFT_NUMBER	Match Gift Number	Gift/payment number assigned when the matching gift was received.	VARCHAR2(7)		AGRMGIF	AGRMGIF_EMPR_GIFT_NO
MATCH_GIFT_PAID		Amount paid toward the matching gift.	NUMBER(11, 2)		AGBMGID	AGBMGID_AMT_PAID
MATCH_GIFT_PARTIAL_PAID_IND		Indicates if the matching gift has been partially paid.	VARCHAR2(1)		FUNCTION	AOKODSF.F_GIFT_MATCH_PAID
MATCH_GIFT_STATUS		Status of the anticipated matching gift; values are W, I, P or N.	VARCHAR2(1)		CALCULATION	DECODE(AGBMGID_DELETE_IND,NULL, DECODE(AGBMGID_STATUS,NULL,'W','P','P','I','I'),'N'),
MATCH_GIFT_STATUS_DESC		Description of the anticipated matching gift status.	VARCHAR2(30)		CALCULATION	DECODE(AGBMGID_DELETE_IND,NULL, DECODE(AGBMGID_STATUS,NULL,'WAITING, NO PAYMENT','P','PAID IN FULL','I','WAITING, PARTIAL PAYMENT'),'NO PAYMENT EXPECTED'),
MATCH_QUALIFY_AMT		Qualifying amount for the matching gift.	NUMBER(11, 2)		AGBMGID	AGBMGID_QUALIFY_AMT
MATCH_SPOUSE_UID		Internal identification number for the spouse of the person making the gift to be matched.	NUMBER(8)		AGBMGID	AGBMGID_SPOUSE_PIDM
MATCH_VEHICLE		Vehicle code associated with the matching gift.	VARCHAR2(5)		AGBMGID	AGBMGID_PGVE_CODE
MATCH_VEHICLE_DESC		Description of the vehicle code.	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
PLEDGE_NUMBER		This field specifies the number of the pledge.	VARCHAR2(7)		NA	NA
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: