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_TRANSACTION

Description Contains information pertaining to each potential matching gift associated with an eligible donor pledge.
Key & Frequency One row per pidm per employer matching pidm per pledge number.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACTIVITY_DATE Identifies the date of last change.    

AXBMGID

AXBMGID_ACTIVITY_DATE

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

NA

NA

 
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.    

CALCULATION

SPRIDEN_FIRST_NAME || SUBSTR(SPRIDEN_MI,1,1) || 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

NVL(AXBMGID_MGFORM_READYTOSEND,'N')

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