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

SGHE 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_IND
ENTITY_IND
ENTITY_UID, CAMPAIGN

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

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

APRCHIS

APRCHIS_AMT_GIFT

 
AMOUNT_MATCHING_GIFT Amount of donor campaign or designation matching gifts.    

FUNCTION

F_CAMPAIGN_MATCHING_GIFT

 
AMOUNT_MEMO_CREDIT Amount of donor campaign or designation memo credit.    

FUNCTION

F_CAMPAIGN_MEMO_CREDIT

 
AMOUNT_MULTIPLE_CREDIT Amount of multiple or hard credit received by donor.    

FUNCTION

AOKODSF.F_CAMPAIGN_MULT_CREDIT

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

APRCHIS

APRCHIS_AMT_PLEDGED

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

APRCHIS

APRCHIS_AMT_PLEDGED_PAID

 
CAMPAIGN Campaign's to which the constituent has responded with a gift or pledge payment.    

APRCHIS

APRCHIS_CAMPAIGN

 
CAMPAIGN_GIVING Summarized history of the donor's campaign giving.    

FUNCTION

F_CAMPAIGN_GIVING

 
CAMPAIGN_NAME Campaign name.    

AFBCAMP

AFBCAMP_NAME

 
CAMPAIGN_TYPE Type of campaign recorded.    

AFBCAMP

AFBCAMP_CMTP_CODE

 
CAMPAIGN_TYPE_DESC Campaign type description.    

ATVCMTP

ATVCMTP_DESC

 
ENTITY_IND Indicates whether the entity is a person or an organization.    

CONSTANT

CONSTANT

'O'

'P'

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

APRCHIS

APRCHIS_PIDM

 
FISCAL_YEAR Unique identifier or code for the fiscal year.    

APRCHIS

APRCHIS_FISC_CODE

 
FISCAL_YEAR_DESC Fiscal year code description.    

ATVFISC

ATVFISC_DESC

 
ID Person's or organization's current identification number.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3