Go To View:  RETURN TO COMPOSITE VIEW 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 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

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

AXRMDES

AXRMDES_CAMPAIGN

CAMPAIGN_NAME Campaign name. VARCHAR2(30)

AFBCAMP

AFBCAMP_NAME

CAMPAIGN_TYPE Identifies the campaign type for a specific campaign. VARCHAR2(2)

AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Identifies the description of the campaign code. VARCHAR2(30)

ATVCMTP

ATVCMTP_DESC

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

NA

SYSDATE

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

AXRMDES

AXRMDES_ACTIVITY_DATE

DESG_COLLEGE Identifies the college code associated with the designation. VARCHAR2(2)

ADBDESG

ADBDESG_COLL_CODE

DESG_COLLEGE_DESC Identifies the description of the college code associated with the designation. VARCHAR2(30)

STVCOLL

STVCOLL_DESC

DESG_DEPARTMENT Department associated with the designation. VARCHAR2(4)

ADBDESG

ADBDESG_DEPT_CODE

DESG_DEPARTMENT_DESC Name of the department. VARCHAR2(30)

STVDEPT

STVDEPT_DESC

DESG_GROUP User defined attribute for associating designations of similar purpose or function. VARCHAR2(5)

ADBDESG

ADBDESG_DGRP_CODE

DESG_GROUP_DESC Description of the designation group. VARCHAR2(30)

ATVDGRP

ATVDGRP_DESC

DESG_STATUS The current status of the designation. VARCHAR2(1)

ADBDESG

ADBDESG_DSTA_CODE

DESG_STATUS_DESC Description of the designation status. VARCHAR2(30)

ATVDSTA

ATVDSTA_DESC

DESG_TYPE Identifies the designation type. VARCHAR2(5)

ADBDESG

ADBDESG_DSTP_CODE

DESG_TYPE_DESC Identifies the description of the designation code. VARCHAR2(30)

ATVDSTP

ATVDSTP_DESC

DESG_VSE Identifies the Voluntary Support of Education code associated with the designation. This code specifies the purpose for which pledges and grants have been made for VASE reporting. VARCHAR2(5)

ADBDESG

ADBDESG_CFAE_CODE

DESG_VSE_DESC Identifies the description of the Voluntary Support of Education code. VARCHAR2(30)

ATVCFAE

ATVCFAE_DESC

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

AXRMDES

AXRMDES_DESG

DESIGNATION_NAME Identifies the name of the designation. VARCHAR2(60)

ADBDESG

ADBDESG_NAME

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(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 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: 8.0