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

Ver: 9.0