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)			AFBCAMP	AFBCAMP_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
CAPITAL_CAMPAIGN_IND	Capital Campaign Indicator	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
CAMPAIGN_START_DATE	Campaign Start Date	First date that the campaign accepts donations.	DATE			AFBCAMP	AFBCAMP_EST_DATE	NO	NO
CAMPAIGN_END_DATE	Campaign End Date	Last date that the campaign accepts donations.	DATE			AFBCAMP	AFBCAMP_END_DATE	NO	NO
CAMPAIGN_GOAL	Campaign Goal	Amount of the campaign goal.	NUMBER			AFBCAMP	AFBCAMP_GOAL	NO	NO
PCT_PROGRESS_CAMPAIGN_GOAL	Percent 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
DEFAULT_DESIGNATION	Default Designation	Designation to use when pledges for the campaign are created.	VARCHAR2(63)			AFBCAMP	AFBCAMP_DEFAULT_DESG	NO	NO
COUNT_IN_GIVING_IND	Count In Giving Indicator	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
ACTIVITY_DATE	Activity Date	Date that information for this record in the table was entered or last updated.	DATE			AFBCAMP	AFBCAMP_ACTIVITY_DATE	NO	NO
CAMPAIGN_TOTAL_PLEDGES	Campaign Total Pledges	Total amount of pledges made to this campaign.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_TOTAL_PLEDGES	NO	NO
CAMPAIGN_PLEDGE_PAYMENTS	Campaign Pledge Payments	Total amount of pledge payments made to this campaign.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_PLEDGE_PAYMENTS	NO	NO
CAMPAIGN_PLEDGE_BALANCE	Campaign Pledge Balance	Total amount of outstanding pledges.	NUMBER			CALCULATION	MAKFUNC.F_CAMP_TOTAL_PLEDGES - MAKFUNC.F_CAMP_PLEDGE_PAYMENTS	NO	NO
CAMPAIGN_TOTAL_GIFTS	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_OUTRIGHT_GIFTS	Campaign Outright Gifts	Total amount received towards this campaign for outright gifts.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_TOTAL_GIFTS	NO	NO
CAMPAIGN_EXPENSES	Campaign Expenses	Total amount of campaign expenses.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_EXPENSES	NO	NO
CAMPAIGN_VALUE	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_MATCH_GIFTS_ANTICIPATED	Camp Match Gifts Anticipated	Total amount of anticipated matching gifts.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_MATCH_GIFTS_ANTICIPATED	NO	NO
CAMP_MATCHING_GIFTS_PAID	Camp Matching Gifts Paid	Corporate gift received that matches an eligible employee gift.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_MATCH_GIFTS_PAID	NO	NO
CAMPAIGN_PLEDGE_DONOR_COUNT	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_COUNT	Campaign Pledge Count	Total number of pledges made to this campaign.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_PLEDGE_COUNT	NO	NO
CAMPAIGN_TOTAL_DONOR_COUNT	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
CAMP_PLEDGE_DONOR_PAID_COUNT	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
CAMP_PLEDGE_DONOR_NO_PAY_COUNT	Camp Pledge Donor Number 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
OUTRIGHT_GIFT_DONOR_COUNT	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
CAMPAIGN_OUTRIGHT_GIFT_COUNT	Campaign Outright Gift Count	Total number of outright gifts made to this campaign.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_TOTAL_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
CAMPAIGN_TOTAL_GIFT_COUNT	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
TOTAL_CAMP_DESIGNATION_GOAL	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