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

Banner Operational Data Store
Reporting View Target: CAMPAIGN_DESIGNATION

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

Target Column Business Name Business Definition Database Data Type Business Data Type Domain Value Source Name Source Column Local Source Local Target
CAMPAIGN Campaign Campaign that the constituent has responded to with a gift or pledge payment. VARCHAR2(63)    

AFRDESG

AFRDESG_CAMPAIGN

NO

NO
CAMPAIGN_NAME Campaign Name Campaign name. VARCHAR2(255)    

AFBCAMP

AFBCAMP_NAME

NO

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

AFBCAMP

AFBCAMP_CMTP_CODE

NO

NO
CAMPAIGN_TYPE_DESC Campaign Type Description Campaign type description. VARCHAR2(255)    

ATVCMTP

ATVCMTP_DESC

NO

NO
DESIGNATION Designation User defined code for a designation. VARCHAR2(63)    

AFRDESG

AFRDESG_DESG

NO

NO
DESIGNATION_NAME Designation Name Designation name. VARCHAR2(255)    

ADBDESG

ADBDESG_NAME

NO

NO
DESG_TYPE Designation Type Type of designation. Used to identify testamentary commitments, charitable reminder trusts, and pooled income funds in Voluntary Support of Education processing. VARCHAR2(63)    

ADBDESG

ADBDESG_DSTP_CODE

NO

NO
DESG_TYPE_DESC Designation Type Description Designation type description. VARCHAR2(255)    

ATVDSTP

ATVDSTP_DESC

NO

NO
DESG_GROUP Designation Group Group associated with the designation. You can group similar designations together for institutional reporting. For example, designations by campaign objectives. VARCHAR2(63)    

ADBDESG

ADBDESG_DGRP_CODE

NO

NO
DESG_GROUP_DESC Designation Group Description Designation group description. VARCHAR2(255)    

ATVDGRP

ATVDGRP_DESC

NO

NO
CAMPAIGN_DESIGNATION_GOAL Campaign Designation Goal Amount of the designation goal for the campaign. NUMBER    

CALCULATION

NVL(AFRDESG_GOAL,0)

NO

NO
DESG_PERCENT_OF_CAMPAIGN_GOAL Designation Percent Of Campaign Goal Percentage of the overall campaign goal this designation goal represents. NUMBER    

CALCULATION

AFRDESG_GOAL / AFBCAMP_GOAL * 100

NO

NO
PCT_DESG_PROGRESS_CAMP_GOAL Percent Designation Progress Camp Goal Percentage of progress toward the campaign goal represented by the gift amount received for this designation. This includes the outstanding pledge balance. NUMBER    

CALCULATION

