Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Advancement Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PLEDGE_MATCHING

Description Contains information pertaining to each potential matching gift associated with an eligible donor pledge at the designation level.
Key & Frequency One row per entity per pledge number per match employer UID per campaign per designation.
Recommended Search Columns ENTITY_UID
MATCH_EMPLOYER_UID

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Date that information for this record in the table was entered or last updated. DATE

AXRMDES

AXRMDES_ACTIVITY_DATE

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

NA

NA

CAMPAIGN Identifies the campaign code associated with the matching pledge. VARCHAR2(63)

AXRMDES

AXRMDES_CAMPAIGN

CAMPAIGN_NAME Campaign name. VARCHAR2(255)

AFBCAMP

AFBCAMP_NAME

CAMPAIGN_TYPE Identifies the campaign type for a specific campaign. VARCHAR2(63)

AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Identifies the description of the campaign code. VARCHAR2(255)

ATVCMTP

ATVCMTP_DESC

DESG_COLLEGE Identifies the college code associated with the designation. VARCHAR2(63)

ADBDESG

ADBDESG_COLL_CODE

DESG_COLLEGE_DESC Identifies the description of the college code associated with the designation. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

DESG_DEPARTMENT Department associated with the designation. VARCHAR2(63)

ADBDESG

ADBDESG_DEPT_CODE

DESG_DEPARTMENT_DESC Name of the department. VARCHAR2(255)    
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)

ATVDGRP

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

ATVDSTA

ATVDSTA_DESC

DESG_TYPE Identifies the designation type. VARCHAR2(63)

ADBDESG

ADBDESG_DSTP_CODE

DESG_TYPE_DESC Identifies the description of the designation code. VARCHAR2(255)

ATVDSTP

ATVDSTP_DESC

DESG_VSE Identifies the Voluntary Support of Education code associated with the designation. This code specifies the purpose for which pledges and grants have been made for VASE reporting. VARCHAR2(63)

ADBDESG

ADBDESG_CFAE_CODE

DESG_VSE_DESC Identifies the description of the Voluntary Support of Education code. VARCHAR2(255)

ATVCFAE

ATVCFAE_DESC

DESIGNATION Designation associated with the matching pledge. VARCHAR2(63)

AXRMDES

AXRMDES_DESG

DESIGNATION_NAME Identifies the name of the designation. VARCHAR2(255)

ADBDESG

ADBDESG_NAME

ENTITY_IND Indicates whether the entity is a person or an organization. VARCHAR2(1)

FUNCTION

MAKFUNC.F_GET_ENTITY_IND

ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

AXBMGID

AXBMGID_PIDM

GIFT_NUMBER Number of the gift. VARCHAR2(63)

NA

NA

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MATCH_COMMENT Comment associated with the pledge. VARCHAR2(1000)

AXBMGID

AXBMGID_COMMENT

MATCH_EMPLOYER_ID Matching pledge employer or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MATCH_EMPLOYER_NAME Matching employer name. VARCHAR2(255)

SPRIDEN

SPRIDEN_LAST_NAME

MATCH_EMPLOYER_UID Internal identification number for employer matching the pledge. NUMBER

AXBMGID

AXBMGID_EMPR_PIDM

MATCH_FORM_RECD Indicates whether the match form has been received. VARCHAR2(1)

AXBMGID

AXBMGID_FORM_RECEIVED_IND

MATCH_FORM_SENT Indicates whether the match form has been sent. VARCHAR2(1)

AXBMGID

AXBMGID_MATCH_FORM_IND

MATCH_FORM_SENT_IND Specifies whether the Matching Gift form is ready to send (Y/N). VARCHAR2(1)

CALCULATION

NVL(AXBMGID_MGFORM_READYTOSEND)

MATCH_PLEDGE_EXPECTED Anticipated amount of the matching pledge. NUMBER

AXBMGID

AXBMGID_TOTAL_EXPECTED_AMT

MATCH_QUALIFY_AMT Qualifying amount for the matching pledge. NUMBER

AXBMGID

AXBMGID_QUALIFY_AMT

MATCH_SPOUSE_ID Current identification number for the spouse of the person making the pledge to be matched. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MATCH_SPOUSE_NAME Name (LFMI) of the spouse of the person making the pledge 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 pledge to be matched. NUMBER

AXBMGID

AXBMGID_SPOUSE_PIDM

MATCH_VEHICLE Vehicle code associated with the matching pledge. VARCHAR2(255)

AGBPLDG

AGBPLDG_PGVE_CODE

MATCH_VEHICLE_DESC Description of the pledge matching 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 (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PLEDGE_NUMBER Number of the pledge. VARCHAR2(63)

AXBMGID

AXBMGID_PLEDGE_NO

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

NA

NA



Ver: 8.0