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

SGHE 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 Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

AGRGMMO

AGRGMMO_CAMPAIGN

CAMPAIGN_NAME Campaign name. VARCHAR2(255)

AFBCAMP

AFBCAMP_NAME

CAMPAIGN_TYPE Type of campaign recorded. VARCHAR2(63)

AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Campaign type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_COLL_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_DSTP_CODE

DESG_TYPE_DESC Designation type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DESG_VSE 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

DESG_VSE_DESC Voluntary support of education code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

AGRGMMO

AGRGMMO_DESG

DESIGNATION_NAME Designation description. VARCHAR2(255)

ADBDESG

ADBDESG_NAME

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

CONSTANT

CONSTANT

'O'

'P'

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. VARCHAR2(63)

AGBGIFT

AGBGIFT_FISC_CODE

FISCAL_YEAR_DESC Fiscal year code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

GIFT_AMOUNT Gift designation amount. NUMBER

AGRGDES

AGRGDES_AMT

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

AGBGIFT

AGBGIFT_GCLS_CODE

GIFT_CLASS_DESC Gift class code description. VARCHAR2(255)

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

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

AGRGMMO

AGRGMMO_GIFT_NO

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

AGBGIFT

AGBGIFT_GIFT_CODE

GIFT_TYPE_DESC Gift type code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

AGBGIFT

AGBGIFT_PGVE_CODE

GIFT_VEHICLE_DESC Pledge gift vehicle code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

MEMO_ID Current identification number assigned to the person or organization receiving the memo credit. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

F_MEMO_DETAIL_MATCHING_GIFT

MEMO_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

MEMO_UID System generated, unique, internal identification number assigned to the person or organization receiving the memo credit. NUMBER

AGRGMMO

AGRGMMO_XREF_PIDM

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PAYMENT_3PP_AMOUNT Third party payment amount. NUMBER

AGRGMMO

AGRGMMO_3PP_AMT

PAYMENT_3PP_PLEDGE_NO Pledge number associated with the third party payment. VARCHAR2(63)

AGRGMMO

AGRGMMO_3PP_PLEDGE_NO

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

AGRGMMO

AGRGMMO_PLEDGE_NO

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

NA

NA



Ver: 8.5