Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
(Banner EDW Source Report)
Advancement Reporting View Reports

Banner Operational Data Store
Reporting View Target: CAMPAIGN

Description Contains data about the campaign. This contains information about campaign goal and progress, total pledges, pledge payments and gifts with matching information and various counts.
Key & Frequency One occurrence per campaign.
Recommended Search Columns CAMPAIGN_TYPE

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Date that information for this record in the table was entered or last updated. DATE

AFBCAMP

AFBCAMP_ACTIVITY_DATE

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

NA

NA

CAMPAIGN Campaign that the constituent has responded to with a gift or pledge payment. VARCHAR2(63)

AFBCAMP

AFBCAMP_CAMPAIGN

CAMPAIGN_END_DATE Last date that the campaign accepts donations. DATE

AFBCAMP

AFBCAMP_END_DATE

CAMPAIGN_EXPENSES Total amount of campaign expenses. NUMBER

FUNCTION

MAKFUNC.F_CAMP_EXPENSES

CAMPAIGN_GOAL Amount of the campaign goal. NUMBER

AFBCAMP

AFBCAMP_GOAL

CAMPAIGN_NAME Campaign name. VARCHAR2(255)

AFBCAMP

AFBCAMP_NAME

CAMPAIGN_OUTRIGHT_GIFTS Total amount received towards this campaign for outright gifts. NUMBER

FUNCTION

MAKFUNC.F_CAMP_TOTAL_GIFTS

CAMPAIGN_OUTRIGHT_GIFT_COUNT Total number of outright gifts made to this campaign. NUMBER

FUNCTION

MAKFUNC.F_CAMP_TOTAL_GIFT_COUNT

CAMPAIGN_PLEDGE_BALANCE Total amount of outstanding pledges. NUMBER

CALCULATION

MAKFUNC.F_CAMP_TOTAL_PLEDGES - MAKFUNC.F_CAMP_PLEDGE_PAYMENTS

CAMPAIGN_PLEDGE_COUNT Total number of pledges made to this campaign. NUMBER

FUNCTION

MAKFUNC.F_CAMP_PLEDGE_COUNT

CAMPAIGN_PLEDGE_DONOR_COUNT Total number of donors who made one or more pledges to this campaign. This includes original donors and any individuals who received hard credit. NUMBER

FUNCTION

MAKFUNC.F_CAMP_PLEDGE_DONOR_COUNT

CAMPAIGN_PLEDGE_PAYMENTS Total amount of pledge payments made to this campaign. NUMBER

FUNCTION

MAKFUNC.F_CAMP_PLEDGE_PAYMENTS

CAMPAIGN_START_DATE First date that the campaign accepts donations. DATE

AFBCAMP

AFBCAMP_EST_DATE

CAMPAIGN_TOTAL_DONOR_COUNT Total number of donors who have made one or more gifts to this campaign. This includes donors who have received hard credit from gifts made to this campaign. This includes pledges made with no payment received to date. NUMBER

FUNCTION

MAKFUNC.F_CAMP_TOTAL_DONOR_COUNT

CAMPAIGN_TOTAL_GIFTS Total amount of gifts received towards this campaign, including pledge payments and outright gifts. NUMBER

FUNCTION

MAKFUNC.F_CAMP_TOTAL_GIFTS

CAMPAIGN_TOTAL_GIFT_COUNT Total number of gifts made to this campaign. This includes both payments and outright gifts. NUMBER

FUNCTION

MAKFUNC.F_CAMP_TOTAL_GIFT_COUNT

CAMPAIGN_TOTAL_PLEDGES Total amount of pledges made to this campaign. NUMBER

FUNCTION

MAKFUNC.F_CAMP_TOTAL_PLEDGES

CAMPAIGN_TYPE Type of campaign recorded. VARCHAR2(63)

AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Campaign type description. VARCHAR2(255)

ATVCMTP

ATVCMTP_DESC

CAMPAIGN_VALUE Amount the campaign has received in gifts and outstanding pledges less any accrued expenses. NUMBER

CALCULATION

MAKFUNC.F_CAMP_TOTAL_GIFTS + MAKFUNC.F_CAMP_TOTAL_PLEDGES - MAKFUNC.F_CAMP_PLEDGE_PAYMENTS - MAKFUNC.F_CAMP_EXPENSES

CAMP_MATCHING_GIFTS_PAID Corporate gift received that matches an eligible employee gift. NUMBER

FUNCTION

MAKFUNC.F_CAMP_MATCH_GIFTS_PAID

CAMP_MATCH_GIFTS_ANTICIPATED Total amount of anticipated matching gifts. NUMBER

FUNCTION

MAKFUNC.F_CAMP_MATCH_GIFTS_ANTICIPATED

CAMP_PLEDGE_DONOR_NO_PAY_COUNT Total number of donors who have not made any payments toward any of their pledges for this campaign. NUMBER

FUNCTION

MAKFUNC.F_CAMP_PLEDGE_DONOR_COUNT

CAMP_PLEDGE_DONOR_PAID_COUNT Total number of donors who have made a payment toward at least one of their pledges for this campaign. This could be fully paid or partial paid for any one or more of the pledges. NUMBER

FUNCTION

MAKFUNC.F_CAMP_TOTAL_DONOR_COUNT

CAPITAL_CAMPAIGN_IND Indicates if this is a capital campaign. (Y)es for a capital campaign. (N)o for a non-capital campaign. VARCHAR2(63)

CALCULATION

NVL(ATVCMPT_CAPITAL_IND,'N')

COUNT_IN_GIVING_IND Indicates if money received for this campaign is used in the calculation of a constituents giving level. VARCHAR2(63)

CALCULATION

NVL(AFBCAMP_ASSOC_IND,'N')

DEFAULT_DESIGNATION Designation to use when pledges for the campaign are created. VARCHAR2(63)

AFBCAMP

AFBCAMP_DEFAULT_DESG

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

OUTRIGHT_GIFT_DONOR_COUNT Total number of donors who made one or more outright gifts to this campaign. NUMBER

FUNCTION

MAKFUNC.F_CAMP_TOTAL_DONOR_COUNT

PCT_PROGRESS_CAMPAIGN_GOAL Percentage of the campaign goal that has been reached by the sum of gifts and outstanding pledges. NUMBER

CALCULATION

(MAKFUNC.F_CAMP_TOTAL_GIFTS + MAKFUNC.F_CAMP_TOTAL_PLEDGES + MAKFUNC.F_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100

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

NA

NA

TOTAL_CAMP_DESIGNATION_GOAL Amount of the designation goal for the campaign. This total should match the Campaign Goal. NUMBER

FUNCTION

MAKFUNC.F_TOTAL_CAMP_DESG_GOAL



Ver: 9.1