Reporting View Target: DESIGNATION_GIVING

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	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 Name Business Definition Database Data Type Business Data Type Domain Value Source Name Source Column Local Source Local Target

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

APRDHIS_PIDM

NO
NO

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

'O'
'P'

NO
NO
NO

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

APRDHIS_DESG

NO
NO

ID 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

NO
NO

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

MGKFUNC.F_GET_PERSON_INFO

NO
NO

DESIGNATION_NAME Designation Name Designation description. VARCHAR2(255)
ADBDESG

ADBDESG_NAME

NO
NO

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

APRDHIS_FISC_CODE

NO
NO

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

ATVFISC_DESC

NO
NO

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

F_DESIGNATION_GIVING

NO
NO

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

APRDHIS_AMT_PLEDGED

NO
NO

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

APRDHIS_AMT_PLEDGED_PAID

NO
NO

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

APRDHIS_AMT_GIFT

NO
NO

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

F_DESIGNATION_MATCHING_GIFT

NO
NO

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

F_DESIGNATION_MEMO_CREDIT

NO
NO

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

AOKODSF.F_DESIGNATION_MULT_CREDIT

NO
NO

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

ADBDESG_DSTP_CODE

NO
NO

DESG_TYPE_DESC Designation Type Description Designation type description. VARCHAR2(255)
ATVDSTP

ATVDSTP_DESC

NO
NO

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

ADBDESG_COLL_CODE

NO
NO

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

STVCOLL_DESC

NO
NO

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

NO
NO

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

NA

NO
NO

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

ATVCFAE_DESC

NO
NO

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

NA

NO
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

NO
NO

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

NA

NO
NO

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

NO
NO

DESG_GROUP_DESC Designation Group Description Designation group description. VARCHAR2(255)
ADBDESG

ADBDESG_COLL_CODE

NO
NO

Ver: 9.2

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 Name	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	APRDHIS	APRDHIS_PIDM	NO	NO
ENTITY_IND	Entity Indicator	Indicates whether the entity is a person or an organization.	VARCHAR2(1)	CONSTANT CONSTANT	'O' 'P'	NO NO	NO
DESIGNATION	Designation	Designation associated with the gift.	VARCHAR2(63)	APRDHIS	APRDHIS_DESG	NO	NO
ID	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	NO	NO
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
DESIGNATION_NAME	Designation Name	Designation description.	VARCHAR2(255)	ADBDESG	ADBDESG_NAME	NO	NO
FISCAL_YEAR	Fiscal Year	Unique identifier or code for the fiscal year.	VARCHAR2(63)	APRDHIS	APRDHIS_FISC_CODE	NO	NO
FISCAL_YEAR_DESC	Fiscal Year Description	Fiscal year code description.	VARCHAR2(255)	ATVFISC	ATVFISC_DESC	NO	NO
DESIGNATION_GIVING	Designation Giving	Total amount given by the constituent by designation.	NUMBER	FUNCTION	F_DESIGNATION_GIVING	NO	NO
AMOUNT_PLEDGED	Amount Pledged	Amount the constituent pledged to a specific campaign or designation.	NUMBER	APRDHIS	APRDHIS_AMT_PLEDGED	NO	NO
AMOUNT_PLEDGE_PAYMENT	Amount Pledge Payment	Amount of pledge payments received from the constituent for a specific campaign or designation.	NUMBER	APRDHIS	APRDHIS_AMT_PLEDGED_PAID	NO	NO
AMOUNT_GIFT	Amount Gift	Amount of gifts received from a constituent for a specific designation or campaign.	NUMBER	APRDHIS	APRDHIS_AMT_GIFT	NO	NO
AMOUNT_MATCHING_GIFT	Amount Matching Gift	Amount of donor campaign or designation matching gifts.	NUMBER	FUNCTION	F_DESIGNATION_MATCHING_GIFT	NO	NO
AMOUNT_MEMO_CREDIT	Amount Memo Credit	Amount of donor campaign or designation memo credit.	NUMBER	FUNCTION	F_DESIGNATION_MEMO_CREDIT	NO	NO
AMOUNT_MULTIPLE_CREDIT	Amount Multiple Credit	Amount of multiple or hard credit received by the donor.	NUMBER	FUNCTION	AOKODSF.F_DESIGNATION_MULT_CREDIT	NO	NO
DESG_TYPE	Designation Type	Designation type for a specific pledge or gift designation.	VARCHAR2(63)	ADBDESG	ADBDESG_DSTP_CODE	NO	NO
DESG_TYPE_DESC	Designation Type Description	Designation type description.	VARCHAR2(255)	ATVDSTP	ATVDSTP_DESC	NO	NO
DESG_COLLEGE	Designation College	College code associated with the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_COLL_CODE	NO	NO
DESG_COLLEGE_DESC	Designation College Description	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC	NO	NO
DESG_VSE	Designation 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	NO	NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
DESG_VSE_DESC	Designation VSE - Voluntary Support of Education Description	Voluntary support of education code description.	VARCHAR2(255)	ATVCFAE	ATVCFAE_DESC	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	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	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
DESG_GROUP	Designation 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	NO	NO
DESG_GROUP_DESC	Designation Group Description	Designation group description.	VARCHAR2(255)	ADBDESG	ADBDESG_COLL_CODE	NO	NO