Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Advancement Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PLEDGE

Description Contains detail information for all pledge commitments received from or multiple credit promised to donors at the designation level with supplemental information related to associated matching pledges and solicitations.
Key & Frequency One row per entity per pledge number per campaign per designation.
Recommended Search Columns ENTITY_UID, PLEDGE_NUMBER
CAMPAIGN_TYPE
SOLICITOR_UID
ENTITY_UID, PLEDGE_NUMBER, CAMPAIGN, DESIGNATION
FISCAL_YEAR
PLEDGE_DATE
DESIGNATION
DESG_TYPE
DESG_GROUP

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Specifies the date this record was created or updated. DATE

AGRPDES

AGRPDES_ACTIVITY_DATE

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

AGRPDES

AGRPDES_CAMPAIGN

CAMPAIGN_NAME Campaign name. VARCHAR2(255)

AFBCAMP

AFBCAMP_NAME

CAMPAIGN_TYPE Type of campaign recorded. VARCHAR2(63)

AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Campaign type description. VARCHAR2(255)

ATVCMTP

ATVCMTP_DESC

DECEASED_DATE Date the person died. DATE

SPBPERS

SPBPERS_DEAD_DATE

DECEASED_STATUS Indicates whether a person is deceased. VARCHAR2(1)

SPBPERS

SPBPERS_DEAD_IND

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

ADBDESG

ADBDESG_ACCT_CODE

DESG_ACCOUNT_DESC Designation account code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_ACCI_CODE

DESG_ACCOUNT_INDEX_DESC Designation account index code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_ACTV_CODE

DESG_ACTIVITY_DESC Designation activity code description. VARCHAR2(255)

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

ADBDESG

ADBDESG_COAS_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_COLL_CODE

DESG_COLLEGE_DESC College, faculty or school name. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

DESG_DEPARTMENT Department associated with the designation. VARCHAR2(63)

ADBDESG

ADBDESG_DEPT_CODE

DESG_DEPARTMENT_DESC Name of the department. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

DESG_FUND Unique fiscal entity code. VARCHAR2(63)

ADBDESG

ADBDESG_FUND_CODE_PLDG

DESG_FUND_DESC Designation fund code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_GL_NO_CREDIT

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

ADBDESG

ADBDESG_DGRP_CODE

DESG_GROUP_DESC Description of the designation group. VARCHAR2(255)

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

ADBDESG

ADBDESG_LOCN_CODE

DESG_LOCATION_DESC Designation location code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_ORGN_CODE

DESG_ORGANIZATION_DESC Designation organization code description. VARCHAR2(255)

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

ADBDESG

ADBDESG_PROG_CODE

DESG_PROGRAM_DESC Designation program code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_DSTA_CODE

DESG_STATUS_DESC Description of the designation status. VARCHAR2(255)

ATVDSTA

ATVDSTA_DESC

DESG_TYPE Designation type for a specific pledge or gift designation. VARCHAR2(63)

ADBDESG

ADBDESG_DSTP_CODE

DESG_TYPE_DESC Designation type description. VARCHAR2(255)

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

ADBDESG

ADBDESG_CFAE_CODE

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

ATVCFAE

ATVCFAE_DESC

DESIGNATION Designation associated with the pledge. VARCHAR2(63)

AGRPDES

AGRPMLT

AGRPDES_DESG

AGRPMLT_DESG

DESIGNATION_NAME Designation description. VARCHAR2(255)

ADBDESG

ADBDESG_NAME

ENTITY_IND Indicates whether the entity is a person or an organization. VARCHAR2(1)

CONSTANT

CONSTANT

'O'

'P'

ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

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. VARCHAR2(63)

AGBPLDG

AGBPLDG_FISC_CODE

FISCAL_YEAR_DESC Fiscal year code description. VARCHAR2(255)

ATVFISC

ATVFISC_DESC

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

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_COUNT Count of all expected matching gifts associated with this pledge. NUMBER

FUNCTION

MAKFUNC.F_COUNT_MATCH_PLEDGE

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)

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

AGBPLDG

AGBPLDG_PACK_IND

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

ATVPSTA

ATVPSTA_ACTIVE_IND

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

AGBPLDG

AGBPLDG_ADJ_IND

PLEDGE_AMOUNT Amount of the pledge designation. 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 to be anonymous. VARCHAR2(1)

ATVPCLS

ATVPCLS_ANONYMOUS_IND

PLEDGE_BALANCE Balance due for the pledge designation amount. NUMBER

CALCULATION

AGRPDES_AMT-AGRPDES_AMT_PAID

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

AGBPLDG

AGBPLDG_PCAT_CODE

