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	Identifies the campaign code associated with the matching pledge.	VARCHAR2(5)	AXRMDES	AXRMDES_CAMPAIGN
CAMPAIGN_NAME	Campaign name.	VARCHAR2(30)	AFBCAMP	AFBCAMP_NAME
CAMPAIGN_TYPE	Identifies the campaign type for a specific campaign.	VARCHAR2(2)	AFBCAMP	AFBCAMP_CMTP_CODE
CAMPAIGN_TYPE_DESC	Identifies the description of the campaign code.	VARCHAR2(30)	ATVCMTP	ATVCMTP_DESC
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
DESG_COLLEGE	Identifies the college code associated with the designation.	VARCHAR2(2)	ADBDESG	ADBDESG_COLL_CODE
DESG_COLLEGE_DESC	Identifies the description of the college code associated with the designation.	VARCHAR2(30)	STVCOLL	STVCOLL_DESC
DESG_DEPARTMENT	Department associated with the designation.	VARCHAR2(4)	ADBDESG	ADBDESG_DEPT_CODE
DESG_DEPARTMENT_DESC	Name of the department.	VARCHAR2(30)	STVDEPT	STVDEPT_DESC
DESG_GROUP	User defined attribute for associating designations of similar purpose or function.	VARCHAR2(5)	ADBDESG	ADBDESG_DGRP_CODE
DESG_GROUP_DESC	Description of the designation group.	VARCHAR2(30)	ATVDGRP	ATVDGRP_DESC
DESG_STATUS	The current status of the designation.	VARCHAR2(1)	ADBDESG	ADBDESG_DSTA_CODE
DESG_STATUS_DESC	Description of the designation status.	VARCHAR2(30)	ATVDSTA	ATVDSTA_DESC
DESG_TYPE	Identifies the designation type.	VARCHAR2(5)	ADBDESG	ADBDESG_DSTP_CODE
DESG_TYPE_DESC	Identifies the description of the designation code.	VARCHAR2(30)	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(5)	ADBDESG	ADBDESG_CFAE_CODE
DESG_VSE_DESC	Identifies the description of the Voluntary Support of Education code.	VARCHAR2(30)	ATVCFAE	ATVCFAE_DESC
DESIGNATION	Designation associated with the matching pledge.	VARCHAR2(10)	AXRMDES	AXRMDES_DESG
DESIGNATION_NAME	Identifies the name of the designation.	VARCHAR2(60)	ADBDESG	ADBDESG_NAME
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(8)	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(8)	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(11, 2)	AXBMGID	AXBMGID_TOTAL_EXPECTED_AMT
MATCH_QUALIFY_AMT	Qualifying amount for the matching pledge.	NUMBER(11, 2)	AXBMGID	AXBMGID_QUALIFY_AMT
MATCH_SPOUSE_UID	Internal identification number for the spouse of the person making the pledge to be matched.	NUMBER(8)	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: 8.1