Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AA_PLEDGE_MATCHING

Description Source composite view contains details and tracking information on employer matching contributions for each eligible pledge made by a person.

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.    

AXBMGID

AXBMGID_ACTIVITY_DATE

 
CAMPAIGN Identifies the campaign code associated with the matching pledge.    

AXRMDES

AXRMDES_CAMPAIGN

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

NA

SYSDATE

 
DESG_ACTIVITY_DATE Specifies the date this record was created or updated.    

AXRMDES

AXRMDES_ACTIVITY_DATE

 
DESIGNATION Designation associated with the matching pledge.    

AXRMDES

AXRMDES_DESG

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

NA

NA

 
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

 
MATCH_COMMENT Comment associated with the pledge.    

AXBMGID

AXBMGID_COMMENT

 
MATCH_EMPLOYER_NAME Matching employer name.    

CALCULATION

SPRIDEN_FIRST_NAME||SPRIDEN_MI||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_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 Vehicle code.    

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

NA

NA

 
PLEDGE_NUMBER Number of the pledge.    

AXBMGID

AXBMGID_PLEDGE_NO

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

NA

NA

 


Ver: 8.3