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

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 Definition Database Data Type Source Name Source Column Local Source Local Target
ACTIVITY_DATE Identifies the date of last change. DATE

AXBMGID

AXBMGID_ACTIVITY_DATE

NO

NO
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 Indicates whether the entity is a person or an organization. VARCHAR2(1)

FUNCTION

MAKFUNC.F_GET_ENTITY_IND

NO

NO
ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

AXBMGID

AXBMGID_PIDM

NO

NO
GIFT_NUMBER Number of the gift. VARCHAR2(63)

NA

NA

NO

NO
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
MATCH_COMMENT Comment associated with the pledge. VARCHAR2(1000)

AXBMGID

AXBMGID_COMMENT

NO

NO
MATCH_EMPLOYER_ID Matching pledge employer or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
MATCH_EMPLOYER_NAME Matching Employer Name. VARCHAR2(255)

CALCULATION

SPRIDEN_FIRST_NAME || SUBSTR(SPRIDEN_MI,1,1) || SPRIDEN_LAST_NAME

NO

NO
MATCH_EMPLOYER_UID Internal identification number for employer matching the pledge. NUMBER

AXBMGID

AXBMGID_EMPR_PIDM

NO

NO
MATCH_FORM_RECD Indicates whether the match form has been received. VARCHAR2(1)

AXBMGID

AXBMGID_FORM_RECEIVED_IND

NO

NO
MATCH_FORM_SENT Indicates whether the match form has been sent. VARCHAR2(1)

AXBMGID

AXBMGID_MATCH_FORM_IND

NO

NO
MATCH_FORM_SENT_IND Specifies whether the Matching Gift form is ready to send (Y/N). VARCHAR2(1)

CALCULATION

NVL(AXBMGID_MGFORM_READYTOSEND)

NO

NO
MATCH_PLEDGE_EXPECTED Anticipated amount of the matching pledge. NUMBER

AXBMGID

AXBMGID_TOTAL_EXPECTED_AMT

NO

NO
MATCH_QUALIFY_AMT Qualifying amount for the matching pledge. NUMBER

AXBMGID

AXBMGID_QUALIFY_AMT

NO

NO
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')

NO

NO
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_SPOUSE_UID Internal identification number for the spouse of the person making the pledge to be matched. NUMBER

AXBMGID

AXBMGID_SPOUSE_PIDM

NO

NO
MATCH_VEHICLE Vehicle code associated with the matching pledge. VARCHAR2(255)

AGBPLDG

AGBPLDG_PGVE_CODE

NO

NO
MATCH_VEHICLE_DESC Description of the vehicle code. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
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 Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

NO
NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
PLEDGE_NUMBER Number of the pledge. VARCHAR2(63)

AXBMGID

AXBMGID_PLEDGE_NO

NO

NO
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO


Ver: 9.2