Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER			AXBMGID	AXBMGID_PIDM	NO	NO
MATCH_EMPLOYER_UID	Match Employer UID	Internal identification number for employer matching the pledge.	NUMBER			AXBMGID	AXBMGID_EMPR_PIDM	NO	NO
ID	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
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
MATCH_EMPLOYER_NAME	Match Employer Name	Matching employer name.	VARCHAR2(255)			SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
GIFT_NUMBER	Gift Number	Number of the gift.	VARCHAR2(63)			NA	NA	NO	NO
PLEDGE_NUMBER	Pledge Number	Number of the pledge.	VARCHAR2(63)			AXBMGID	AXBMGID_PLEDGE_NO	NO	NO
MATCH_PLEDGE_EXPECTED	Match Pledge Expected	Anticipated amount of the matching pledge.	NUMBER			AXBMGID	AXBMGID_TOTAL_EXPECTED_AMT	NO	NO
MATCH_COMMENT	Match Comment	Comment associated with the pledge.	VARCHAR2(1000)			AXBMGID	AXBMGID_COMMENT	NO	NO
MATCH_FORM_SENT	Match Form Sent	Indicates whether the match form has been sent.	VARCHAR2(1)			AXBMGID	AXBMGID_MATCH_FORM_IND	NO	NO
MATCH_FORM_RECD	Match Form Recd	Indicates whether the match form has been received.	VARCHAR2(1)			AXBMGID	AXBMGID_FORM_RECEIVED_IND	NO	NO
MATCH_VEHICLE	Match Vehicle	Vehicle code associated with the matching pledge.	VARCHAR2(255)			AGBPLDG	AGBPLDG_PGVE_CODE	NO	NO
MATCH_VEHICLE_DESC	Match Vehicle Description	Description of the pledge matching vehicle code.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
MATCH_QUALIFY_AMT	Match Qualify Amount	Qualifying amount for the matching pledge.	NUMBER			AXBMGID	AXBMGID_QUALIFY_AMT	NO	NO
MATCH_SPOUSE_UID	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
ACTIVITY_DATE	Activity Date	Date that information for this record in the table was entered or last updated.	DATE			AXRMDES	AXRMDES_ACTIVITY_DATE	NO	NO
MULTI_SOURCE	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	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ENTITY_IND	Entity Indicator	Indicates whether the entity is a person or an organization.	VARCHAR2(1)			FUNCTION	MAKFUNC.F_GET_ENTITY_IND	NO	NO
MATCH_EMPLOYER_ID	Match Employer ID	Matching pledge employer or organization's current identification number.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
MATCH_SPOUSE_ID	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	NO	NO
MATCH_SPOUSE_NAME	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	NO	NO
MATCH_FORM_SENT_IND	Match Form Sent Indicator	Specifies whether the Matching Gift form is ready to send (Y/N).	VARCHAR2(1)			CALCULATION	NVL(AXBMGID_MGFORM_READYTOSEND)	NO	NO
CAMPAIGN	Campaign	Campaign that the constituent has responded to with a gift or pledge payment.	VARCHAR2(63)			AXRMDES	AXRMDES_CAMPAIGN	NO	NO
CAMPAIGN_NAME	Campaign Name	Campaign name.	VARCHAR2(255)			AFBCAMP	AFBCAMP_NAME	NO	NO
DESIGNATION	Designation	Designation associated with the matching pledge.	VARCHAR2(63)			AXRMDES	AXRMDES_DESG	NO	NO
DESIGNATION_NAME	Designation Name	Identifies the name of the designation.	VARCHAR2(255)			ADBDESG	ADBDESG_NAME	NO	NO
CAMPAIGN_TYPE	Campaign Type	Type of campaign recorded.	VARCHAR2(63)			AFBCAMP	AFBCAMP_CMTP_CODE	NO	NO
CAMPAIGN_TYPE_DESC	Campaign Type Description	Identifies the description of the campaign code.	VARCHAR2(255)			ATVCMTP	ATVCMTP_DESC	NO	NO
DESG_TYPE	Designation Type	Identifies the designation type.	VARCHAR2(63)			ADBDESG	ADBDESG_DSTP_CODE	NO	NO
DESG_TYPE_DESC	Designation Type Description	Identifies the description of the designation code.	VARCHAR2(255)			ATVDSTP	ATVDSTP_DESC	NO	NO
DESG_GROUP	Designation Group	User defined attribute for associating designations of similar purpose or function.	VARCHAR2(63)			ADBDESG	ADBDESG_DGRP_CODE	NO	NO
DESG_GROUP_DESC	Designation Group Description	Description of the designation group.	VARCHAR2(255)			ATVDGRP	ATVDGRP_DESC	NO	NO
DESG_COLLEGE	Designation College	Identifies the college code associated with the designation.	VARCHAR2(63)			ADBDESG	ADBDESG_COLL_CODE	NO	NO
DESG_COLLEGE_DESC	Designation College Description	Identifies the description of the college code associated with the designation.	VARCHAR2(255)			STVCOLL	STVCOLL_DESC	NO	NO
DESG_DEPARTMENT	Designation Department	Department associated with the designation.	VARCHAR2(63)			ADBDESG	ADBDESG_DEPT_CODE	NO	NO
DESG_DEPARTMENT_DESC	Designation Department Description	Name of the department.	VARCHAR2(255)			STVDEPT	STVDEPT_DESC	NO	NO
DESG_VSE	Designation VSE - Voluntary Support of Education	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	NO	NO
DESG_VSE_DESC	Designation VSE - Voluntary Support of Education Description	Identifies the description of the Voluntary Support of Education code.	VARCHAR2(255)			ATVCFAE	ATVCFAE_DESC	NO	NO
DESG_STATUS	Designation Status	The current status of the designation.	VARCHAR2(63)			ADBDESG	ADBDESG_DSTA_CODE	NO	NO
DESG_STATUS_DESC	Designation Status Description	Description of the designation status.	VARCHAR2(255)			ATVDSTA	ATVDSTA_DESC	NO	NO

Ver: 9.2