Reporting View Target: GIFT

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Advancement Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: GIFT_MULTIPLE

Description Contains detail information for all multiple credit awarded (or received) at the designation level including donor, recipient, gift/pledge numbers, designation amount, multiple 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 multiple UID.
Recommended Search Columns ENTITY_UID
ENTITY_UID, GIFT_NUMBER
MULTIPLE_UID, GIFT_NUMBER
ENTITY_UID, ENTITY_IND
ENTITY_IND

Target Column Business Definition Database Data Type Source Name Source Column

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

NA

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

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

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

AGRGMLT_PIDM

FISCAL_YEAR Unique identifier or code for the fiscal year. NUMBER
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 Percentage of the gift being disbursed to the cross-reference identification number from the pledge for the designation. NUMBER
AGRGMLT

AGRGMLT_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 the multiple credit is being disbursed. VARCHAR2(63)
AGRGMLT

AGRGMLT_GIFT_NO

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 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 Person's or organization's current identification number. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MULTIPLE_ID Current identification number assigned to the person or organization receiving the multiple credit. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

F_MEMO_DETAIL_MATCHING_GIFT

MULTIPLE_NAME Name of the person (last name, first name, middle initial) or organization receiving the multiple credit. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

AGRGMLT_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 amount. NUMBER
AGRGMLT

AGRGMLT_3PP_AMT

PAYMENT_3PP_PLEDGE_NO Third party pledge number. VARCHAR2(63)
AGRGMLT

AGRGMLT_3PP_PLEDGE_NO

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

AGRGMLT_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.1

Description	Contains detail information for all multiple credit awarded (or received) at the designation level including donor, recipient, gift/pledge numbers, designation amount, multiple 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 multiple UID.
Recommended Search Columns	ENTITY_UID ENTITY_UID, GIFT_NUMBER MULTIPLE_UID, GIFT_NUMBER ENTITY_UID, ENTITY_IND ENTITY_IND

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CAMPAIGN	Campaign associated with the gift from which multiple credit is being disbursed.	VARCHAR2(63)	AGRGMLT	AGRGMLT_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.	VARCHAR2(63)	AGRGMLT	AGRGMLT_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	AGRGMLT	AGRGMLT_PIDM
FISCAL_YEAR	Unique identifier or code for the fiscal year.	NUMBER	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	Percentage of the gift being disbursed to the cross-reference identification number from the pledge for the designation.	NUMBER	AGRGMLT	AGRGMLT_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 the multiple credit is being disbursed.	VARCHAR2(63)	AGRGMLT	AGRGMLT_GIFT_NO
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 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	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MULTIPLE_ID	Current identification number assigned to the person or organization receiving the multiple credit.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MULTIPLE_MATCH_GIFT_IND	Indicates if one or more matching gifts are associated with this gift/payment.	VARCHAR2(1)	FUNCTION	F_MEMO_DETAIL_MATCHING_GIFT
MULTIPLE_NAME	Name of the person (last name, first name, middle initial) or organization receiving the multiple credit.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MULTIPLE_UID	Internal identification number for person/organization receiving the multiple credit.	NUMBER	AGRGMLT	AGRGMLT_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 amount.	NUMBER	AGRGMLT	AGRGMLT_3PP_AMT
PAYMENT_3PP_PLEDGE_NO	Third party pledge number.	VARCHAR2(63)	AGRGMLT	AGRGMLT_3PP_PLEDGE_NO
PLEDGE_NUMBER	Pledge number associated with the gift from which the multiple credit is being disbursed.	VARCHAR2(63)	AGRGMLT	AGRGMLT_PLEDGE_NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA