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

Banner Operational Data Store
Reporting View Target: GIFT

Description Contains detail information for all gift/payments received from or multiple credit awarded to donors at the designation level with supplemental information related to donor attributes, associated matching gifts and solicitations.
Key & Frequency One row per entity per gift number per pledge number per campaign per designation.
Recommended Search Columns ENTITY_UID, ENTITY_IND
ENTITY_IND
CAMPAIGN_TYPE
ENTITY_UID, GIFT_NUMBER, PLEDGE_NUMBER, CAMPAIGN, DESIGNATION
GIFT_DATE
FISCAL_YEAR
CAMPAIGN, PLEDGE_NUMBER
ENTITY_UID, PLEDGE_NUMBER
SOLICITOR_UID
DESIGNATION
DESG_TYPE
DESG_GROUP

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

AGRGDES

AGRGDES_ACTIVITY_DATE

NO

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

NA

NA

NO

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

AGRGDES

AGRGMLT

AGRGDES_CAMPAIGN

AGRGMLT_CAMPAIGN

NO

NO

NO
CAMPAIGN_NAME Campaign name. VARCHAR2(255)

AFBCAMP

AFBCAMP_NAME

NO

NO
CAMPAIGN_TYPE Type of campaign recorded. VARCHAR2(63)

AFBCAMP

AFBCAMP_CMTP_CODE

NO

NO
CAMPAIGN_TYPE_DESC Campaign type description. VARCHAR2(255)

ATVCMTP

ATVCMTP_DESC

NO

NO
DECEASED_DATE Date the person died. DATE

SPBPERS

SPBPERS_DEAD_DATE

NO

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

SPBPERS

SPBPERS_DEAD_IND

NO

NO
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

NO

NO
DESG_ACCOUNT_DESC Designation account code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

ADBDESG

ADBDESG_ACCI_CODE

NO

NO
DESG_ACCOUNT_INDEX_DESC Designation account index code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

ADBDESG

ADBDESG_ACTV_CODE

NO

NO
DESG_ACTIVITY_DESC Designation activity code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
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

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

ADBDESG

ADBDESG_COLL_CODE

NO

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

STVCOLL

STVCOLL_DESC

NO

NO
DESG_DEPARTMENT Department associated with the designation. VARCHAR2(63)

ADBDESG

ADBDESG_DEPT_CODE

NO

NO
DESG_DEPARTMENT_DESC Name of the department. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

NO

NO
DESG_FUND Unique fiscal entity code. VARCHAR2(63)

ADBDESG

ADBDESG_FUND_CODE

NO

NO
DESG_FUND_DESC Designation fund code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

ADBDESG

ADBDESG_GL_NO_CREDIT

NO

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

ADBDESG

ADBDESG_DGRP_CODE

NO

NO
DESG_GROUP_DESC Description of the designation group. VARCHAR2(255)

ATVDGRP

ATVDGRP_DESC

NO

NO
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

NO

NO
DESG_LOCATION_DESC Designation location code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

ADBDESG

ADBDESG_ORGN_CODE

NO

NO
DESG_ORGANIZATION_DESC Designation organization code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
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

NO

NO
DESG_PROGRAM_DESC Designation program code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

ADBDESG

ADBDESG_DSTA_CODE

NO

NO
DESG_STATUS_DESC Description of the designation status. VARCHAR2(255)

ATVDSTA

ATVDSTA_DESC

NO

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

ADBDESG

ADBDESG_DSTP_CODE

NO

NO
DESG_TYPE_DESC Designation type description. VARCHAR2(255)

ATVDSTP

ATVDSTP_DESC

NO

NO
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

NO

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

ATVCFAE

ATVCFAE_DESC

NO

NO
DESIGNATION Designation associated with the gift. VARCHAR2(63)

AGRGDES

AGRGMLT

AGRGDES_DESG

AGRGMLT_DESG

NO

NO

NO
DESIGNATION_NAME Designation description. VARCHAR2(255)

ADBDESG

ADBDESG_NAME

NO

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

CONSTANT

CONSTANT

'O'

'P'

NO

NO

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

AGRGDES

AGRGMLT

AGRGDES_PIDM

AGRGMLT_XREF_PIDM

NO

NO

NO
ENTRY_DATE Date the transaction was entered on the account. DATE

AGBGIFT

AGBGIFT_ENTRY_DATE

NO

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

AGBGIFT

AGBGIFT_FEED_IND

NO

NO
FISCAL_YEAR Unique identifier or code for the fiscal year. VARCHAR2(63)

AGBGIFT

AGBGIFT_FISC_CODE

NO

