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 Local Source Local Target
CAMPAIGN Campaign that the constituent has responded to with a gift or pledge payment. VARCHAR2(5)

AGRGDES

AGRGMLT

AGRGDES_CAMPAIGN

AGRGMLT_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

AGRGDES

AGRGDES_ACTIVITY_DATE

NO

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

AGRGDES

AGRGMLT

AGRGDES_DESG

AGRGMLT_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

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. NUMBER

AGBGIFT

AGBGIFT_FISC_CODE

NO

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

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_ACTIVITY_DATE Specifies the date this record was created or updated. DATE

AGBGIFT

AGBGIFT_ACTIVITY_DATE

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_CLASS First classification of the gift/payment - anonymous, memorial, etc. VARCHAR2(4)

AGBGIFT

AGBGIFT_GCLS_CODE

NO

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

AGBGIFT

AGBGIFT_GCLS_CODE_2

NO

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

AGBGIFT

AGBGIFT_GCLS_CODE_3

NO

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

ATVGCLS

ATVGCLS_DESC

NO

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

ATVGCLS

ATVGCLS_DESC

NO

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

ATVGCLS

ATVGCLS_DESC

NO

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

AGBGIFT

AGBGIFT_COMMENT

NO

NO
GIFT_CREDIT_AMOUNT This is the gift credit amount. 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(60)

ATVGIFT

ATVGIFT_DB_GL_ACCT

NO

NO
GIFT_NUMBER Number of the gift. VARCHAR2(7)

AGRGDES

AGRGMLT

AGRGDES_GIFT_NO

AGRGMLT_GIFT_NO

NO

NO

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

AGBGIFT

AGBGIFT_GACK_CODE

NO

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

ATVGACK

ATVGACK_DESC

NO

NO
GIFT_RULE_CLASS Rule class code. VARCHAR2(4)

ATVGIFT

ATVGIFT_RUCL_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

AGBGIFT

AGBGIFT_GIFT_CODE

NO

NO
GIFT_TYPE_DESC Description of the gift type. VARCHAR2(60)

AGBGIFT

AGBGIFT_GIFT_DESC

NO

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

AGBGIFT

AGBGIFT_PGVE_CODE

NO

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

ATVPGVE

ATVPGVE_DESC

NO

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

ATVGIFT

ATVGIFT_CFAE_GIFT_CATG

NO

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

CALCULATION

DECODE(ATVGIFT_CFAE_GIFT_CATG)

NO

NO
MATCHING_GIFT Matching gift. VARCHAR2(1)

FUNCTION

F_MATCHING_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

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
MIF_DESC Institution description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

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

NA

NA

NO

NO
PLEDGE_NUMBER Number of the pledge. VARCHAR2(7)

AGRGDES

AGRGMLT

AGRGDES_PLEDGE_NO

AGRGMLT_PLEDGE_NO

NO

NO

NO
POST_BATCH_ID Gift feed document code. VARCHAR2(8)

AGBGIFT

AGBGIFT_FEED_DOC_CODE

NO

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

FUNCTION

AOKODSF.F_GET_SESSION_NUMBER

NO

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

AGBGIFT

AGBGIFT_FEED_DATE

NO

NO
POST_USER User name. VARCHAR2(30)

AGBGIFT

AGBGIFT_USER

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
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: