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