RETURN TO REPORTING VIEW REPORTS LIST
Advancement Reporting View Reports

SGHE Operational Data Store
Reporting View Target: GIFT_MATCHING

Description Contains designation level detail for each anticipated matching gift associated with an eligible donor gift or pledge payment.
Key & Frequency One row per entity per gift number per campaign per designation per match employer UID.
Recommended Search Columns ENTITY_UID
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

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

NA

NA

CAMPAIGN Campaign code associated with the matching gift. VARCHAR2(63)

AGRMDES

AGRMDES_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 matching gift. VARCHAR2(63)

AGRMDES

AGRMDES_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

'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 Person's or organization's current identification number. 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(94)

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

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

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: 3.1