Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE 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
CAMPAIGN Campaign code associated with the pledge. VARCHAR2(5)

AGRPDES

AGRPMLT

AGRPDES_CAMPAIGN

AGRPMLT_CAMPAIGN

CAMPAIGN_NAME Campaign name. VARCHAR2(30)

AFBCAMP

AFBCAMP_NAME

CAMPAIGN_TYPE Type of campaign recorded. VARCHAR2(2)

AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Campaign type description. VARCHAR2(30)

ATVCMTP

ATVCMTP_DESC

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

NA

SYSDATE

DESG_ACCOUNT User defined value representing an account. Accounts are assets, liability, control, fund balance, revenue, labor, expenditure or transfer. VARCHAR2(6)

ADBDESG

ADBDESG_ACCT_CODE

DESG_ACCOUNT_DESC Designation account code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

DESG_ACCOUNT_INDEX User-defined value representing a summarization of any combination of chart of accounts information. VARCHAR2(6)

ADBDESG

ADBDESG_ACCI_CODE

DESG_ACCOUNT_INDEX_DESC Designation account index code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

DESG_ACTIVITY User-defined code attribute that may be used to identify accounting data by activity. VARCHAR2(6)

ADBDESG

ADBDESG_ACTV_CODE

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

AGRPDES

AGRPDES_ACTIVITY_DATE

DESG_ACTIVITY_DESC Designation activity code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

DESG_CHART_OF_ACCOUNT Primary identification code for any chart of accounts that is used to uniquely identify that chart from any other in a multi-chart environment. VARCHAR2(1)

ADBDESG

ADBDESG_COAS_CODE

DESG_CHART_OF_ACCOUNT_DESC Designation chart of accounts code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

DESG_COLLEGE College code associated with the designation. VARCHAR2(2)

ADBDESG

ADBDESG_COLL_CODE

DESG_COLLEGE_DESC College, faculty or school name. 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_FUND Unique fiscal entity code. VARCHAR2(6)

ADBDESG

ADBDESG_FUND_CODE

DESG_FUND_DESC Designation fund code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

DESG_GENERAL_LEDGER_NUMBER General ledger credit account number associated with the designation. VARCHAR2(60)

ADBDESG

ADBDESG_GL_NO_CREDIT

DESG_GROUP User defined attribute for associated 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_LOCATION Physical location of the institution's financial manager. For example, vice president, finance, suite 10, Adams Hall, main campus. VARCHAR2(6)

ADBDESG

ADBDESG_LOCN_CODE

DESG_LOCATION_DESC Designation location code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

DESG_ORGANIZATION Individual organization code that appears on a transaction. VARCHAR2(6)

ADBDESG

ADBDESG_ORGN_CODE

DESG_ORGANIZATION_DESC Designation organization code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

DESG_PROGRAM User-defined value to the program classification structure code, or a subset of that structure, as defined by the national council of higher education management systems. VARCHAR2(6)

ADBDESG

ADBDESG_PROG_CODE

DESG_PROGRAM_DESC Designation program code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_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 Designation type for a specific pledge or gift designation. VARCHAR2(5)

ADBDESG

ADBDESG_DSTP_CODE

DESG_TYPE_DESC Designation type description. VARCHAR2(30)

ATVDSTP

ATVDSTP_DESC

DESG_VSE Voluntary support of education code associated with the designation. Specifies why gifts or grants have been made for VSE reporting. VARCHAR2(5)

ADBDESG

ADBDESG_CFAE_CODE

DESG_VSE_DESC Voluntary support of education code description. VARCHAR2(30)

ATVCFAE

ATVCFAE_DESC

DESIGNATION Designation associated with the pledge. VARCHAR2(10)

AGRPDES

AGRPMLT

AGRPDES_DESG

AGRPMLT_DESG

DESIGNATION_NAME Designation description. 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)

AGRPDES

AGRPMLT

AGRPDES_PIDM

AGRPMLT_XREF_PIDM

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

AGBPLDG

AGBPLDG_FEED_IND

FISCAL_YEAR Unique identifier or code for the fiscal year. NUMBER(4)

AGBPLDG

AGBPLDG_FISC_CODE

FISCAL_YEAR_DESC Fiscal year code description. VARCHAR2(30)

ATVFISC

ATVFISC_DESC

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)

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

CALCULATION

NVL(AGBPLDG_MATCH_FORM_IND)

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

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

CALCULATION

NVL(AGBPLDG_MATCH_PROCESSED)

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

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

NA

NA

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

CALCULATION

NVL(AGBPLDG_PACK_IND,'N'),

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

ATVPSTA

ATVPSTA_ACTIVE_IND

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

AGBPLDG

AGBPLDG_ACTIVITY_DATE

PLEDGE_ADJUSTMENT_IND Indicates if adjustments have been made to the original pledge transaction amount. VARCHAR2(1)

