Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
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 Local Source Local Target
ACTIVITY_DATE Date that information for this record in the table was entered or last updated. DATE

AFBCAMP

AFBCAMP_ACTIVITY_DATE

NO

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

NA

NA

NO

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

AFBCAMP

AFBCAMP_CAMPAIGN

NO

NO
CAMPAIGN_END_DATE Last date that the campaign accepts donations. DATE

AFBCAMP

AFBCAMP_END_DATE

NO

NO
CAMPAIGN_EXPENSES Total amount of campaign expenses. NUMBER

FUNCTION

MAKFUNC.F_CAMP_EXPENSES

NO

NO
CAMPAIGN_GOAL Amount of the campaign goal. NUMBER

AFBCAMP

AFBCAMP_GOAL

NO

NO
CAMPAIGN_NAME Campaign name. VARCHAR2(255)

AFBCAMP

AFBCAMP_NAME

NO

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

FUNCTION

MAKFUNC.F_CAMP_TOTAL_GIFTS

NO

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

FUNCTION

MAKFUNC.F_CAMP_TOTAL_GIFT_COUNT

NO

NO
CAMPAIGN_PLEDGE_BALANCE Total amount of outstanding pledges. NUMBER

CALCULATION

MAKFUNC.F_CAMP_TOTAL_PLEDGES - MAKFUNC.F_CAMP_PLEDGE_PAYMENTS

NO

NO
CAMPAIGN_PLEDGE_COUNT Total number of pledges made to this campaign. NUMBER

FUNCTION

MAKFUNC.F_CAMP_PLEDGE_COUNT

NO

NO
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

NO

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

FUNCTION

MAKFUNC.F_CAMP_PLEDGE_PAYMENTS

NO

NO
CAMPAIGN_START_DATE First date that the campaign accepts donations. DATE

AFBCAMP

AFBCAMP_EST_DATE

NO

NO
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

NO

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

FUNCTION

MAKFUNC.F_CAMP_TOTAL_GIFTS

NO

NO
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

NO

NO
CAMPAIGN_TOTAL_PLEDGES Total amount of pledges made to this campaign. NUMBER

FUNCTION

MAKFUNC.F_CAMP_TOTAL_PLEDGES

NO

NO
CAMPAIGN_TYPE Type of campaign recorded. VARCHAR2(63)

AFBCAMP

AFBCAMP_CMTP_CODE

NO

NO
CAMPAIGN_TYPE_DESC Campaign type description. VARCHAR2(255)

ATVCMTP

ATVCMTP_DESC

NO

NO
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

NO

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

FUNCTION

MAKFUNC.F_CAMP_MATCH_GIFTS_PAID

NO

NO
CAMP_MATCH_GIFTS_ANTICIPATED Total amount of anticipated matching gifts. NUMBER

FUNCTION

MAKFUNC.F_CAMP_MATCH_GIFTS_ANTICIPATED

NO

NO
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

NO

NO
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

NO

NO
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')

NO

NO
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')

NO

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

AFBCAMP

AFBCAMP_DEFAULT_DESG

NO

NO
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

NO

NO
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

NO
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

NO

NO
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

NO

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

NA

NA

NO

NO
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

NO

NO


Ver: 9.2