(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100

NO

NO
PCT_PROGRESS_DESIGNATION_GOAL Percent Progress Designation Goal Percentage progress toward the designation goal for this campaign represented by the gift amount received for this designation. This includes the outstanding pledge balance. NUMBER    

CALCULATION

(MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS + MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES + MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS) / AFRDESG_GOAL * 100

NO

NO
CAMPAIGN_DESG_STATUS Campaign Designation Status Indicates designation status for the campaign. VARCHAR2(63)    

AFRDESG

AFRDESG_DSTA_CODE

NO

NO
CAMPAIGN_DESG_STATUS_DESC Campaign Designation Status Description Designation status description. VARCHAR2(255)    

ATVSDTA

ATVDSTA_DESC

NO

NO
DESG_VSE Designation VSE - Voluntary Support of Education Predefined code determining the purpose for giving as defined for Council for Aid to Education reporting. VARCHAR2(63)    

ADBDESG

ADBDESG_CFAE_CODE

NO

NO
DESG_VSE_DESC Designation VSE - Voluntary Support of Education Description Voluntary Support of Education purpose description. VARCHAR2(255)    

ATVCFAE

ATVCFAE_DESC

NO

NO
DESG_VSE_PURPOSE_TYPE Designation VSE - Voluntary Support of Education Purpose Type Voluntary Support of Education purpose type as defined for Council for Aid to Education reporting. NUMBER    

ATVCFAE

ATVCFAE_TYPE

NO

NO
DESG_VSE_PURPOSE_TYPE_DESC Designation VSE - Voluntary Support of Education Purpose Type Description Voluntary Support of Education purpose type description. VARCHAR2(255)    

CONSTANT

HARCODED DESCRIPTIONS. SEE THE ONLINE HELP FOR BANNER FORM ATVVSER FOR A COMPLETE LIST OF VALUES.

NO

NO
MATCHING_GIFT_VSE_PURPOSE Matching Gift VSE - Voluntary Support of Education Purpose The Matching Gift Purpose associates the Voluntary Support of Education code to a matching gift related purpose. VARCHAR2(63)    

ATVCFAE

ATVCFAE_MG_PURPOSE

NO

NO
MATCHING_GIFT_VSE_PURPOSE_DESC Matching Gift VSE - Voluntary Support of Education Purpose Description Matching gift Voluntary Support of Education purpose description. VARCHAR2(255)    

CALCULATION

DECODE(ATVCFAE_MG_PURPOSE,'A','ALUMNI OR OTHER ASSOCIATIONS','B','RELIGIOUS PURPOSES AT THE INSTITUTION','C','POLITICAL PURPOSES AT THE INSTITUTION','D','ATHLETIC ACTIVITIES','E','ATHLETIC SCHOLARSHIP FUNDS','F','NON-ATHLETIC SCHOLARSHIP FUNDS',ETC.)

NO

NO
CAMP_DESG_TOTAL_PLEDGES Camp Designation Total Pledges Total amount of pledges made to this campaign designation combination. NUMBER    

FUNCTION

MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES

NO

NO
CAMP_DESG_PLEDGE_PAYMENTS Camp Designation Pledge Payments Total amount of pledge payments made to this campaign designation combination. NUMBER    

FUNCTION

MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS

NO

NO
CAMP_DESG_PLEDGE_BALANCE Camp Designation Pledge Balance Total amount of outstanding pledges for this campaign designation combination. NUMBER    

CALCULATION

MAKFUNC.F_DESG_CAMP_TOTAL_PLEDGES - MAKFUNC.F_DESG_CAMP_PLEDGE_PAYMENTS

NO

NO
CAMP_DESG_TOTAL_GIFTS Camp Designation Total Gifts Total amount of gifts received toward this campaign designation combination, including pledge payments and outright gifts. NUMBER    

FUNCTION

MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS

NO

NO
CAMP_DESG_OUTRIGHT_GIFTS Camp Designation Outright Gifts Total amount received toward this campaign designation combination for outright gifts. NUMBER    

FUNCTION

MAKFUNC.F_DESG_CAMP_TOTAL_GIFTS

NO

NO
RESTRICTED_IND Restricted Indicator Indicates whether the designation is restricted to transfer of pledges and/or gifts across fiscal years. VARCHAR2(1)    

ADBDESG

ADBDESG_RESTR_IND

NO

NO
DESG_MATCH_GIFTS_ANTICIPATED Designation Match Gifts Anticipated Total amount of anticipated matching gifts toward this campaign designation combination. NUMBER    

FUNCTION

MAKFUNC.F_DESG_MATCH_GIFTS_ANTICIPATED

NO

NO
CAMP_DESG_MATCHING_GIFTS_PAID Camp Designation Matching Gifts Paid Corporate gift received that matches an eligible employee gift to this campaign designation combination. NUMBER    

FUNCTION

MAKFUNC.F_DESG_MATCH_GIFTS_PAID

NO

NO
CAMP_DESG_PLEDGE_DONOR_COUNT Camp Designation Pledge Donor Count Total number of donors who made one or more pledges to this campaign designation combination. This includes original donors and any individuals who received hard credit. NUMBER    

FUNCTION

MAKFUNC.F_DESG_PLEDGE_DONOR_COUNT

NO

NO
CAMP_DESG_PLEDGE_COUNT Camp Designation Pledge Count Total number of pledges made to this campaign designation combination. NUMBER    

FUNCTION

MAKFUNC.F_DESG_PLEDGE_COUNT

NO

NO
CAMP_DESG_TOTAL_DONOR_COUNT Camp Designation Total Donor Count Total number of donors who have made one or more gifts to this campaign designation combination. This includes donors who have received hard credit from gifts and includes pledges made with no payment received to date. NUMBER    

FUNCTION

MAKFUNC.F_DESG_TOTAL_DONOR_COUNT

NO

NO
DESG_PLEDGE_DONOR_PAID_COUNT Designation Pledge Donor Paid Count Total number of donors who have made payments toward their pledges to this campaign designation combination. This could be fully paid or partial paid. NUMBER    

FUNCTION

MAKFUNC.F_DESG_TOTAL_DONOR_COUNT

NO

NO
DESG_PLEDGE_DONOR_NO_PAY_COUNT Designation Pledge Donor Number Pay Count Total number of donors who have not made any payments toward their pledges to this campaign designation combination. NUMBER    

FUNCTION

MAKFUNC.F_DESG_PLEDGE_DONOR_COUNT

NO

NO
DESG_OUTRIGHT_GIFT_DONOR_COUNT Designation Outright Gift Donor Count Total number of donors who made one or more outright gifts to this campaign designation combination. NUMBER    

FUNCTION

MAKFUNC.F_DESG_TOTAL_DONOR_COUNT

NO

NO
CAMP_DESG_OUTRIGHT_GIFT_COUNT Camp Designation Outright Gift Count Total number of outright gifts made to this campaign designation combination. NUMBER    

FUNCTION

MAKFUNC.F_DESG_CAMP_GIFT_COUNT

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
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
CAMP_DESG_TOTAL_GIFT_COUNT Camp Desg Total Gift Count Total number of gifts made to this campaign designation combination. This includes both payments and outright gifts. NUMBER    

FUNCTION

MAKFUNC.F_DESG_CAMP_GIFT_COUNT

NO

NO
ACTIVE_DESIGNATION_IND Active Designation Indicator Designation status active indicator determining if the status is active (Y)es, or inactive (N)o. VARCHAR2(1)    

ATVDSTA

ATVDSTA_ACTIVE_IND

NO

NO


Ver: 9.2