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

AXBMGID

AXBMGID_ACTIVITY_DATE

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

ENTITY_IND Indicates whether the entity is a person or an organization. VARCHAR2(1)

FUNCTION

MAKFUNC.F_GET_ENTITY_IND

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

AXBMGID

AXBMGID_PIDM

GIFT_NUMBER Number of the gift. VARCHAR2(63)

NA

NA

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

MATCH_COMMENT Comment associated with the pledge. VARCHAR2(1000)

AXBMGID

AXBMGID_COMMENT

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MATCH_EMPLOYER_NAME Matching Employer Name. VARCHAR2(255)

CALCULATION

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

MATCH_EMPLOYER_UID Internal identification number for employer matching the pledge. NUMBER

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

AXBMGID

AXBMGID_TOTAL_EXPECTED_AMT

MATCH_QUALIFY_AMT Qualifying amount for the matching pledge. NUMBER

AXBMGID

AXBMGID_QUALIFY_AMT

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

AXBMGID

AXBMGID_SPOUSE_PIDM

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

AGBPLDG

AGBPLDG_PGVE_CODE

MATCH_VEHICLE_DESC Description of the vehicle code. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PLEDGE_NUMBER Number of the pledge. VARCHAR2(63)

AXBMGID

AXBMGID_PLEDGE_NO

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

NA

NA



Ver: 8.5