NO
FISCAL_YEAR_DESC Description of the fiscal year code. VARCHAR2(255)

ATVFISC

ATVFISC_DESC

NO

NO
GIFT_ACKNOWLEDGED_IND Indicates if a gift acknowledgement was generated by the system. VARCHAR2(1)

AGBGIFT

AGBGIFT_GACK_IND

NO

NO
GIFT_ADJUSTMENT_IND Indicates if adjustments have been made to this gift amount. VARCHAR2(1)

AGBGIFT

AGBGIFT_ADJ_IND

NO

NO
GIFT_AMOUNT Gift designation amount. NUMBER

AGRGDES

AGRGDES_AMT

NO

NO
GIFT_ASSOCIATED_ENTITY_COUNT Count of entities associated with this gift/payment. NUMBER

FUNCTION

MAKFUNC.F_COUNT_GIFT_ASSOCIATED_ENTITY

NO

NO
GIFT_AUXILIARY_COUNT Count of auxiliary gift records associated with this gift/payment. NUMBER

FUNCTION

MAKFUNC.F_COUNT_GIFT_AUXILIARY

NO

NO
GIFT_CLASS First classification of the gift/payment - anonymous, memorial, etc. VARCHAR2(63)

AGBGIFT

AGBGIFT_GCLS_CODE

NO

NO
GIFT_CLASS2 Second classification of the gift/payment - anonymous, memorial, etc. VARCHAR2(63)

AGBGIFT

AGBGIFT_GCLS_CODE_2

NO

NO
GIFT_CLASS3 Third classification of the gift/payment - anonymous, memorial, etc. VARCHAR2(63)

AGBGIFT

AGBGIFT_GCLS_CODE_3

NO

NO
GIFT_CLASS_DESC Description of the first gift/payment classification. VARCHAR2(255)

ATVGCLS

ATVGCLS_DESC

NO

NO
GIFT_CLASS_DESC2 Description of the second gift class. VARCHAR2(255)

ATVGCLS

ATVGCLS_DESC

NO

NO
GIFT_CLASS_DESC3 Description of the third gift class. VARCHAR2(255)

ATVGCLS

ATVGCLS_DESC

NO

NO
GIFT_COMMENT Comment related to the gift. VARCHAR2(400)

AGBGIFT

AGBGIFT_COMMENT

NO

NO
GIFT_CREDIT_AMOUNT Amount of the gift/payment designation credited to the primary donor or received by a multi-credit recipient donor. NUMBER

CALCULATION

AGRGDES_AMT-F_GIFT_HARD_CREDIT

NO

NO
GIFT_DATE Date a gift is received. Date defaults to the system date if no date is entered. DATE

AGBGIFT

AGBGIFT_GIFT_DATE

NO

NO
GIFT_DEBIT_ACCOUNT_NUMBER Additional debit account number. VARCHAR2(63)

ATVGIFT

ATVGIFT_DB_GL_ACCT

NO

NO
GIFT_NUMBER Number of the gift. VARCHAR2(63)

AGRGDES

AGRGMLT

AGRGDES_GIFT_NO

AGRGMLT_GIFT_NO

NO

NO

NO
GIFT_RANGE Gift range classification associated with the total gift/payment amount. VARCHAR2(63)

AGBGIFT

AGBGIFT_GACK_CODE

NO

NO
GIFT_RANGE_DESC Description of the gift range. VARCHAR2(255)

ATVGACK

ATVGACK_DESC

NO

NO
GIFT_RULE_CLASS Rule class code. VARCHAR2(63)

ATVGIFT

ATVGIFT_RUCL_CODE

NO

NO
GIFT_RULE_CLASS_DESC Unique title assigned to a rule class. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
GIFT_TYPE Gift vehicle for example in honor of, In memory of, anonymous. VARCHAR2(63)

AGBGIFT

AGBGIFT_GIFT_CODE

NO

NO
GIFT_TYPE_DESC Description of the gift/payment type. VARCHAR2(255)

AGBGIFT

AGBGIFT_GIFT_DESC

NO

NO
GIFT_VEHICLE Pledge gift vehicle code associated with this gift. VARCHAR2(63)

AGBGIFT

AGBGIFT_PGVE_CODE

NO

NO
GIFT_VEHICLE_DESC Pledge gift vehicle code description. VARCHAR2(255)

ATVPGVE

ATVPGVE_DESC

NO

NO
GIFT_VSE Gift voluntary support of education category. VARCHAR2(63)

ATVGIFT

ATVGIFT_CFAE_GIFT_CATG

NO

NO
GIFT_VSE_DESC Voluntary support of education code description. VARCHAR2(255)

