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

Banner Operational Data Store
Reporting View Target: CAMPAIGN_SOLICITATION

Description Contains data about solicitation types as it pertains to the campaign. This contains information about campaign solicitation type goal and progress, total pledges, pledge payments and gifts with matching information and various counts.
Key & Frequency One occurrence per campaign per solicitation.
Recommended Search Columns CAMPAIGN
CAMPAIGN_TYPE
CAMPAIGN, SOLICITATION_TYPE
SOLICITATION_TYPE

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)    

AFRCSOL

AFRCSOL_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
SOLICITATION_TYPE Solicitation Type Campaign solicitation type. VARCHAR2(63)    

AFRCSOL

AFRCSOL_SOLC_CODE

NO

NO
SOLICITATION_TYPE_DESC Solicitation Type Description Campaign solicitation type description. VARCHAR2(255)    

ATVSOLC

ATVSOLC_DESC

NO

NO
CAMPAIGN_SOLICITATION_GOAL Campaign Solicitation Goal Amount of the solicitation goal for the campaign. NUMBER    

CALCULATION

NVL(AFRCSOL_GOAL,0)

NO

NO
SOLICITATION_TOTAL_PLEDGES Solicitation Total Pledges Total amount of pledges made as a result of this solicitation type for this campaign. NUMBER    

FUNCTION

MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES

NO

NO
SOLICITATION_PLEDGE_PAYMENTS Solicitation Pledge Payments Total amount of pledge payments received as a result of this solicitation type for this campaign. NUMBER    

FUNCTION

MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS

NO

NO
SOLICITATION_PLEDGE_BALANCE Solicitation Pledge Balance Total amount of outstanding pledges for this campaign solicitation type combination. NUMBER    

CALCULATION

MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS

NO

NO
SOLICITATION_TOTAL_GIFTS Solicitation Total Gifts Total amount of gifts received towards this campaign solicitation type combination, including pledge payments and outright gifts. NUMBER    

FUNCTION

MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS

NO

NO
SOLICITATION_OUTRIGHT_GIFTS Solicitation Outright Gifts Total amount of outright gifts received as a result of this solicitation type for this campaign. NUMBER    

FUNCTION

MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS

NO

NO
ACTIVITY_DATE Activity Date Date that information for this record in the table was entered or last updated. DATE    

AFRCSOL

AFRCSOL_ACTIVITY_DATE

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
SOLT_PERCENT_OF_CAMPAIGN_GOAL Solt Percent Of Campaign Goal Percentage of the overall campaign goal this solicitation type goal represents. NUMBER    

CALCULATION

AFRCSOL_GOAL / AFBCAMP_GOAL * 100

NO

NO
PCT_SOLT_PROGRESS_CAMP_GOAL Percent Solt Progress Camp Goal Percentage of progress toward the campaign goal represented by the gift amount received for this solicitation type. This includes the outstanding pledge balance. NUMBER    

CALCULATION

(MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS + MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS) / AFBCAMP_GOAL * 100

NO

NO
PCT_PROGRESS_SOLT_GOAL Percent Progress Solt Goal Percentage of progress toward the solicitation goal for this campaign represented by the gift amount received for this solicitation type. This includes the outstanding pledge balance. NUMBER    

CALCULATION

(MAKFUNC.F_SOLG_CAMP_TOTAL_GIFTS + MAKFUNC.F_SOLP_CAMP_TOTAL_PLEDGES - MAKFUNC.F_SOLP_CAMP_PLEDGE_PAYMENTS) / AFRCSOL_GOAL * 100

NO

NO
SOLT_PLEDGE_DONOR_COUNT Solt Pledge Donor Count Total number of donors who made one or more pledges as a result of this solicitation type for this campaign. This includes original donors and any individuals who received hard credit. NUMBER    

FUNCTION

MAKFUNC.F_SOLP_PLEDGE_DONOR_COUNT

NO

NO
SOLT_PLEDGE_COUNT Solt Pledge Count Total number of pledges made as a result of this solicitation type for this campaign. NUMBER    

FUNCTION

MAKFUNC.F_SOLP_PLEDGE_COUNT

NO

NO
SOLT_CAMP_TOTAL_DONOR_COUNT Solt Camp Total Donor Count Total number of donors who have made one or more gifts to this solicitation type for this campaign. This includes donors who have received hard credit from gifts and includes pledges made with no payment received to date. NUMBER    

FUNCTION

MAKFUNC.F_SOLP_TOTAL_DONOR_COUNT

NO

NO
SOLT_PLEDGE_DONOR_PAID_COUNT Solt Pledge Donor Paid Count Total number of donors who have made payments toward at least one of their pledges to this solicitation type for this campaign. This could be fully paid or partial paid for any one or more of the pledges. NUMBER    

FUNCTION

MAKFUNC.F_SOLP_TOTAL_DONOR_COUNT

NO

NO
SOLT_PLEDGE_DONOR_NO_PAY_COUNT Solt Pledge Donor Number Pay Count Total number of donors who have not made any payments toward their pledges to this solicitation type for this campaign. NUMBER    

FUNCTION

MAKFUNC.F_SOLP_PLEDGE_DONOR_COUNT

NO

NO
SOLT_OUTRIGHT_GIFT_DONOR_COUNT Solt Outright Gift Donor Count Total number of donors who made one or more outright gifts to this solicitation type for this campaign. NUMBER    

FUNCTION

MAKFUNC.F_SOLP_TOTAL_DONOR_COUNT

NO

NO
SOLT_CAMP_TOTAL_GIFT_COUNT Solt Camp Total Gift Count Total number of gifts made to this solicitation type for this campaign. This includes both payments and outright gifts. NUMBER    

FUNCTION

MAKFUNC.F_SOLG_CAMP_GIFT_COUNT

NO

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

FUNCTION

MAKFUNC.F_SOLG_CAMP_GIFT_COUNT

NO

NO


Ver: 9.2