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)			AFRCSLT	AFRCSLT_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	Solicitation type code.	VARCHAR2(63)			AFRCSLT	AFRCSLT_SOLC_CODE	NO	NO
SOLICITATION_TYPE_DESC	Solicitation Type Description	Solicitation type description.	VARCHAR2(255)			ATVSOLC	ATVSOLC_DESC	NO	NO
SOLICITOR_ORGANIZATION	Solicitor Organization	Solicitor organization code.	VARCHAR2(63)			AFRCSLT	AFRCSLT_SOL_ORG	NO	NO
SOLICITOR_ORGANIZATION_NAME	Solicitor Organization Name	Solicitor organization name.	VARCHAR2(255)			ASBSORG	ASBSORG_NAME	NO	NO
SOLICITOR_UID	Solicitor UID	System generated, unique, internal identification number assigned to this solicitor.	NUMBER			AFRCSLT	AFRCSLT_PIDM	NO	NO
SOLICITOR_ID	Solicitor ID	Solicitor's current identification number.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
SOLICITOR_NAME	Solicitor Name	Name of the solicitor (last name, first name, middle initial) or organization name.	VARCHAR2(255)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
MAXIMUM_ASSIGNED_CONTACT_COUNT	Maximum Assigned Contact Count	Maximum number of contacts that can be assigned to the solicitor.	NUMBER			AFRCSLT	AFRCSLT_MAX_CONTACTS	NO	NO
SOLICTOR_STATUS	Solictor Status	Current solicitor status with this campaign.	VARCHAR2(63)			AFRCSLT	AFRCSLT_SSTA_CODE	NO	NO
SOLICTOR_STATUS_DESC	Solictor Status Description	Solicitor status description.	VARCHAR2(255)			ATVSSTA	ATVSSTA_DESC	NO	NO
ACTIVE_SOLICITOR_IND	Active Solicitor Indicator	Solicitor status active indicator. Determines if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)			ATVSSTA	ATVSSTA_ACTIVE_IND	NO	NO
SOLICTOR_STATUS_DATE	Solictor Status Date	Date when the status was assigned to the solicitor.	DATE			AFRCSLT	AFRCSLT_SSTA_DATE	NO	NO
REPORT_TO_UID	Report To UID	Solicitor unique identification to report to that is one level higher in the organization hierarchy.	NUMBER			AFRCSLT	AFRCSLT_REPORT_TO_PIDM	NO	NO
REPORT_TO_ID	Report To ID	Report to solicitor current identification number.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
REPORT_TO_NAME	Report To Name	Report to solicitor name (last name, first name, middle initial) or organization name.	VARCHAR2(255)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
CAMPAIGN_SOLICITOR_GOAL	Campaign Solicitor Goal	Amount of the solicitor goal for this campaign.	NUMBER			AFRCSLT	NVL(AFRSCLT_GOAL,0)	NO	NO
SOLICITOR_PCT_OF_CAMPAIGN_GOAL	Solicitor Percent Of Campaign Goal	Percentage of the overall campaign goal this solicitor goal represents.	NUMBER			EXPRESSION	(CAMPAIGN_SOLICITOR_GOAL / CAMPAIGN_GOAL * 100)	NO	NO
PCT_SOLC_PROGRESS_CAMP_GOAL	Percent Solicitor Progress Campaign Goal	Percentage of progress toward the campaign goal represented by the gift amount received for this solicitor. This includes the outstanding pledge balance.	NUMBER			EXPRESSION	CASE WHEN (CAMPAIGN_GOAL > 0	NO	NO
PCT_PROGRESS_SOLICITOR_GOAL	Percent Progress Solicitor Goal	Percentage progress toward the solicitor goal for this campaign represented by the gift amount received for this solicitor. This includes the outstanding pledge balance.	NUMBER			EXPRESSION	NVL(CASE WHEN(CAMPAIGN_SOLICITOR_GOAL > 0	NO	NO
CAMP_SOLICITOR_TOTAL_PLEDGES	Camp Solicitor Total Pledges	Total amount of pledges made to this campaign solicitor combination.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_SOL_TOTAL_PLEDGES	NO	NO
CAMP_SOLICITOR_PLEDGE_PAYMENTS	Campaign Solicitor Pledge Payments	Total amount of pledge payments made to this campaign solicitor combination.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_SOL_PLEDGE_PAYMENTS	NO	NO
CAMP_SOLICITOR_PLEDGE_BALANCE	Campaign Solicitor Pledge Balance	Total amount of outstanding pledges for this campaign solicitor combination.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_SOL_TOTAL_PLEDGES - MAKFUNC.F_CAMP_SOL_PLEDGE_PAYMENTS	NO	NO
CAMP_SOLICITOR_TOTAL_GIFTS	Campaign Solicitor Total Gifts	Total amount of gifts received toward this campaign solicitor combination, including pledge payments and outright gifts.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_SOL_TOTAL_GIFTS	NO	NO
CAMP_SOLICITOR_OUTRIGHT_GIFTS	Campaign Solicitor Outright Gifts	Total amount received toward this campaign solicitor combination for outright gifts.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_SOL_OUTRIGHT_GIFTS	NO	NO
CAMP_SOLC_PLEDGE_DONOR_COUNT	Campaign Solicitor Pledge Donor Count	Total number of donors who made one or more pledges to this campaign solicitor combination. This includes original donors and any individuals who received hard credit.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_SOL_PLEDGE_DONOR_COUNT	NO	NO
CAMP_SOLICITOR_PLEDGE_COUNT	Campaign Solicitor Pledge Count	Total number of pledges made to this campaign solicitor combination.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_SOL_PLEDGE_COUNT	NO	NO
CAMP_SOLC_TOTAL_DONOR_COUNT	Campaign Solicitor 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_CAMP_SOL_TOTAL_DONOR_COUNT	NO	NO
SOLC_PLEDGE_DONOR_PAID_COUNT	Solicitor Pledge Donor Paid Count	Total number of donors who have made payments toward their pledges to this campaign solicitor combination. This could be fully paid or partial paid.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_SOL_PD_PAID_COUNT	NO	NO
SOLC_PLEDGE_DONOR_NO_PAY_COUNT	Solicitor Pledge Donor No Pay Count	Total number of donors who have not made any payments toward their pledges to this campaign solicitor combination.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_SOL_PD_NP_COUNT	NO	NO
SOLC_OUTRIGHT_GIFT_DONOR_COUNT	Solicitor Outright Gift Donor Count	Total number of donors who made one or more outright gifts to this campaign solicitor combination.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_SOL_OUTRIGHT_GD_COUNT	NO	NO
CAMP_SOLC_TOTAL_GIFT_COUNT	Solicitor Campaign Total Gift Count	Total number of gifts made to this campaign solicitor combination. This includes both payments and outright gifts.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_SOL_TOTAL_GIFT_COUNT	NO	NO
CAMP_SOLC_OUTRIGHT_GIFT_COUNT	Solicitor Campaign Outright Gift Count	Total number of outright gifts made to this campaign solicitor combination.	NUMBER			FUNCTION	MAKFUNC.F_CAMP_SOL_OUTRIGHT_GC_COUNT	NO	NO
ALLOW_WEB_UPDATE_SOLICITOR_IND	Allow Web Update Solicitor Indicator	Determines if the organization's solicitor can be updated via the web. (Y)es, the solicitor can be updated via the web, (N)o, the solicitor cannot be updated via the web.	VARCHAR2(1)			CALCULATION	ASRSORG_UPD_WEB_IND	NO	NO
SOLICITOR_ACTIVITY_DATE	Solicitor Activity Date	Date information for this record in the table was entered or last updated.	DATE			AFRCSLT	AFRCSLT_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

Ver: 9.2