CALCULATION

DECODE(ATVGIFT_CFAE_GIFT_CATG)

NO

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

SPRIDEN

SPRIDEN_ID

NO

NO
MATCHING_GIFT_COUNT Count of all expected or paid matching gifts associated to this gift/payment. Inactive match gifts are excluded from this count. NUMBER

FUNCTION

MAKFUNC.F_COUNT_MATCH_GIFT

NO

NO
MATCHING_GIFT_IND Indicates if one or more expected or paid matching gifts are associated with this gift/payment. Inactive match gifts are excluded. VARCHAR2(1)

FUNCTION

AOKODSF.F_MATCH_GIFT

NO

NO
MATCHING_GIFT_PAYMENT_IND Indicates if this gift was applied as matching gift payment(s). VARCHAR2(1)

FUNCTION

AOKODSF.F_MATCH_GIFT_PAY

NO

NO
MATCH_GIFT_FORM_RECEIVED_IND Indicates if at least one matching gift form has been received for any associated matching gifts. VARCHAR2(1)

AGBGIFT

AGBGIFT_MATCH_RECEIVED

NO

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

NA

NA

NO

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

NA

NA

NO

NO
NAME Name of the person (LFMI) or organization. VARCHAR2(255)

FUNCTION

SPRIDEN

F_FORMAT_NAME

SPRIDEN_LAST_NAME

NO

NO

NO
PLEDGE_NUMBER Number of the pledge. VARCHAR2(63)

AGRGDES

AGRGDES_PLEDGE_NO

NO

NO
POSTING_DATE Gift feed date is the date the gift was fed to finance. DATE

AGBGIFT

AGBGIFT_FEED_DATE

NO

NO
POST_BATCH_ID Gift feed document code. VARCHAR2(63)

AGBGIFT

AGBGIFT_FEED_DOC_CODE

NO

NO
POST_CASHIER User name. VARCHAR2(255)

AGBGIFT

AGBGIFT_USER

NO

NO
POST_CASHIER_SESSION_NUMBER Cashier session number under which this gift was posted. NUMBER

FUNCTION

AOKODSF.F_GET_SESSION_NUMBER

NO

NO
PREFER_CLASS_YEAR Year in which the constituent received the first degree or the year of expected graduation if the first degree has not yet been earned. VARCHAR2(63)

APBCONS

APBCONS_PREF_CLAS

NO

NO
PREFER_CLASS_YEAR_DESC Constituent's preferred class description. VARCHAR2(255)

NA

NA

NO

NO
PREFER_COLLEGE College within the institution with which the constituent prefers to be associated. VARCHAR2(63)

APBCONS

APBCONS_COLL_CODE_PREF

NO

NO
PREFER_COLLEGE_DESC College, faculty or school name. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

NO

NO
PRIMARY_DONOR_CATEGORY Primary donor category associated with this donor. VARCHAR2(63)

APRCATG

APRCATG_DONR_CODE

NO

NO
PRIMARY_DONOR_CATEGORY_DESC Description of the primary donor category. VARCHAR2(255)

ATVDONR

ATVDONR_DESC

NO

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

NA

NA

NO

NO
RECEIPT_DATE Date receipt was generated by the system. DATE

AGBGIFT

AGBGIFT_RECEIPT_DATE

NO

NO
RECEIPT_REQUIRED_IND Indicates if a receipt is required for this gift/payment. VARCHAR2(1)

AGBGIFT

AGBGIFT_RECEIPT_IND

NO

NO
RESTRICTED_IND Indicates whether the designation is restricted to transfer of pledges and/or gifts across fiscal years. VARCHAR2(1)

ADBDESG

ADBDESG_RESTR_IND

NO

NO
SOLICITATION_COUNT Count of all solicitations associated with the gift/payment transaction. NUMBER

FUNCTION

MAKFUNC.F_COUNT_GIFT_SOLICITOR

NO

NO
SOLICITATION_TYPE Type of solicitation for the highest solicitation amount associated with this gift/payment campaign designation amount. VARCHAR2(63)

AGRGSOL

AGRGSOL_SOLC_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

SPRIDEN

SPRIDEN_FIRST_NAME

NO

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

SPRIDEN

SPRIDEN_ID

NO

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

SPRIDEN

SPRIDEN_LAST_NAME

NO

NO
SOLICITOR_ORG Solicitor organization for the highest solicitation amount associated with this gift/payment campaign designation amount. VARCHAR2(63)

AGRGSOL

AGRGSOL_SOL_ORG

NO

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

AGRGSOL

AGRGSOL_SOL_PIDM

NO

NO


Ver: 9.2