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

Banner Operational Data Store
Composite View Target: AA_PLEDGE

Description Source composite view contains information on all pledges made by a person or organization including campaign, designations, payment methods, amounts paid and solicitation details.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
CAMPAIGN Campaign that the constituent has responded to with a gift or pledge payment. VARCHAR2(5)

AGRPDES

AGRPMLT

AGRPDES_CAMPAIGN

AGRPMLT_CAMPAIGN

NO

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

AGRPDES

AGRPDES_ACTIVITY_DATE

NO

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

AGRPDES

AGRPMLT

AGRPDES_DESG

AGRPMLT_DESG

NO

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

AGRPDES

AGRPMLT

AGRPDES_PIDM

AGRPMLT_XREF_PIDM

NO

NO

NO
FINANCE_FEED_IND Indicates if the pledge has been fed to the finance system. VARCHAR2(1)

AGBPLDG

AGBPLDG_FEED_IND

NO

NO
FISCAL_YEAR Unique identifier or code for the fiscal year. NUMBER

AGBPLDG

AGBPLDG_FISC_CODE

NO

NO
FISCAL_YEAR_DESC Fiscal year code description. VARCHAR2(30)

ATVFISC

ATVFISC_DESC

NO

NO
MATCHGIFT_FORM_READYTOSEND_IND Indicates if matching gift form is ready to be sent to employer. (Y) = Yes, the MG Form is Ready To Send to the Employer. (N) = No, the MG Form is NOT Ready To Send to the Employer. Null = No, the MG Form is NOT Ready To Send to the Employer. VARCHAR2(1)

CALCULATION

NVL(AGBPLDG_MGFORM_READYTOSEND)

NO

NO
MATCHING_GIFT_FORM_IND Indicates status of matching gift form. VARCHAR2(1)

CALCULATION

NVL(AGBPLDG_MATCH_FORM_IND)

NO

NO
MATCHING_PLEDGE_IND Indicates if one or more expected matching gifts are associated with this pledge. Voided match gifts are excluded. VARCHAR2(1)

FUNCTION

AOKODSF.F_PLEDGE_MATCH

NO

NO
MATCH_GIFT_FORM_PROCESSED_IND Indicates status of matching gift form processed. VARCHAR2(1)

CALCULATION

NVL(AGBPLDG_MATCH_PROCESSED)

NO

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

NA

NA

NO

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

NA

NA

NO

NO
PLEDGE_ACKNOWLEDGED_IND Indicates if a pledge acknowledgement was generated by the system. VARCHAR2(1)

CALCULATION

NVL(AGBPLDG_PACK_IND,'N'),

NO

NO
PLEDGE_ACTIVE_IND Whether a pledge is active or inactive (values = Y or N). VARCHAR2(1)

ATVPSTA

ATVPSTA_ACTIVE_IND

NO

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

AGBPLDG

AGBPLDG_ACTIVITY_DATE

NO

NO
PLEDGE_ADJUSTMENT_IND Indicates if adjustments have been made to the original pledge transaction amount. VARCHAR2(1)       NO
PLEDGE_AMOUNT This field specifies the amount of the pledge designation. This field defaults to the campaign amount. NUMBER

AGRPDES

AGRPDES_AMT

NO

NO
PLEDGE_AMOUNT_PAID Amount paid toward the pledge designation. NUMBER

AGRPDES

AGRPDES_AMT_PAID

NO

NO
PLEDGE_ANONYMOUS_IND Specifies if the pledge is anonymous. VARCHAR2(1)

ATVPCLS

ATVPCLS_ANONYMOUS_IND

NO

NO
PLEDGE_BALANCE This field specifies the pledge balance. NUMBER

CALCULATION

AGRPDES_AMT-AGRPDES_AMT_PAID

NO

NO
PLEDGE_CATEGORY Pledge category assigned to the pledge. VARCHAR2(5)

AGBPLDG

AGBPLDG_PCAT_CODE

NO

NO
PLEDGE_CATEGORY_DESC Description of the pledge category. VARCHAR2(30)

ATVPCAT

ATVPCAT_DESC

NO

NO
PLEDGE_CLASS First classification of the pledge - anonymous, memorial, etc. VARCHAR2(4)

AGBPLDG

AGBPLDG_PCLS_CODE

NO

NO
PLEDGE_CLASS2 Second classification of the pledge - anonymous, memorial, etc. VARCHAR2(4)

AGBPLDG

AGBPLDG_PCLS_CODE_2

NO

NO
PLEDGE_CLASS3 Third classification of the pledge - anonymous, memorial, etc. VARCHAR2(4)

AGBPLDG

AGBPLDG_PCLS_CODE_3

NO

NO
PLEDGE_CLASS_DESC Description of the first pledge classification. VARCHAR2(30)

ATVPCLS

ATVPCLS_DESC

NO

NO
PLEDGE_CLASS_DESC2 Description of the second pledge classification. VARCHAR2(30)

ATVPCLS

ATVPCLS_DESC

NO

NO
PLEDGE_CLASS_DESC3 Description of the third pledge classification. VARCHAR2(30)

ATVPCLS

ATVPCLS_DESC

NO

NO
PLEDGE_COMMENT Comments pertaining to the pledge. VARCHAR2(300)

AGBPLDG

AGBPLDG_COMMENT

NO

NO
PLEDGE_CONDITIONAL_IND Identifies whether the pledge is conditional. VARCHAR2(1)

