Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date that information for this record in the table was entered or last updated.	DATE		AFRCSOL	AFRCSOL_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
CAMPAIGN	Campaign	User defined code for a campaign.	VARCHAR2(63)		AFRCSOL	AFRCSOL_CAMPAIGN
CAMPAIGN_NAME	Campaign Name	Campaign name.	VARCHAR2(255)		AFBCAMP	AFBCAMP_NAME
CAMPAIGN_SOLICITATION_GOAL	Campaign Solicitation Goal	Amount of the solicitation goal for the campaign.	NUMBER		CALCULATION	NVL(AFRCSOL_GOAL,0)
CAMPAIGN_TYPE	Campaign Type	Type of campaign recorded.	VARCHAR2(63)		AFBCAMP	AFBCAMP_CMTP_CODE
CAMPAIGN_TYPE_DESC	Campaign Type Description	Campaign type description.	VARCHAR2(255)		ATVCMTP	ATVCMTP_DESC
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
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
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
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
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
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
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
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
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
SOLICITATION_TYPE	Solicitation Type	Campaign solicitation type.	VARCHAR2(63)		AFRCSOL	AFRCSOL_SOLC_CODE
SOLICITATION_TYPE_DESC	Solicitation Type Description	Campaign solicitation type description.	VARCHAR2(255)		ATVSOLC	ATVSOLC_DESC
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
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
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
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
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
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
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
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
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

Ver: 9.0