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

Banner Operational Data Store
Composite View Target: AA_GIFT

Description Source composite view contains information on all gifts or payments made by a person or organization including campaign, designation, associated pledge details, matching gift information, preferred class, solicitation and recognition details.

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

AGRGDES

AGRGMLT

AGRGDES_CAMPAIGN

AGRGMLT_CAMPAIGN

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

AGRGDES

AGRGDES_ACTIVITY_DATE

DESIGNATION Designation associated with the gift. VARCHAR2(10)

AGRGDES

AGRGMLT

AGRGDES_DESG

AGRGMLT_DESG

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

AGRGDES

AGRGMLT

AGRGDES_PIDM

AGRGMLT_XREF_PIDM

ENTRY_DATE Date the transaction was entered on the account. DATE

AGBGIFT

AGBGIFT_ENTRY_DATE

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

AGBGIFT

AGBGIFT_FEED_IND

FISCAL_YEAR Unique identifier or code for the fiscal year. NUMBER

AGBGIFT

AGBGIFT_FISC_CODE

FISCAL_YEAR_DESC Description of the fiscal year code. VARCHAR2(30)

ATVFISC

ATVFISC_DESC

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

AGBGIFT

AGBGIFT_GACK_IND

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

AGBGIFT

AGBGIFT_ACTIVITY_DATE

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

AGBGIFT

AGBGIFT_ADJ_IND

GIFT_AMOUNT Gift designation amount. NUMBER

AGRGDES

AGRGDES_AMT

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

AGBGIFT

AGBGIFT_GCLS_CODE

GIFT_CLASS2 Second category of the gift - anonymous, memorial, etc. VARCHAR2(4)

AGBGIFT

AGBGIFT_GCLS_CODE_2

GIFT_CLASS3 Third category of the gift - anonymous, memorial, etc. VARCHAR2(4)

AGBGIFT

AGBGIFT_GCLS_CODE_3

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

ATVGCLS

ATVGCLS_DESC

GIFT_CLASS_DESC2 Description of the second gift class. VARCHAR2(30)

ATVGCLS

ATVGCLS_DESC

GIFT_CLASS_DESC3 Description of the third gift class. VARCHAR2(30)

ATVGCLS

ATVGCLS_DESC

GIFT_COMMENT Comment related to the gift. VARCHAR2(300)

AGBGIFT

AGBGIFT_COMMENT

GIFT_CREDIT_AMOUNT This is the gift credit amount. NUMBER

CALCULATION

AGRGDES_AMT-F_GIFT_HARD_CREDIT

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

AGBGIFT

AGBGIFT_GIFT_DATE

GIFT_DEBIT_ACCOUNT_NUMBER Additional debit account number. VARCHAR2(60)

ATVGIFT

ATVGIFT_DB_GL_ACCT

GIFT_NUMBER Number of the gift. VARCHAR2(7)

AGRGDES

AGRGMLT

AGRGDES_GIFT_NO

AGRGMLT_GIFT_NO

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

AGBGIFT

AGBGIFT_GACK_CODE

GIFT_RANGE_DESC Description of the gift range. VARCHAR2(30)

ATVGACK

ATVGACK_DESC

GIFT_RULE_CLASS Rule class code. VARCHAR2(4)

ATVGIFT

ATVGIFT_RUCL_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

GIFT_TRANSACTION_AMOUNT This is the gift total amount. NUMBER    
GIFT_TYPE Gift vehicle for example in honor of, In memory of, anonymous. VARCHAR2(2)

AGBGIFT

AGBGIFT_GIFT_CODE

GIFT_TYPE_DESC Description of the gift type. VARCHAR2(60)

AGBGIFT

AGBGIFT_GIFT_DESC

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

AGBGIFT

AGBGIFT_PGVE_CODE

GIFT_VEHICLE_DESC Pledge gift vehicle code description. VARCHAR2(30)

ATVPGVE

ATVPGVE_DESC

GIFT_VSE Gift voluntary support of education category. VARCHAR2(1)

ATVGIFT

ATVGIFT_CFAE_GIFT_CATG

GIFT_VSE_DESC This field specifies the description of the Voluntary Support of Education code. VARCHAR2(50)

CALCULATION

DECODE(ATVGIFT_CFAE_GIFT_CATG)

MATCHING_GIFT Matching gift. VARCHAR2(1)

FUNCTION

F_MATCHING_GIFT

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

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

FUNCTION

AOKODSF.F_MATCH_GIFT

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

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)

AGRGDES

AGRGMLT

AGRGDES_PLEDGE_NO

AGRGMLT_PLEDGE_NO

POST_BATCH_ID Gift feed document code. VARCHAR2(8)

AGBGIFT

AGBGIFT_FEED_DOC_CODE

POST_CASHIER_SESSION_NUMBER Cashier session number under which the gift/payment was posted. NUMBER

FUNCTION

AOKODSF.F_GET_SESSION_NUMBER

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

AGBGIFT

AGBGIFT_FEED_DATE

POST_USER User name. VARCHAR2(30)

AGBGIFT

AGBGIFT_USER

RECEIPT_DATE Date receipt was generated by the system. DATE

AGBGIFT

AGBGIFT_RECEIPT_DATE

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

AGBGIFT

AGBGIFT_RECEIPT_IND

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

NA

NA



Ver: