Reporting View Target: CAMPAIGN

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 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
AFRCSOL

AFRCSOL_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)
AFRCSOL

AFRCSOL_CAMPAIGN

NO
NO

CAMPAIGN_NAME Campaign name. VARCHAR2(255)
AFBCAMP

AFBCAMP_NAME

NO
NO

CAMPAIGN_SOLICITATION_GOAL Amount of the solicitation goal for the campaign. NUMBER
CALCULATION

NVL(AFRCSOL_GOAL,0)

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

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

PCT_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

PCT_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

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

NA

NO
NO

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

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_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_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_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_TYPE Campaign solicitation type. VARCHAR2(63)
AFRCSOL

AFRCSOL_SOLC_CODE

NO
NO

SOLICITATION_TYPE_DESC Campaign solicitation type description. VARCHAR2(255)
ATVSOLC

ATVSOLC_DESC

NO
NO

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

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_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_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_PERCENT_OF_CAMPAIGN_GOAL Percentage of the overall campaign goal this solicitation type goal represents. NUMBER
CALCULATION

AFRCSOL_GOAL / AFBCAMP_GOAL * 100

NO
NO

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_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_DONOR_NO_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_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

Ver: 9.2

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 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	AFRCSOL	AFRCSOL_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)	AFRCSOL	AFRCSOL_CAMPAIGN	NO	NO
CAMPAIGN_NAME	Campaign name.	VARCHAR2(255)	AFBCAMP	AFBCAMP_NAME	NO	NO
CAMPAIGN_SOLICITATION_GOAL	Amount of the solicitation goal for the campaign.	NUMBER	CALCULATION	NVL(AFRCSOL_GOAL,0)	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
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
PCT_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
PCT_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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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
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_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_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_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_TYPE	Campaign solicitation type.	VARCHAR2(63)	AFRCSOL	AFRCSOL_SOLC_CODE	NO	NO
SOLICITATION_TYPE_DESC	Campaign solicitation type description.	VARCHAR2(255)	ATVSOLC	ATVSOLC_DESC	NO	NO
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
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_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_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_PERCENT_OF_CAMPAIGN_GOAL	Percentage of the overall campaign goal this solicitation type goal represents.	NUMBER	CALCULATION	AFRCSOL_GOAL / AFBCAMP_GOAL * 100	NO	NO
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_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_DONOR_NO_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_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