Reporting View Target: GIFT

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
DESIGNATION
DESG_TYPE
ENTITY_UID, GIFT_NUMBER
MEMO_UID, GIFT_NUMBER
FISCAL_YEAR
GIFT_DATE

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

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

NA

CAMPAIGN Campaign Campaign associated with the gift from which memo credit is being disbursed. VARCHAR2(63)
AGRGMMO

AGRGMMO_CAMPAIGN

CAMPAIGN_NAME Campaign Name Campaign name. VARCHAR2(255)
AFBCAMP

AFBCAMP_NAME

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

AFBCAMP_CMTP_CODE

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

GOKODSF.F_GET_DESC

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

ADBDESG_COLL_CODE

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

GOKODSF.F_GET_DESC

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

ADBDESG_DSTP_CODE

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

GOKODSF.F_GET_DESC

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

DESG_VSE_DESC Desg VSE - Voluntary Support of Education Description Voluntary support of education code description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

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

AGRGMMO_DESG

DESIGNATION_NAME Designation Name Designation description. VARCHAR2(255)
ADBDESG

ADBDESG_NAME

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

'O'
'P'

ENTITY_UID Entity UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER
AGRGMMO

AGRGMMO_PIDM

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

AGBGIFT_FISC_CODE

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

GOKODSF.F_GET_DESC

GIFT_AMOUNT Gift Amount Gift designation amount. NUMBER
AGRGDES

AGRGDES_AMT

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

AGBGIFT_GCLS_CODE

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

GOKODSF.F_GET_DESC

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

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

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

AGRGMMO_GIFT_NO

GIFT_TYPE Gift Type Type of gift or method of payment, i.e., check, credit card, bequest, property. VARCHAR2(63)
AGBGIFT

AGBGIFT_GIFT_CODE

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

GOKODSF.F_GET_DESC

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

AGBGIFT_PGVE_CODE

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

GOKODSF.F_GET_DESC

ID ID Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

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

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

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

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

NA

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

NA

NAME 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 Third party payment amount. NUMBER
AGRGMMO

AGRGMMO_3PP_AMT

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

AGRGMMO_3PP_PLEDGE_NO

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

AGRGMMO_PLEDGE_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

Ver: 9.0

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 DESIGNATION DESG_TYPE ENTITY_UID, GIFT_NUMBER MEMO_UID, GIFT_NUMBER FISCAL_YEAR GIFT_DATE

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CAMPAIGN	Campaign	Campaign associated with the gift from which memo credit is being disbursed.	VARCHAR2(63)	AGRGMMO	AGRGMMO_CAMPAIGN
CAMPAIGN_NAME	Campaign Name	Campaign name.	VARCHAR2(255)	AFBCAMP	AFBCAMP_NAME
CAMPAIGN_TYPE	Campaign Type	Type of campaign recorded.	VARCHAR2(63)	AFBCAMP	AFBCAMP_CMTP_CODE
CAMPAIGN_TYPE_DESC	Campaign Type Description	Campaign type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DESG_COLLEGE	Desg College	College code associated with the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_COLL_CODE
DESG_COLLEGE_DESC	Desg College Description	College, faculty or school name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DESG_TYPE	Desg Type	Designation type for a specific pledge or gift designation.	VARCHAR2(63)	ADBDESG	ADBDESG_DSTP_CODE
DESG_TYPE_DESC	Desg Type Description	Designation type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
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
DESG_VSE_DESC	Desg VSE - Voluntary Support of Education Description	Voluntary support of education code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DESIGNATION	Designation	Designation associated with the gift from which memo credit is being disbursed.	VARCHAR2(63)	AGRGMMO	AGRGMMO_DESG
DESIGNATION_NAME	Designation Name	Designation description.	VARCHAR2(255)	ADBDESG	ADBDESG_NAME
ENTITY_IND	Entity Indicator	Indicates whether the entity is a person or an organization.	VARCHAR2(1)	CONSTANT CONSTANT	'O' 'P'
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	AGRGMMO	AGRGMMO_PIDM
FISCAL_YEAR	Fiscal Year	Unique identifier or code for the fiscal year.	VARCHAR2(63)	AGBGIFT	AGBGIFT_FISC_CODE
FISCAL_YEAR_DESC	Fiscal Year Description	Fiscal year code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
GIFT_AMOUNT	Gift Amount	Gift designation amount.	NUMBER	AGRGDES	AGRGDES_AMT
GIFT_CLASS	Gift Class	Category of the gift - anonymous, memorial, etc.	VARCHAR2(63)	AGBGIFT	AGBGIFT_GCLS_CODE
GIFT_CLASS_DESC	Gift Class Description	Gift class code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
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
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
GIFT_NUMBER	Gift Number	Gift number from which memo credit is being disbursed.	VARCHAR2(63)	AGRGMMO	AGRGMMO_GIFT_NO
GIFT_TYPE	Gift Type	Type of gift or method of payment, i.e., check, credit card, bequest, property.	VARCHAR2(63)	AGBGIFT	AGBGIFT_GIFT_CODE
GIFT_TYPE_DESC	Gift Type Description	Gift type code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
GIFT_VEHICLE	Gift Vehicle	Pledge gift vehicle code associated with this gift.	VARCHAR2(63)	AGBGIFT	AGBGIFT_PGVE_CODE
GIFT_VEHICLE_DESC	Gift Vehicle Description	Pledge gift vehicle code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ID	ID	Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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
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
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
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
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	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	Third party payment amount.	NUMBER	AGRGMMO	AGRGMMO_3PP_AMT
PAYMENT_3PP_PLEDGE_NO	Third Party Payment Pledge Number	Pledge number associated with the third party payment.	VARCHAR2(63)	AGRGMMO	AGRGMMO_3PP_PLEDGE_NO
PLEDGE_NUMBER	Pledge Number	Pledge number associated with the gift from which memo credit is being disbursed.	VARCHAR2(63)	AGRGMMO	AGRGMMO_PLEDGE_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