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

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 Local Source Local Target
ACTIVE_IND Indicates if the matching gift is active (Y = active, N = inactive). VARCHAR2(1)

AGBMGID

AGBMGID_DELETE_IND

NO

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

AGBMGID

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

CONSTANT

CONSTANT

'O'

'P'

NO

NO

NO
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

NO

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

AGRMDES

AGRMDES_GIFT_NO

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_EMPLOYER_ID Matching gift employer or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

AGRMDES

AGRMDES_EMPR_PIDM

NO

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

AGBMGID

AGBMGID_MG_FORMSENT_IND

NO

NO
MATCH_GIFT_ANTICIPATED Anticipated amount of the matching gift. NUMBER

AGBMGID

AGBMGID_AMT

NO

NO
MATCH_GIFT_BALANCE Balance due for the matching gift. NUMBER

CALCULATION

AGBMGID_AMT - AGBMGID_AMT_PAID

NO

NO
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

NO

NO
MATCH_GIFT_PAID Amount paid toward the matching gift. NUMBER

AGBMGID

AGBMGID_AMT_PAID

NO

NO
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

NO

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

NO

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

NO

NO
MATCH_QUALIFY_AMT Qualifying amount for the matching gift. NUMBER

AGBMGID

AGBMGID_QUALIFY_AMT

NO

NO
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

NO

NO
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

NO

NO
MATCH_SPOUSE_UID Internal identification number for the spouse of the person making the gift to be matched. NUMBER

AGBMGID

AGBMGID_SPOUSE_PIDM

NO

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

AGBMGID

AGBMGID_PGVE_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
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

NO

NO
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

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
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

NO

NO


Ver: 9.2