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

Banner Operational Data Store
Reporting View Target: CAMPAIGN_GIVING_HISTORY

Description Contains campaign 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 campaign 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 campaign per fiscal year.
Recommended Search Columns ENTITY_UID
ENTITY_UID, CAMPAIGN
ENTITY_UID, ENTITY_IND
ENTITY_IND

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    

APRCHIS

APRCHIS_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
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
CAMPAIGN Campaign Campaign that the constituent has responded to with a gift or pledge payment. VARCHAR2(63)    

APRCHIS

APRCHIS_CAMPAIGN

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
CAMPAIGN_NAME Campaign Name Campaign name. VARCHAR2(255)    

AFBCAMP

AFBCAMP_NAME

NO

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

APRCHIS

APRCHIS_FISC_CODE

NO

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

ATVFISC

ATVFISC_DESC

NO

NO
CAMPAIGN_GIVING Campaign Giving Summarized history of the donor's campaign giving. NUMBER    

FUNCTION

F_CAMPAIGN_GIVING

NO

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

APRCHIS

APRCHIS_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    

APRCHIS

APRCHIS_AMT_PLEDGED_PAID

NO

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

APRCHIS

APRCHIS_AMT_GIFT

NO

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

FUNCTION

F_CAMPAIGN_MATCHING_GIFT

NO

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

FUNCTION

F_CAMPAIGN_MEMO_CREDIT

NO

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

FUNCTION

AOKODSF.F_CAMPAIGN_MULT_CREDIT

NO

NO
CAMPAIGN_TYPE Campaign Type Type of campaign recorded. VARCHAR2(63)    

AFBCAMP

AFBCAMP_CMTP_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
CAMPAIGN_TYPE_DESC Campaign Type Description Campaign type description. VARCHAR2(255)    

ATVCMTP

ATVCMTP_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


Ver: 9.2