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.

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

AXBMGID

AXBMGID_ACTIVITY_DATE

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

AXRMDES

AXRMDES_CAMPAIGN

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

NA

SYSDATE

DESG_ACTIVITY_DATE Designation Activity Date Specifies the date this record was created or updated. DATE  

AXRMDES

AXRMDES_ACTIVITY_DATE

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

AXRMDES

AXRMDES_DESG

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

NA

NA

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

AXBMGID

AXBMGID_PIDM

GIFT_NUMBER   Number of the gift. VARCHAR2(0)  

NA

NA

MATCH_COMMENT   Comment associated with the pledge. VARCHAR2(1000)  

AXBMGID

AXBMGID_COMMENT

MATCH_EMPLOYER_NAME Match Employer Name Matching employer name. VARCHAR2(182)  

CALCULATION

SPRIDEN_FIRST_NAME||SPRIDEN_MI||SPRIDEN_LAST_NAME

MATCH_EMPLOYER_UID   Internal identification number for employer matching the pledge. NUMBER(8)  

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 Match Form Sent Indicator 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(11, 2)  

AXBMGID

AXBMGID_TOTAL_EXPECTED_AMT

MATCH_QUALIFY_AMT   Qualifying amount for the matching pledge. NUMBER(11, 2)  

AXBMGID

AXBMGID_QUALIFY_AMT

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

AXBMGID

AXBMGID_SPOUSE_PIDM

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

AGBPLDG

AGBPLDG_PGVE_CODE

MATCH_VEHICLE_DESC   Vehicle code. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

NA

NA

PLEDGE_NUMBER   Number of the pledge. VARCHAR2(7)  

AXBMGID

AXBMGID_PLEDGE_NO

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

NA

NA



Ver: