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

Banner Operational Data Store
Composite View Target: AA_GIFT_MEMO

Description Source composite view contains information for each memo or soft credit assignment made in association with an individual gift or pledge payment. .

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)

AGRGMMO

AGRGMMO_CAMPAIGN

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

NA

SYSDATE

DESIGNATION Designation associated with the gift from which memo credit is being disbursed. VARCHAR2(10)

AGRGMMO

AGRGMMO_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

AGRGMMO

AGRGMMO_PIDM

FISCAL_YEAR Unique identifier or code for the fiscal year. NUMBER

AGBGIFT

AGBGIFT_FISC_CODE

FISCAL_YEAR_DESC Fiscal year code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

GIFT_AMOUNT Gift designation amount. NUMBER

AGRGDES

AGRGDES_AMT

GIFT_CLASS Category of the gift - anonymous, memorial, etc. VARCHAR2(4)

AGBGIFT

AGBGIFT_GCLS_CODE

GIFT_CLASS_DESC Gift class code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

GIFT_CREDIT Amount of the gift for this designation being disbursed as memo (soft) credit to the cross-referenced credit recipient identification number. NUMBER

AGRGMMO

AGRGMMO_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_NUMBER Gift number from which memo credit is being disbursed. VARCHAR2(7)

AGRGMMO

AGRGMMO_GIFT_NO

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

AGBGIFT

AGBGIFT_GIFT_CODE

GIFT_TYPE_DESC Gift type code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

MEMO_MATCH_GIFT_IND Matching gift indicator. VARCHAR2(1)

FUNCTION

F_MEMO_DETAIL_MATCHING_GIFT

MEMO_UID Internal identification number for person/organization receiving the memo credit. NUMBER

AGRGMMO

AGRGMMO_XREF_PIDM

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

PAYMENT_3PP_AMOUNT Third party amount. NUMBER

AGRGMMO

AGRGMMO_3PP_AMT

PAYMENT_3PP_PLEDGE_NO Third party pledge number. VARCHAR2(7)

AGRGMMO

AGRGMMO_3PP_PLEDGE_NO

PLEDGE_NUMBER Pledge number associated with the gift from which memo credit is being disbursed. VARCHAR2(7)

AGRGMMO

AGRGMMO_PLEDGE_NO

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

NA

NA



Ver: