Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

Banner Operational Data Store
Composite View Target: AA_GIFT_MATCHING

Description Source composite view contains employer matching gift details for each eligible gift made by a person.

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)

CALCULATION

DECODE(AGBMGID_DELETE_IND,'I','N','Y'),

NO

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

AGBMGID

AGBMGID_ACTIVITY_DATE

NO

NO
CAMPAIGN Campaign that the constituent has responded to with a gift or pledge payment. VARCHAR2(5)

AGRMDES

AGRMDES_CAMPAIGN

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DESIGNATION Designation associated with the matching gift. VARCHAR2(10)

AGRMDES

AGRMDES_DESG

NO

NO
DESIGNATION_ACTIVITY_DATE Date the designation record was entered or last updated in the system. DATE

AGRMDES

AGRMDES_ACTIVITY_DATE

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

AGRMDES

AGRMDES_GIFT_NO

NO

NO
MATCH_DESIGNATION_ANTICIPATED Anticipated amount for the matching gift designation. NUMBER

AGRMDES

AGRMDES_AMT

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)       NO
MATCH_GIFT_ACTIVITY_DATE Date this record was entered or last updated in the system. DATE

AGRMGIF

AGRMGIF_ACTIVITY_DATE

NO

NO
MATCH_GIFT_AMOUNT Amount paid toward the matching gift. NUMBER

AGRMGIF

AGRMGIF_GIFT_AMT

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)

FUNCTION

AOKODSF.F_GIFT_MATCH_PAID

NO

NO
MATCH_GIFT_NUMBER Gift/payment number assigned when the matching gift was received. VARCHAR2(7)

AGRMGIF

AGRMGIF_EMPR_GIFT_NO

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)

FUNCTION

AOKODSF.F_GIFT_MATCH_PAID

NO

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

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. VARCHAR2(30)

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_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(5)

AGBMGID

AGBMGID_PGVE_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
MIF_DESC Institution description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
PLEDGE_NUMBER This field specifies the number of the pledge. VARCHAR2(7)

NA

NA

NO

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

NA

NA

NO

NO


Ver: