RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Advancement Reporting View Reports

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

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)

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)

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

'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. NUMBER

APRDHIS

APRDHIS_FISC_CODE

FISCAL_YEAR_DESC Fiscal year 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

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(94)

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: 3.1