CALCULATION

NVL(AGBPLDG_ADJ_IND,'N'),

PLEDGE_AMOUNT This field specifies the amount of the pledge designation. This field defaults to the campaign amount. NUMBER

AGRPDES

AGRPDES_AMT

PLEDGE_AMOUNT_PAID Amount paid toward the pledge designation. NUMBER

AGRPDES

AGRPDES_AMT_PAID

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

ATVPCLS

ATVPCLS_ANONYMOUS_IND

PLEDGE_BALANCE This field specifies the pledge balance. NUMBER

CALCULATION

AGRPDES_AMT-AGRPDES_AMT_PAID

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

AGBPLDG

AGBPLDG_PCAT_CODE

PLEDGE_CATEGORY_DESC Description of the pledge category. VARCHAR2(30)

ATVPCAT

ATVPCAT_DESC

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

AGBPLDG

AGBPLDG_PCLS_CODE

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

AGBPLDG

AGBPLDG_PCLS_CODE_2

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

AGBPLDG

AGBPLDG_PCLS_CODE_3

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

ATVPCLS

ATVPCLS_DESC

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

ATVPCLS

ATVPCLS_DESC

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

ATVPCLS

ATVPCLS_DESC

PLEDGE_COMMENT Comments pertaining to the pledge. VARCHAR2(300)

AGBPLDG

AGBPLDG_COMMENT

PLEDGE_CONDITIONAL_IND Indicates if this is a conditional or unconditional pledge (Y = conditional, N = unconditional) VARCHAR2(1)

ATVPCAT

ATVPCAT_COND_IND

PLEDGE_CREDIT This is the pledge credit amount NUMBER

AGRPMLT

CALCULATION

AGRPMLT_CREDIT

AGRPDES_AMT-F_PLEDGE_HARD_CREDIT

PLEDGE_DATE Date of the pledge. DATE

AGBPLDG

AGBPLDG_PLEDGE_DATE

PLEDGE_FULLY_PAID_IND Indicates if the pledge designation amount has been paid in full (values = Y or N). VARCHAR2(1)

CALCULATION

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

PLEDGE_NUMBER System assigned number of the pledge. VARCHAR2(7)

AGRPDES

AGRPMLT

AGRPDES_PLEDGE_NO

AGRPMLT_PLEDGE_NO

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

CALCULATION

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

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

AGBPLDG

AGBPLDG_PACK_CODE

PLEDGE_RANGE_DESC Description of the pledge range. VARCHAR2(30)

ATVPACK

ATVPACK_DESC

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

AGBPLDG

AGBPLDG_PRMD_CODE

PLEDGE_REMINDER_COUNT Number of reminders produced by the system todate. NUMBER(2)

AGBPLDG

AGBPLDG_REM_COUNT

PLEDGE_REMINDER_DATE Date of the last reminder. DATE

AGBPLDG

AGBPLDG_REM_DATE

PLEDGE_REMINDER_DESC Description of the pledge reminder. VARCHAR2(30)

ATVPRMD

ATVPRMD_DESC

PLEDGE_STATUS Status of the pledge. VARCHAR2(1)

AGBPLDG

AGBPLDG_PSTA_CODE

PLEDGE_STATUS_DESC Pledge status code description. VARCHAR2(30)

ATVPSTA

ATVPSTA_DESC

PLEDGE_TRANSACTION_AMOUNT Total transaction amount pledged. NUMBER

AGBPLDG

AGBPLDG_AMT_PLEDGED

PLEDGE_TRANS_AMOUNT_PAID Amount paid toward the pledge transaction. NUMBER

CALCULATION

SUM(AGRPDES_AMT_PAID)

PLEDGE_TRANS_BALANCE Balance due for the pledge transaction amount. NUMBER

CALCULATION

AGRPDES_AMT_PAID - SUM(AGRPDES_AMT_PAID)

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'

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'

PLEDGE_TYPE Code for the pledge type. VARCHAR2(2)

AGBPLDG

AGBPLDG_PLDG_CODE

PLEDGE_TYPE_DESC Pledge type code description. VARCHAR2(30)

ATVPLDG

ATVPLDG_DESC

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

AGBPLDG

AGBPLDG_PGVE_CODE

PLEDGE_VEHICLE_DESC Pledge gift vehicle code description. VARCHAR2(30)

ATVPGVE

ATVPGVE_DESC

POST_BATCH_ID Pledge feed document code. VARCHAR2(8)

AGBPLDG

AGBPLDG_FEED_DOC_CODE

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

AGBPLDG

AGBPLDG_FEED_DATE

POST_USER User name. VARCHAR2(30)

AGBPLDG

AGBPLDG_USER

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

AGBPLDG

AGBPLDG_RECEIPT_DATE

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

CALCULATION

NVL(AGBPLDG_RECEIPT_IND,'N'),

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