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

Banner Operational Data Store
Reporting View Target: GIFT_MEMO

Description Contains detail information for all memo credit awarded (or received) at the designation level including donor, recipient, gift/pledge numbers, designation amount, memo credit amount, match gift indicator and 3rd party payment details.
Key & Frequency One row per entity per gift number per pledge number per campaign per designation per memo UID.
Recommended Search Columns CAMPAIGN_TYPE
ENTITY_UID, GIFT_NUMBER
MEMO_UID, GIFT_NUMBER
FISCAL_YEAR
GIFT_DATE
DESIGNATION
DESG_TYPE

Target Column Business Name Business Definition Database Data Type Business Data Type Domain Value Source Name Source Column Local Source Local Target
ENTITY_UID Entity UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER    

AGRGMMO

AGRGMMO_PIDM

NO

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

CONSTANT

CONSTANT

'O'

'P'

NO

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
MEMO_UID Memo Credit Recipient UID System generated, unique, internal identification number assigned to the person or organization receiving the memo credit. NUMBER    

AGRGMMO

AGRGMMO_XREF_PIDM

NO

NO
GIFT_NUMBER Gift Number Gift number from which memo credit is being disbursed. VARCHAR2(63)    

AGRGMMO

AGRGMMO_GIFT_NO

NO

NO
NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

AGRGMMO

AGRGMMO_PLEDGE_NO

NO

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

AGRGMMO

AGRGMMO_CAMPAIGN

NO

NO
MEMO_ID Memo Credit Recipient ID Current identification number assigned to the person or organization receiving the memo credit. VARCHAR2(63)    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
CAMPAIGN_NAME Campaign Name Campaign name. VARCHAR2(255)    

AFBCAMP

AFBCAMP_NAME

NO

NO
MEMO_NAME Memo Credit Recipient Name Name of the person (last name, first name, middle initial) or organization receiving the memo credit. VARCHAR2(255)    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

AGRGMMO

AGRGMMO_DESG

NO

NO
DESIGNATION_NAME Designation Name Designation description. VARCHAR2(255)    

ADBDESG

ADBDESG_NAME

NO

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

AGBGIFT

AGBGIFT_FISC_CODE

NO

NO
FISCAL_YEAR_DESC Fiscal Year Description Fiscal year code description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
GIFT_DATE Gift Date Date of the gift for IRS valuation purposes. Used to obtain purchase price per unit in the unitization process in endowment management. DATE    

AGBGIFT

AGBGIFT_GIFT_DATE

NO

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

AGBGIFT

AGBGIFT_GIFT_CODE

NO

NO
GIFT_TYPE_DESC Gift Type Description Gift type code description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
GIFT_CLASS Gift Class Category of the gift - anonymous, memorial, etc. VARCHAR2(63)    

AGBGIFT

AGBGIFT_GCLS_CODE

NO

NO
GIFT_CLASS_DESC Gift Class Description Gift class code description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
GIFT_AMOUNT Gift Amount Gift designation amount. NUMBER    

AGRGDES

AGRGDES_AMT

NO

NO
GIFT_CREDIT 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

NO

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

AGBGIFT

AGBGIFT_PGVE_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
CAMPAIGN_TYPE Campaign Type Type of campaign recorded. VARCHAR2(63)    

AFBCAMP

AFBCAMP_CMTP_CODE

NO

NO
CAMPAIGN_TYPE_DESC Campaign Type Description Campaign type description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
MEMO_MATCH_GIFT_IND Memo Match Gift Indicator Indicates if one or more matching gifts are associated with this gift/payment. VARCHAR2(1)    

FUNCTION

F_MEMO_DETAIL_MATCHING_GIFT

NO

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

ADBDESG

ADBDESG_DSTP_CODE

NO

NO
DESG_TYPE_DESC Desg Type Description Designation type description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

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

ADBDESG

ADBDESG_COLL_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
DESG_VSE Desg VSE - Voluntary Support of Education 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 Desg VSE - Voluntary Support of Education Description Voluntary support of education code description. VARCHAR2(255)    

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
PAYMENT_3PP_AMOUNT Third Party Payment Amount Third party payment amount. NUMBER    

AGRGMMO

AGRGMMO_3PP_AMT

NO

NO
PAYMENT_3PP_PLEDGE_NO Third Party Payment Pledge Number Pledge number associated with the third party payment. VARCHAR2(63)    

AGRGMMO

AGRGMMO_3PP_PLEDGE_NO

NO

NO
MULTI_SOURCE 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 Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)    

NA

NA

NO

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

NA

NA

NO

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

NA

NA

NO

NO


Ver: 9.2