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

Banner Operational Data Store
Composite View Target: AA_GIFT_MULTIPLE

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

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)

AGRGMLT

AGRGMLT_CAMPAIGN

NO

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

NA

SYSDATE

NO

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

AGRGMLT

AGRGMLT_DESG

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

AGRGMLT

AGRGMLT_PIDM

NO

NO
FISCAL_YEAR Unique identifier or code for the fiscal year. NUMBER

AGBGIFT

AGBGIFT_FISC_CODE

NO

NO
FISCAL_YEAR_DESC Fiscal year code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
GIFT_AMOUNT Gift designation amount. NUMBER

AGRGDES

AGRGDES_AMT

NO

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

AGBGIFT

AGBGIFT_GCLS_CODE

NO

NO
GIFT_CLASS_DESC Gift class code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

AGRGMLT

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

AGRGMLT

AGRGMLT_GIFT_NO

NO

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 Gift type code description. VARCHAR2(30)

FUNCTION

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

FUNCTION

GOKODSF.F_GET_DESC

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
MULTIPLE_MATCH_GIFT_IND Indicates whether this gift has multiple matching gifts recorded. VARCHAR2(1)

FUNCTION

F_MEMO_DETAIL_MATCHING_GIFT

NO

NO
MULTIPLE_UID Internal identification number for person/organization receiving the multiple credit. NUMBER

AGRGMLT

AGRGMLT_XREF_PIDM

NO

NO
PAYMENT_3PP_AMOUNT Third party amount. NUMBER

AGRGMLT

AGRGMLT_3PP_AMT

NO

NO
PAYMENT_3PP_PLEDGE_NO Third party pledge number. VARCHAR2(7)

AGRGMLT

AGRGMLT_3PP_PLEDGE_NO

NO

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

AGRGMLT

AGRGMLT_PLEDGE_NO

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: