Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVE_IND	Indicates if the matching gift is active (Y = active, N = inactive).	VARCHAR2(1)	CALCULATION	DECODE(AGBMGID_DELETE_IND,'I','N','Y'),	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
CAMPAIGN	Campaign associated with the gift or pledge payment that was the source of this anticipated matching gift.	VARCHAR2(63)	AGRGDES	AGRGDES_CAMPAIGN	NO	NO
CAMPAIGN_NAME	Campaign name.	VARCHAR2(255)	AFBCAMP	AFBCAMP_NAME	NO	NO
CAMPAIGN_TYPE	Type of campaign recorded.	VARCHAR2(63)	AFBCAMP	AFBCAMP_CMTP_CODE	NO	NO
CAMPAIGN_TYPE_DESC	Campaign type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DESG_COLLEGE	College code associated with the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_COLL_CODE	NO	NO
DESG_COLLEGE_DESC	College, faculty or school name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DESG_DEPARTMENT	Department associated with the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_DEPT_CODE	NO	NO
DESG_DEPARTMENT_DESC	Name of the department.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DESG_GROUP	User defined attribute for associating designations of similar purpose or function.	VARCHAR2(63)	ADBDESG	ADBDESG_DGRP_CODE	NO	NO
DESG_GROUP_DESC	Description of the designation group.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DESG_STATUS	The current status of the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_DSTA_CODE	NO	NO
DESG_STATUS_DESC	Description of the designation status.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DESG_TYPE	Designation type for a specific designation.	VARCHAR2(63)	ADBDESG	ADBDESG_DSTP_CODE	NO	NO
DESG_TYPE_DESC	Designation type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DESG_VSE	Voluntary support of education code associated with the designation. Specifies why gifts or grants have been made for VSE reporting.	VARCHAR2(63)	ADBDESG	ADBDESG_CFAE_CODE	NO	NO
DESG_VSE_DESC	Voluntary support of education code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
DESIGNATION	Designation associated with the gift/payment number that was the source of this anticipated matching gift.	VARCHAR2(63)	AGRGDES	AGRGDES_DESG	NO	NO
DESIGNATION_ACTIVITY_DATE	Date the designation record was entered or last updated in the system.	DATE	AGRMDES	AGRMDES_ACTIVITY_DATE	NO	NO
DESIGNATION_NAME	Designation description.	VARCHAR2(255)	ADBDESG	ADBDESG_NAME	NO	NO
ENTITY_IND	Indicates whether the entity is a person or an organization.	VARCHAR2(1)	CONSTANT CONSTANT	'O' 'P'	NO NO	NO
ENTITY_UID	System generated, unique, internal identification number assigned to the donor whose gift/payment was the source of this anticipated matching gift.	NUMBER	AGRMGIF	AGRMGIF_PIDM	NO	NO
GIFT_NUMBER	Gift/payment number that was the source of this anticipated matching gift.	VARCHAR2(63)	AGRGDES	AGRGDES_GIFT_NO	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
MATCH_DESIGNATION_ANTICIPATED	Anticipated amount for the matching gift designation.	NUMBER	AGRMDES	AGRMDES_AMT	NO	NO
MATCH_EMPLOYER_ID	Matching gift employer or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
MATCH_EMPLOYER_NAME	Name of the matching gift employer or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
MATCH_EMPLOYER_UID	Internal identification number for the matching gift employer or organziation.	NUMBER	AGRMGIF	AGRMGIF_EMPR_PIDM	NO	NO
MATCH_FORM_SENT_IND	Indicates if the match form has been sent.	VARCHAR2(1)	AGBMGID	AGBMGID_MG_FORMSENT_IND	NO	NO
MATCH_GIFT_STATUS	Status of the anticipated matching gift; values are W, I, P or N.	VARCHAR2(63)	CALCULATION	DECODE(AGBMGID_DELETE_IND,NULL, DECODE(AGBMGID_STATUS,NULL,'W','P','P','I','I'),'N'),	NO	NO
MATCH_GIFT_STATUS_DESC	Description of the anticipated matching gift status. W = Waiting, no payments; I = Waiting, partial payment received; P = Paid in full; N = No payment expected.	VARCHAR2(255)	CALCULATION	DECODE(AGBMGID_DELETE_IND,NULL, DECODE(AGBMGID_STATUS,NULL,'WAITING, NO PAYMENT','P','PAID IN FULL','I','WAITING, PARTIAL PAYMENT'),'NO PAYMENT EXPECTED'),	NO	NO
MATCH_SPOUSE_ID	Current identification number for the spouse of the person making the gift to be matched.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
MATCH_SPOUSE_NAME	Name (LFMI) of the spouse of the person making the gift to be matched.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
MATCH_SPOUSE_UID	Internal identification number for the spouse of the person making the gift to be matched.	NUMBER	AGBMGID	AGBMGID_SPOUSE_PIDM	NO	NO
MATCH_VEHICLE	Vehicle code associated with the matching gift.	VARCHAR2(63)	AGBMGID	AGBMGID_PGVE_CODE	NO	NO
MATCH_VEHICLE_DESC	Description of the vehicle code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (LFMI) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PLEDGE_NUMBER	Pledge number associated to the donor payment that was the source of the anticipated matching gift.	VARCHAR2(63)	NA	NA	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO

Ver: 9.2