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

Description Contains designation level detail for each anticipated and received matching gift associated with a donor gift or pledge payment. Identifies the initial donor, gift number, campaign and designation along with the matching entity, gift number, campaign and designation and gift status.
Key & Frequency One row per entity per gift number per campaign per designation per match employer UID.
Recommended Search Columns CAMPAIGN_TYPE
ENTITY_UID, GIFT_NUMBER
MATCH_EMPLOYER_UID, GIFT_NUMBER
DESIGNATION
DESG_TYPE
DESG_GROUP

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)

CALCULATION

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

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

NA

NA

CAMPAIGN Campaign associated with the gift or pledge payment that was the source of this anticipated matching gift. VARCHAR2(63)

AGRGDES

AGRGDES_CAMPAIGN

CAMPAIGN_NAME Campaign name. VARCHAR2(255)

AFBCAMP

AFBCAMP_NAME

CAMPAIGN_TYPE Type of campaign recorded. VARCHAR2(63)

AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Campaign type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DESG_COLLEGE College code associated with the designation. VARCHAR2(63)

ADBDESG

ADBDESG_COLL_CODE

DESG_COLLEGE_DESC College, faculty or school name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DESG_DEPARTMENT Department associated with the designation. VARCHAR2(63)

ADBDESG

ADBDESG_DEPT_CODE

DESG_DEPARTMENT_DESC Name of the department. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DESG_GROUP User defined attribute for associating designations of similar purpose or function. VARCHAR2(63)

ADBDESG

ADBDESG_DGRP_CODE

DESG_GROUP_DESC Description of the designation group. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DESG_STATUS The current status of the designation. VARCHAR2(63)

ADBDESG

ADBDESG_DSTA_CODE

DESG_STATUS_DESC Description of the designation status. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DESG_TYPE Designation type for a specific designation. VARCHAR2(63)

ADBDESG

ADBDESG_DSTP_CODE

DESG_TYPE_DESC Designation type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DESG_VSE Voluntary support of education code associated with the designation. Specifies why gifts or grants have been made for VSE reporting. VARCHAR2(63)

ADBDESG

ADBDESG_CFAE_CODE

DESG_VSE_DESC Voluntary support of education code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DESIGNATION Designation associated with the gift/payment number that was the source of this anticipated matching gift. VARCHAR2(63)

AGRGDES

AGRGDES_DESG

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

AGRMDES

AGRMDES_ACTIVITY_DATE

DESIGNATION_NAME Designation description. VARCHAR2(255)

ADBDESG

ADBDESG_NAME

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

AGRMGIF

AGRMGIF_PIDM

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

AGRGDES

AGRGDES_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_DESIGNATION_ANTICIPATED Anticipated amount for the matching gift designation. NUMBER

AGRMDES

AGRMDES_AMT

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

AGRMGIF

AGRMGIF_EMPR_PIDM

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

AGBMGID

AGBMGID_MG_FORMSENT_IND

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_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 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 (LFMI) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PLEDGE_NUMBER Pledge number associated to the donor payment that was the source of the anticipated matching gift. VARCHAR2(63)

NA

NA

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