Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Advancement Reporting View Reports

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 Local Source Local Target
ACTIVITY_DATE Date that information for this record in the table was entered or last updated. DATE

AXRMDES

AXRMDES_ACTIVITY_DATE

NO

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

NA

NA

NO

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

AXRMDES

AXRMDES_CAMPAIGN

NO

NO
CAMPAIGN_NAME Campaign name. VARCHAR2(255)

AFBCAMP

AFBCAMP_NAME

NO

NO
CAMPAIGN_TYPE Type of campaign recorded. VARCHAR2(63)

AFBCAMP

AFBCAMP_CMTP_CODE

NO

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

ATVCMTP

ATVCMTP_DESC

NO

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

ADBDESG

ADBDESG_COLL_CODE

NO

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

STVCOLL

STVCOLL_DESC

NO

NO
DESG_DEPARTMENT Department associated with the designation. VARCHAR2(63)

ADBDESG

ADBDESG_DEPT_CODE

NO

NO
DESG_DEPARTMENT_DESC Name of the department. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

NO

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

ADBDESG

ADBDESG_DGRP_CODE

NO

NO
DESG_GROUP_DESC Description of the designation group. VARCHAR2(255)

ATVDGRP

ATVDGRP_DESC

NO

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

ADBDESG

ADBDESG_DSTA_CODE

NO

NO
DESG_STATUS_DESC Description of the designation status. VARCHAR2(255)

ATVDSTA

ATVDSTA_DESC

NO

NO
DESG_TYPE Identifies the designation type. VARCHAR2(63)

ADBDESG

ADBDESG_DSTP_CODE

NO

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

ATVDSTP

ATVDSTP_DESC

NO

NO
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

NO

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

ATVCFAE

ATVCFAE_DESC

NO

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

AXRMDES

AXRMDES_DESG

NO

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

ADBDESG

ADBDESG_NAME

NO

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

FUNCTION

MAKFUNC.F_GET_ENTITY_IND

NO

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

AXBMGID

AXBMGID_PIDM

NO

NO
GIFT_NUMBER Number of the gift. VARCHAR2(63)

NA

NA

NO

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

NO

NO
MATCH_COMMENT Comment associated with the pledge. VARCHAR2(1000)

AXBMGID

AXBMGID_COMMENT

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
MATCH_EMPLOYER_NAME Matching employer name. VARCHAR2(255)

SPRIDEN

SPRIDEN_LAST_NAME

NO

NO
MATCH_EMPLOYER_UID Internal identification number for employer matching the pledge. NUMBER

AXBMGID

AXBMGID_EMPR_PIDM

NO

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

AXBMGID

AXBMGID_FORM_RECEIVED_IND

NO

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

AXBMGID

AXBMGID_MATCH_FORM_IND

NO

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

CALCULATION

NVL(AXBMGID_MGFORM_READYTOSEND)

NO

NO
MATCH_PLEDGE_EXPECTED Anticipated amount of the matching pledge. NUMBER

AXBMGID

AXBMGID_TOTAL_EXPECTED_AMT

NO

NO
MATCH_QUALIFY_AMT Qualifying amount for the matching pledge. NUMBER

AXBMGID

AXBMGID_QUALIFY_AMT

NO

NO
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

NO

NO
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

NO

NO
MATCH_SPOUSE_UID Internal identification number for the spouse of the person making the pledge to be matched. NUMBER

AXBMGID

AXBMGID_SPOUSE_PIDM

NO

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

AGBPLDG

AGBPLDG_PGVE_CODE

NO

NO
MATCH_VEHICLE_DESC Description of the pledge matching vehicle code. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

NA

NA

NO

NO
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

NO
NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
PLEDGE_NUMBER Number of the pledge. VARCHAR2(63)

AXBMGID

AXBMGID_PLEDGE_NO

NO

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

NA

NA

NO

NO


Ver: 9.2