Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Advancement Reporting View Reports

SGHE 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 DESIGNATION
DESG_TYPE
DESG_GROUP
ENTITY_UID, DESIGNATION

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

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

APRDHIS

APRDHIS_AMT_GIFT

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

FUNCTION

F_DESIGNATION_MATCHING_GIFT

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

FUNCTION

F_DESIGNATION_MEMO_CREDIT

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

FUNCTION

AOKODSF.F_DESIGNATION_MULT_CREDIT

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

APRDHIS

APRDHIS_AMT_PLEDGED

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

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

ADBDESG

ADBDESG_COLL_CODE

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

STVCOLL

STVCOLL_DESC

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

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

ADBDESG

ADBDESG_COLL_CODE

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

ADBDESG

ADBDESG_DSTP_CODE

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

ATVDSTP

ATVDSTP_DESC

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

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

ATVCFAE

ATVCFAE_DESC

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

APRDHIS

APRDHIS_DESG

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

FUNCTION

F_DESIGNATION_GIVING

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  

APRDHIS

APRDHIS_PIDM

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

APRDHIS

APRDHIS_FISC_CODE

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

ATVFISC

ATVFISC_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

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

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