Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Advancement Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PLEDGE_MATCHING_TRANSACTION

Description Contains information pertaining to each potential matching gift associated with an eligible donor pledge.
Key & Frequency One row per pidm per employer matching pidm per pledge number.
Recommended Search Columns ENTITY_UID
MATCH_EMPLOYER_UID

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



Ver: 9.0