| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Domain Value | 
Source Name | 
Source Column | 
| 
ACTIVITY_DATE
 | 
Activity Date 
 | 
Identifies the date of last change.
 | 
DATE
 | 
 
 | 
 AXBMGID
 
 | 
 AXBMGID_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
 
 | 
| 
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)
 | 
 
 | 
 CALCULATION
 
 | 
 SPRIDEN_FIRST_NAME || SUBSTR(SPRIDEN_MI,1,1) || 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 Received 
 | 
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
 
 | 
 NVL(AXBMGID_MGFORM_READYTOSEND,'N')
 
 | 
| 
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 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
 
 |