PLEDGE_CATEGORY_DESC Description of the pledge category. VARCHAR2(255)

ATVPCAT

ATVPCAT_DESC

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

AGBPLDG

AGBPLDG_PCLS_CODE

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

AGBPLDG

AGBPLDG_PCLS_CODE_2

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

AGBPLDG

AGBPLDG_PCLS_CODE_3

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

ATVPCLS

ATVPCLS_DESC

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

ATVPCLS

ATVPCLS_DESC

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

ATVPCLS

ATVPCLS_DESC

PLEDGE_COMMENT Comments pertaining to the pledge. VARCHAR2(400)

AGBPLDG

AGBPLDG_COMMENT

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

FUNCTION

DECODE(ATVPCAT_COND_IND)

PLEDGE_CREDIT Amount of the pledge designation to be credited to the primary donor or awarded to a multi-credit recipient donor. NUMBER

AGRPMLT

CALCULATION

AGRPMLT_CREDIT

AGRPDES_AMT-F_PLEDGE_HARD_CREDIT

PLEDGE_DATE Date of the pledge. DATE

AGBPLDG

AGBPLDG_PLEDGE_DATE

PLEDGE_DURATION Duration of the pledge installment plan. VARCHAR2(63)

AGBPINS

AGBPINS_PDUR_CODE

PLEDGE_DURATION_DESC Description of the pledge duration. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

CALCULATION

DECODE(AGRPDES_AMT-AGRPDES_AMT_PAID)

PLEDGE_INSTALLMENT_IND Indicates whether the pledge is paid in installments. VARCHAR2(1)

FUNCTION

MAKFUNC.F_GET_PLEDGE_INSTALL_IND

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

AGRPDES

AGRPDES_PLEDGE_NO

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

CALCULATION

DECODE(AGRPDES_AMT_PAID)

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

AGBPLDG

AGBPLDG_PACK_CODE

PLEDGE_RANGE_DESC Description of the pledge range. VARCHAR2(255)

ATVPACK

ATVPACK_DESC

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

AGBPLDG

AGBPLDG_PRMD_CODE

PLEDGE_REMINDER_COUNT Number of reminders produced by the system todate. NUMBER

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

ATVPRMD

ATVPRMD_DESC

PLEDGE_STATUS Status of the pledge. VARCHAR2(63)

AGBPLDG

AGBPLDG_PSTA_CODE

PLEDGE_STATUS_DESC Pledge status code description. VARCHAR2(255)

ATVPSTA

ATVPSTA_DESC

PLEDGE_TYPE Specifies the type of pledge recorded. VARCHAR2(63)

AGBPLDG

AGBPLDG_PLDG_CODE

PLEDGE_TYPE_DESC Pledge type code description. VARCHAR2(255)

ATVPLDG

ATVPLDG_DESC

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

AGBPLDG

AGBPLDG_PGVE_CODE

PLEDGE_VEHICLE_DESC Pledge gift vehicle code description. VARCHAR2(255)

ATVPGVE

ATVPGVE_DESC

POST_BATCH_ID Pledge feed document code. VARCHAR2(63)

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

AGBPLDG

AGBPLDG_USER

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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)

AGBPLDG

AGBPLDG_RECEIPT_IND

REMINDER_FREQUENCY Frequency of the pledge installment reminders. VARCHAR2(63)

AGBPINS

AGBPINS_FREQ_CODE

REMINDER_FREQUENCY_DESC Description of the reminder frequency. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SOLICITATION_COUNT Count of all solicitations associated with the pledge transaction. NUMBER

FUNCTION

MAKFUNC.F_COUNT_PLEDGE_SOLICITOR

SOLICITATION_TYPE Type of solicitation for the highest solicitation amount associated with this pledge campaign designation amount. VARCHAR2(63)

AGRPSOL

AGRPSOL_SOLC_CODE

SOLICITATION_TYPE_DESC Description of the pledge/gift solicitation type. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SOLICITOR_FIRST_NAME Solicitor's current first name. VARCHAR2(63)

SPRIDEN

SPRIDEN_FIRST_NAME

SOLICITOR_ID Current identification number of the solicitor for the highest solicitation amount associated with this pledge campaign designation amount. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

SOLICITOR_LAST_NAME Solicitor's current last name. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

SOLICITOR_ORG Solicitor organization for the highest solicitation amount associated with this pledge campaign designation amount. VARCHAR2(63)

AGRPSOL

AGRPSOL_SOL_ORG

SOLICITOR_UID System generated unique internal identification number assigned to the solicitor for the highest solicitation amount associated with this pledge campaign designation amount. NUMBER

AGRPSOL

AGRPSOL_SOL_PIDM



Ver: 8.5