Go To View:  RETURN TO BANNER ODS META DATA 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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACTIVITY_DATE Date that information for this record in the table was entered or last updated.    

AXRMDES

AXRMDES_ACTIVITY_DATE

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

NA

NA

 
CAMPAIGN Identifies the campaign code associated with the matching pledge.    

AXRMDES

AXRMDES_CAMPAIGN

 
CAMPAIGN_NAME Campaign name.    

AFBCAMP

AFBCAMP_NAME

 
CAMPAIGN_TYPE Identifies the campaign type for a specific campaign.    

AFBCAMP

AFBCAMP_CMTP_CODE

 
CAMPAIGN_TYPE_DESC Identifies the description of the campaign code.    

ATVCMTP

ATVCMTP_DESC

 
DESG_COLLEGE Identifies the college code associated with the designation.    

ADBDESG

ADBDESG_COLL_CODE

 
DESG_COLLEGE_DESC Identifies the description of the college code associated with the designation.    

STVCOLL

STVCOLL_DESC

 
DESG_DEPARTMENT Department associated with the designation.    

ADBDESG

ADBDESG_DEPT_CODE

 
DESG_DEPARTMENT_DESC Name of the department.    

STVDEPT

STVDEPT_DESC

 
DESG_GROUP User defined attribute for associating designations of similar purpose or function.    

ADBDESG

ADBDESG_DGRP_CODE

 
DESG_GROUP_DESC Description of the designation group.    

ATVDGRP

ATVDGRP_DESC

 
DESG_STATUS The current status of the designation.    

ADBDESG

ADBDESG_DSTA_CODE

 
DESG_STATUS_DESC Description of the designation status.    

ATVDSTA

ATVDSTA_DESC

 
DESG_TYPE Identifies the designation type.    

ADBDESG

ADBDESG_DSTP_CODE

 
DESG_TYPE_DESC Identifies the description of the designation code.    

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.    

ADBDESG

ADBDESG_CFAE_CODE

 
DESG_VSE_DESC Identifies the description of the Voluntary Support of Education code.    

ATVCFAE

ATVCFAE_DESC

 
DESIGNATION Designation associated with the matching pledge.    

AXRMDES

AXRMDES_DESG

 
DESIGNATION_NAME Identifies the name of the designation.    

ADBDESG

ADBDESG_NAME

 
ENTITY_IND Indicates whether the entity is a person or an organization.    

FUNCTION

MAKFUNC.F_GET_ENTITY_IND

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

AXBMGID

AXBMGID_PIDM

 
GIFT_NUMBER Number of the gift.    

NA

NA

 
ID Person's or organization's current identification number.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
MATCH_COMMENT Comment associated with the pledge.    

AXBMGID

AXBMGID_COMMENT

 
MATCH_EMPLOYER_ID Matching pledge employer or organization's current identification number.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
MATCH_EMPLOYER_NAME Matching employer name.    

SPRIDEN

SPRIDEN_LAST_NAME

 
MATCH_EMPLOYER_UID Internal identification number for employer matching the pledge.    

AXBMGID

AXBMGID_EMPR_PIDM

 
MATCH_FORM_RECD Indicates whether the match form has been received.    

AXBMGID

AXBMGID_FORM_RECEIVED_IND

 
MATCH_FORM_SENT Indicates whether the match form has been sent.    

AXBMGID

AXBMGID_MATCH_FORM_IND

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

CALCULATION

NVL(AXBMGID_MGFORM_READYTOSEND)

 
MATCH_PLEDGE_EXPECTED Anticipated amount of the matching pledge.    

AXBMGID

AXBMGID_TOTAL_EXPECTED_AMT

 
MATCH_QUALIFY_AMT Qualifying amount for the matching pledge.    

AXBMGID

AXBMGID_QUALIFY_AMT

 
MATCH_SPOUSE_ID Current identification number for the spouse of the person making the pledge to be matched.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
MATCH_SPOUSE_NAME Name (LFMI) of the spouse of the person making the pledge to be matched    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

AXBMGID

AXBMGID_SPOUSE_PIDM

 
MATCH_VEHICLE Vehicle code associated with the matching pledge.    

AGBPLDG

AGBPLDG_PGVE_CODE

 
MATCH_VEHICLE_DESC Description of the pledge matching vehicle code.    

FUNCTION

GOKODSF.F_GET_DESC

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
PLEDGE_NUMBER Number of the pledge.    

AXBMGID

AXBMGID_PLEDGE_NO

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

NA

NA

 


Ver: 8.3