Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

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

CALCULATION

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

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

AGBMGID

AGBMGID_ACTIVITY_DATE

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

AGRMDES

AGRMDES_CAMPAIGN

CAMPAIGN_NAME Campaign name. VARCHAR2(30)

AFBCAMP

AFBCAMP_NAME

CAMPAIGN_TYPE Type of campaign recorded. VARCHAR2(2)

AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Campaign type description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

SYSDATE

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

ADBDESG

ADBDESG_COLL_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

DESG_DEPARTMENT Department associated with the designation. VARCHAR2(4)

ADBDESG

ADBDESG_DEPT_CODE

DESG_DEPARTMENT_DESC Name of the department. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_DGRP_CODE

DESG_GROUP_DESC Description of the designation group. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_DSTA_CODE

DESG_STATUS_DESC Description of the designation status. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_DSTP_CODE

DESG_TYPE_DESC Designation type description. VARCHAR2(30)

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

ADBDESG

ADBDESG_CFAE_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

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

ADBDESG

ADBDESG_NAME

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

NA

NA

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

AGRMDES

AGRMDES_EMPL_PIDM

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

AGRMDES

AGRMDES_GIFT_NO

MATCH_DESIGNATION_ANTICIPATED Anticipated amount for the matching gift designation. NUMBER(11, 2)

AGRMDES

AGRMDES_AMT

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

AGRMDES

AGRMDES_EMPR_PIDM

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

CALCULATION

NVL(AGBMGID_MG_FORMSENT_IND,'N'),

MATCH_GIFT_ANTICIPATED Anticipated amount of the matching gift. NUMBER(11, 2)

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)

FUNCTION

AOKODSF.F_GIFT_MATCH_PAID

MATCH_GIFT_PAID Amount paid toward the matching gift. NUMBER(11, 2)

AGBMGID

AGBMGID_AMT_PAID

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

FUNCTION

AOKODSF.F_GIFT_MATCH_PAID

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

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

MATCH_QUALIFY_AMT Qualifying amount for the matching gift. NUMBER(11, 2)

AGBMGID

AGBMGID_QUALIFY_AMT

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

AGBMGID

AGBMGID_SPOUSE_PIDM

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

AGBMGID

AGBMGID_PGVE_CODE

MATCH_VEHICLE_DESC Description of the vehicle code. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA



Ver: 8.0