Reporting View Target: DESIGNATION_GIVING

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	(Banner EDW Source Report)
	Advancement Reporting View Reports

Banner Operational Data Store
Reporting View Target: DESIGNATION_GIVING_HISTORY

Description Contains designation giving history for all donors on a per fiscal year basis for any years in which donations were made, promised or credit was received by the donor. Includes designation details, total giving amounts, amounts pledged and paid, multiple and memo credit earned and associated matching gifts received.
Key & Frequency One row per entity per designation per fiscal year.
Recommended Search Columns ENTITY_UID, DESIGNATION
DESIGNATION
DESG_TYPE
DESG_GROUP

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

AMOUNT_GIFT Amount of gifts received from a constituent for a specific designation or campaign. NUMBER
APRDHIS

APRDHIS_AMT_GIFT

AMOUNT_MATCHING_GIFT Amount of donor campaign or designation matching gifts. NUMBER
FUNCTION

F_DESIGNATION_MATCHING_GIFT

AMOUNT_MEMO_CREDIT Amount of donor campaign or designation memo credit. NUMBER
FUNCTION

F_DESIGNATION_MEMO_CREDIT

AMOUNT_MULTIPLE_CREDIT Amount of multiple or hard credit received by the donor. NUMBER
FUNCTION

AOKODSF.F_DESIGNATION_MULT_CREDIT

AMOUNT_PLEDGED Amount the constituent pledged to a specific campaign or designation. NUMBER
APRDHIS

APRDHIS_AMT_PLEDGED

AMOUNT_PLEDGE_PAYMENT Amount of pledge payments received from the constituent for a specific campaign or designation. NUMBER
APRDHIS

APRDHIS_AMT_PLEDGED_PAID

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

ADBDESG_COLL_CODE

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

STVCOLL_DESC

DESG_GROUP User defined attribute associating designations of similar purpose or function. You can group similar designations together for institutional reporting. For example, designations by campaign objectives. VARCHAR2(63)
ADBDESG

ADBDESG_DGRP_CODE

DESG_GROUP_DESC Designation group description. VARCHAR2(255)
ADBDESG

ADBDESG_COLL_CODE

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

ATVDSTP_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)
ATVCFAE

ATVCFAE_DESC

DESIGNATION Designation associated with the gift. VARCHAR2(63)
APRDHIS

APRDHIS_DESG

DESIGNATION_GIVING Total amount given by the constituent by designation. NUMBER
FUNCTION

F_DESIGNATION_GIVING

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
APRDHIS

APRDHIS_PIDM

FISCAL_YEAR Unique identifier or code for the fiscal year. VARCHAR2(63)
APRDHIS

APRDHIS_FISC_CODE

FISCAL_YEAR_DESC Fiscal year code description. VARCHAR2(255)
ATVFISC

ATVFISC_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

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

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

NA

Ver: 9.1

Description	Contains designation giving history for all donors on a per fiscal year basis for any years in which donations were made, promised or credit was received by the donor. Includes designation details, total giving amounts, amounts pledged and paid, multiple and memo credit earned and associated matching gifts received.
Key & Frequency	One row per entity per designation per fiscal year.
Recommended Search Columns	ENTITY_UID, DESIGNATION DESIGNATION DESG_TYPE DESG_GROUP

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
AMOUNT_GIFT	Amount of gifts received from a constituent for a specific designation or campaign.	NUMBER	APRDHIS	APRDHIS_AMT_GIFT
AMOUNT_MATCHING_GIFT	Amount of donor campaign or designation matching gifts.	NUMBER	FUNCTION	F_DESIGNATION_MATCHING_GIFT
AMOUNT_MEMO_CREDIT	Amount of donor campaign or designation memo credit.	NUMBER	FUNCTION	F_DESIGNATION_MEMO_CREDIT
AMOUNT_MULTIPLE_CREDIT	Amount of multiple or hard credit received by the donor.	NUMBER	FUNCTION	AOKODSF.F_DESIGNATION_MULT_CREDIT
AMOUNT_PLEDGED	Amount the constituent pledged to a specific campaign or designation.	NUMBER	APRDHIS	APRDHIS_AMT_PLEDGED
AMOUNT_PLEDGE_PAYMENT	Amount of pledge payments received from the constituent for a specific campaign or designation.	NUMBER	APRDHIS	APRDHIS_AMT_PLEDGED_PAID
DESG_COLLEGE	College code associated with the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_COLL_CODE
DESG_COLLEGE_DESC	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
DESG_GROUP	User defined attribute associating designations of similar purpose or function. You can group similar designations together for institutional reporting. For example, designations by campaign objectives.	VARCHAR2(63)	ADBDESG	ADBDESG_DGRP_CODE
DESG_GROUP_DESC	Designation group description.	VARCHAR2(255)	ADBDESG	ADBDESG_COLL_CODE
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)	ATVDSTP	ATVDSTP_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)	ATVCFAE	ATVCFAE_DESC
DESIGNATION	Designation associated with the gift.	VARCHAR2(63)	APRDHIS	APRDHIS_DESG
DESIGNATION_GIVING	Total amount given by the constituent by designation.	NUMBER	FUNCTION	F_DESIGNATION_GIVING
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	APRDHIS	APRDHIS_PIDM
FISCAL_YEAR	Unique identifier or code for the fiscal year.	VARCHAR2(63)	APRDHIS	APRDHIS_FISC_CODE
FISCAL_YEAR_DESC	Fiscal year code description.	VARCHAR2(255)	ATVFISC	ATVFISC_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
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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA