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

SGHE Banner Operational Data Store
Reporting View Target: GIFT_MATCHING_TRANSACTION

Description Contains information pertaining to each anticipated matching gift associated with an eligible donor gift or pledge payment.
Key & Frequency One row per entity per gift number per match employer UID.
Recommended Search Columns ENTITY_UID, GIFT_NUMBER
MATCH_EMPLOYER_UID, GIFT_NUMBER

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVE_IND Indicates if the matching gift is active (Y = active, N = inactive). VARCHAR2(1)

AGBMGID

AGBMGID_DELETE_IND

ACTIVITY_DATE Date this record was entered or last updated in the system. DATE

AGBMGID

AGBMGID_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)

CONSTANT

CONSTANT

'O'

'P'

ENTITY_UID System generated, unique, internal identification number assigned to the donor whose gift/payment was the source of this anticipated matching gift. NUMBER

AGRMDES

AGRMDES_EMPL_PIDM

GIFT_NUMBER Number of the gift/payment that was the source of this anticipated matching gift. VARCHAR2(63)

AGRMDES

AGRMDES_GIFT_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

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MATCH_EMPLOYER_NAME Name of the matching gift employer or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MATCH_EMPLOYER_UID Internal identification number for the matching gift employer or organziation. NUMBER

AGRMDES

AGRMDES_EMPR_PIDM

MATCH_FORM_SENT_IND Indicates if the match form has been sent. VARCHAR2(1)

AGBMGID

AGBMGID_MG_FORMSENT_IND

MATCH_GIFT_ANTICIPATED Anticipated amount of the matching gift. NUMBER

AGBMGID

AGBMGID_AMT

MATCH_GIFT_BALANCE Balance due for the matching gift. NUMBER

CALCULATION

AGBMGID_AMT - AGBMGID_AMT_PAID

MATCH_GIFT_FULLY_PAID_IND Indicates if the matching gift has been paid in full. VARCHAR2(1)

CALCULATION

IF AGBMGID_AMT_PAID > = AGBMGID_AMT THEN Y, ELSE N

MATCH_GIFT_PAID Amount paid toward the matching gift. NUMBER

AGBMGID

AGBMGID_AMT_PAID

MATCH_GIFT_PARTIAL_PAID_IND Indicates if the matching gift has been partially paid. VARCHAR2(1)

CALCULATION

IF AGBMGID_AMT_PAID IS > 0 AND < AGBMGID_AMT THEN Y, ELSE N

MATCH_GIFT_STATUS Status of the anticipated matching gift; values are W, I, P or N. VARCHAR2(63)

CALCULATION

DECODE(AGBMGID_DELETE_IND,NULL, DECODE(AGBMGID_STATUS,NULL,'W','P','P','I','I'),'N'),

MATCH_GIFT_STATUS_DESC Description of the anticipated matching gift status. W = Waiting, no payments; I = Waiting, partial payment received; P = Paid in full; N = No payment expected. VARCHAR2(255)

CALCULATION

DECODE(AGBMGID_DELETE_IND,NULL, DECODE(AGBMGID_STATUS,NULL,'WAITING, NO PAYMENT','P','PAID IN FULL','I','WAITING, PARTIAL PAYMENT'),'NO PAYMENT EXPECTED'),

MATCH_QUALIFY_AMT Qualifying amount for the matching gift. NUMBER

AGBMGID

AGBMGID_QUALIFY_AMT

MATCH_SPOUSE_ID Current identification number for the spouse of the person making the gift to be matched. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MATCH_SPOUSE_NAME Name (LFMI) of the spouse of the person making the gift 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 gift to be matched. NUMBER

AGBMGID

AGBMGID_SPOUSE_PIDM

MATCH_VEHICLE Vehicle code associated with the matching gift. VARCHAR2(63)

AGBMGID

AGBMGID_PGVE_CODE

MATCH_VEHICLE_DESC Description of the vehicle code. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MULTI_SOURCE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(255)

NA

NA

NAME Name of the person (LFMI) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PROCESS_GROUP The institution value of the process-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(255)

NA

NA



Ver: 8.5