FUNCTION

DECODE(ATVPCAT_COND_IND)

NO

NO
PLEDGE_CREDIT This is the pledge credit amount. NUMBER

AGRPMLT

CALCULATION

AGRPMLT_CREDIT

AGRPDES_AMT-F_PLEDGE_HARD_CREDIT

NO

NO

NO
PLEDGE_DATE Date of the pledge. DATE

AGBPLDG

AGBPLDG_PLEDGE_DATE

NO

NO
PLEDGE_FULLY_PAID_IND Indicates if the pledge designation amount has been paid in full (values = Y or N). CHAR(1)       NO
PLEDGE_NUMBER System assigned number of the pledge. VARCHAR2(7)

AGRPDES

AGRPMLT

AGRPDES_PLEDGE_NO

AGRPMLT_PLEDGE_NO

NO

NO

NO
PLEDGE_PARTIAL_PAID_IND Indicates if the pledge designation amount has been partially paid (values = Y or N). CHAR(1)

CALCULATION

DECODE(NVL(AGVPLG1_PLEDGE_AMOUNT_PAID, 0), 0, 'N', NVL(AGVPLG1_PLEDGE_AMOUNT,0), 'N','Y')

NO

NO
PLEDGE_RANGE Pledge range classification associated with the total pledge amount. VARCHAR2(2)

AGBPLDG

AGBPLDG_PACK_CODE

NO

NO
PLEDGE_RANGE_DESC Description of the pledge range. VARCHAR2(30)

ATVPACK

ATVPACK_DESC

NO

NO
PLEDGE_REMINDER Pledge reminder methodology associated with the pledge. VARCHAR2(2)

AGBPLDG

AGBPLDG_PRMD_CODE

NO

NO
PLEDGE_REMINDER_COUNT Number of reminders produced by the system todate. NUMBER

AGBPLDG

AGBPLDG_REM_COUNT

NO

NO
PLEDGE_REMINDER_DATE Date of the last reminder. DATE

AGBPLDG

AGBPLDG_REM_DATE

NO

NO
PLEDGE_REMINDER_DESC Description of the pledge reminder. VARCHAR2(30)

ATVPRMD

ATVPRMD_DESC

NO

NO
PLEDGE_STATUS Status of the pledge. VARCHAR2(1)

AGBPLDG

AGBPLDG_PSTA_CODE

NO

NO
PLEDGE_STATUS_DESC Pledge status code description. VARCHAR2(30)

ATVPSTA

ATVPSTA_DESC

NO

NO
PLEDGE_TRANSACTION_AMOUNT Total transaction amount pledged. NUMBER

AGBPLDG

AGBPLDG_AMT_PLEDGED

NO

NO
PLEDGE_TRANS_AMOUNT_PAID Amount paid toward the pledge transaction. NUMBER

CALCULATION

SUM(AGRPDES_AMT_PAID)

NO

NO
PLEDGE_TRANS_BALANCE Balance due for the pledge transaction amount. NUMBER

CALCULATION

AGRPDES_AMT_PAID - SUM(AGRPDES_AMT_PAID)

NO

NO
PLEDGE_TRANS_FULLY_PAID_IND Indicates if the pledge transaction has been paid in full (values = Y or N). VARCHAR2(1)

CALCULATION

CASE WHEN SUM(AGRPDES_AMT_PAID) - AGRPDES_AMT_PAID = 0 THEN 'Y' ELSE 'N'

NO

NO
PLEDGE_TRANS_PARTIAL_PAID_IND Indicates if the pledge transaction has been partially paid (values = Y or N). VARCHAR2(1)

CALCULATION

CASE WHEN SUM(AGRPDES_AMT_PAID) - AGRPDES_AMT_PAID > 0 AND SUM(AGRPDES_AMT_PAID) < AGRPDES_AMT_PAID THEN 'Y' ELSE 'N'

NO

NO
PLEDGE_TYPE Specifies the type of pledge recorded. VARCHAR2(2)

AGBPLDG

AGBPLDG_PLDG_CODE

NO

NO
PLEDGE_TYPE_DESC Pledge type code description. VARCHAR2(30)

ATVPLDG

ATVPLDG_DESC

NO

NO
PLEDGE_VEHICLE Pledge gift vehicle code associated with this pledge. VARCHAR2(5)

AGBPLDG

AGBPLDG_PGVE_CODE

NO

NO
PLEDGE_VEHICLE_DESC Pledge gift vehicle code description. VARCHAR2(30)

ATVPGVE

ATVPGVE_DESC

NO

NO
POST_BATCH_ID Pledge feed document code. VARCHAR2(8)

AGBPLDG

AGBPLDG_FEED_DOC_CODE

NO

NO
POST_DATE Date the pledge was feed to the finance system. DATE

AGBPLDG

AGBPLDG_FEED_DATE

NO

NO
POST_USER User name. VARCHAR2(30)

AGBPLDG

AGBPLDG_USER

NO

NO
RECEIPT_DATE Date the pledge acknowledgement receipt was generated by the system. DATE

AGBPLDG

AGBPLDG_RECEIPT_DATE

NO

NO
RECEIPT_REQUIRED_IND Indicates if a pledge acknowledgement receipt is required for this pledge. VARCHAR2(1)

CALCULATION

NVL(AGBPLDG_RECEIPT_IND,'N'),

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: