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

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

AXBMGID

AXBMGID_ACTIVITY_DATE

NO

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

AXRMDES

AXRMDES_CAMPAIGN

NO

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

NA

SYSDATE

NO

NO
DESG_ACTIVITY_DATE Specifies the date this record was created or updated. DATE

AXRMDES

AXRMDES_ACTIVITY_DATE

NO

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

AXRMDES

AXRMDES_DESG

NO

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

NA

NA

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(0)

NA

NA

NO

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

AXBMGID

AXBMGID_COMMENT

NO

NO
MATCH_EMPLOYER_NAME Matching employer name. VARCHAR2(182)

CALCULATION

SPRIDEN_FIRST_NAME||SPRIDEN_MI||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_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(5)

AGBPLDG

AGBPLDG_PGVE_CODE

NO

NO
MATCH_VEHICLE_DESC Vehicle code. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

NA

NA

NO

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

NA

NA

NO

NO
PLEDGE_NUMBER Number of the pledge. VARCHAR2(7)

AXBMGID

AXBMGID_PLEDGE_NO

NO

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

NA

NA

NO

NO


Ver: