RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE 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
ACTIVITY_DATE Date that information for this record in the table was entered or last updated. DATE

AXBMGID

AXBMGID_ACTIVITY_DATE

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

NA

SYSDATE

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 Matching employer name. VARCHAR2(78)

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_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: 3.1