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	AXRMDES	AXRMDES_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CAMPAIGN	Campaign that the constituent has responded to with a gift or pledge payment.	VARCHAR2(63)	AXRMDES	AXRMDES_CAMPAIGN
CAMPAIGN_NAME	Campaign name.	VARCHAR2(255)	AFBCAMP	AFBCAMP_NAME
CAMPAIGN_TYPE	Type of campaign recorded.	VARCHAR2(63)	AFBCAMP	AFBCAMP_CMTP_CODE
CAMPAIGN_TYPE_DESC	Identifies the description of the campaign code.	VARCHAR2(255)	ATVCMTP	ATVCMTP_DESC
DESG_COLLEGE	Identifies the college code associated with the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_COLL_CODE
DESG_COLLEGE_DESC	Identifies the description of the college code associated with the designation.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
DESG_DEPARTMENT	Department associated with the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_DEPT_CODE
DESG_DEPARTMENT_DESC	Name of the department.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
DESG_GROUP	User defined attribute for associating designations of similar purpose or function.	VARCHAR2(63)	ADBDESG	ADBDESG_DGRP_CODE
DESG_GROUP_DESC	Description of the designation group.	VARCHAR2(255)	ATVDGRP	ATVDGRP_DESC
DESG_STATUS	The current status of the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_DSTA_CODE
DESG_STATUS_DESC	Description of the designation status.	VARCHAR2(255)	ATVDSTA	ATVDSTA_DESC
DESG_TYPE	Identifies the designation type.	VARCHAR2(63)	ADBDESG	ADBDESG_DSTP_CODE
DESG_TYPE_DESC	Identifies the description of the designation code.	VARCHAR2(255)	ATVDSTP	ATVDSTP_DESC
DESG_VSE	Identifies the Voluntary Support of Education code associated with the designation. This code specifies the purpose for which pledges and grants have been made for VASE reporting.	VARCHAR2(63)	ADBDESG	ADBDESG_CFAE_CODE
DESG_VSE_DESC	Identifies the description of the Voluntary Support of Education code.	VARCHAR2(255)	ATVCFAE	ATVCFAE_DESC
DESIGNATION	Designation associated with the matching pledge.	VARCHAR2(63)	AXRMDES	AXRMDES_DESG
DESIGNATION_NAME	Identifies the name of the designation.	VARCHAR2(255)	ADBDESG	ADBDESG_NAME
ENTITY_IND	Indicates whether the entity is a person or an organization.	VARCHAR2(1)	FUNCTION	MAKFUNC.F_GET_ENTITY_IND
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(63)	NA	NA
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
MATCH_COMMENT	Comment associated with the pledge.	VARCHAR2(1000)	AXBMGID	AXBMGID_COMMENT
MATCH_EMPLOYER_ID	Matching pledge employer or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MATCH_EMPLOYER_NAME	Matching employer name.	VARCHAR2(255)	SPRIDEN	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_ID	Current identification number for the spouse of the person making the pledge to be matched.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MATCH_SPOUSE_NAME	Name (LFMI) of the spouse of the person making the pledge to be matched.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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(255)	AGBPLDG	AGBPLDG_PGVE_CODE
MATCH_VEHICLE_DESC	Description of the pledge matching vehicle code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PLEDGE_NUMBER	Number of the pledge.	VARCHAR2(63)	AXBMGID	AXBMGID_PLEDGE_NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA

Ver: 9.1