Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE 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 associated with the gift from which memo credit is being disbursed. VARCHAR2(5)

AGRGMMO

AGRGMMO_CAMPAIGN

CAMPAIGN_NAME Campaign name. VARCHAR2(30)

AFBCAMP

AFBCAMP_NAME

CAMPAIGN_TYPE Type of campaign recorded. VARCHAR2(2)

AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Campaign type description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

SYSDATE

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

ADBDESG

ADBDESG_COLL_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

ADBDESG

ADBDESG_DSTP_CODE

DESG_TYPE_DESC Designation type description. VARCHAR2(30)

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(5)

ADBDESG

ADBDESG_CFAE_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

AGRGMMO

AGRGMMO_DESG

DESIGNATION_NAME Designation description. VARCHAR2(60)

ADBDESG

ADBDESG_NAME

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(8)

AGRGMMO

AGRGMMO_PIDM

FISCAL_YEAR Unique identifier or code for the fiscal year. NUMBER(4)

AGBGIFT

AGBGIFT_FISC_CODE

FISCAL_YEAR_DESC Fiscal year code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

GIFT_AMOUNT Gift designation amount. NUMBER(11, 2)

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 Percentage of the gift being disbursed to the cross-reference identification number from the pledge for the designation. NUMBER(11, 2)

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 Type of gift or method of payment. For example, check, credit card, bequest, property. 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(8)

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(11, 2)

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