Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	AXBMGID	AXBMGID_ACTIVITY_DATE
CAMPAIGN	Campaign that the constituent has responded to with a gift or pledge payment.	VARCHAR2(5)	AXRMDES	AXRMDES_CAMPAIGN
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DESG_ACTIVITY_DATE	Specifies the date this record was created or updated.	DATE	AXRMDES	AXRMDES_ACTIVITY_DATE
DESIGNATION	Designation associated with the matching pledge.	VARCHAR2(10)	AXRMDES	AXRMDES_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	AXBMGID	AXBMGID_PIDM
GIFT_NUMBER	Number of the gift.	VARCHAR2(0)	NA	NA
MATCH_COMMENT	Comment associated with the pledge.	VARCHAR2(1000)	AXBMGID	AXBMGID_COMMENT
MATCH_EMPLOYER_NAME	Matching employer name.	VARCHAR2(182)	CALCULATION	SPRIDEN_FIRST_NAME||SPRIDEN_MI||SPRIDEN_LAST_NAME
MATCH_EMPLOYER_UID	Internal identification number for employer matching the pledge.	NUMBER	AXBMGID	AXBMGID_EMPR_PIDM
MATCH_FORM_RECD	Indicates whether the match form has been received.	VARCHAR2(1)	AXBMGID	AXBMGID_FORM_RECEIVED_IND
MATCH_FORM_SENT	Indicates whether the match form has been sent.	VARCHAR2(1)	AXBMGID	AXBMGID_MATCH_FORM_IND
MATCH_FORM_SENT_IND	Specifies whether the Matching Gift form is ready to send (Y/N).	VARCHAR2(1)	CALCULATION	NVL(AXBMGID_MGFORM_READYTOSEND)
MATCH_PLEDGE_EXPECTED	Anticipated amount of the matching pledge.	NUMBER	AXBMGID	AXBMGID_TOTAL_EXPECTED_AMT
MATCH_QUALIFY_AMT	Qualifying amount for the matching pledge.	NUMBER	AXBMGID	AXBMGID_QUALIFY_AMT
MATCH_SPOUSE_UID	Internal identification number for the spouse of the person making the pledge to be matched.	NUMBER	AXBMGID	AXBMGID_SPOUSE_PIDM
MATCH_VEHICLE	Vehicle code associated with the matching pledge.	VARCHAR2(5)	AGBPLDG	AGBPLDG_PGVE_CODE
MATCH_VEHICLE_DESC	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	Number of the pledge.	VARCHAR2(7)	AXBMGID	AXBMGID_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: