Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVE_SOLICITOR_IND	Solicitor status active indicator. Determines if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)	ATVSSTA	ATVSSTA_ACTIVE_IND	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
ALLOW_WEB_UPDATE_SOLICITOR_IND	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
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.	VARCHAR2(255)	AFBCAMP	AFBCAMP_NAME	NO	NO
CAMPAIGN_SOLICITOR_GOAL	Amount of the solicitor goal for this campaign.	NUMBER	AFRCSLT	NVL(AFRSCLT_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
CAMP_SOLC_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
CAMP_SOLC_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_SOLC_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
CAMP_SOLC_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_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_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_PLEDGE_COUNT	Total number of pledges made to this campaign solicitor combination.	NUMBER	FUNCTION	MAKFUNC.F_CAMP_SOL_PLEDGE_COUNT	NO	NO
CAMP_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_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_TOTAL_PLEDGES	Total amount of pledges made to this campaign solicitor combination.	NUMBER	FUNCTION	MAKFUNC.F_CAMP_SOL_TOTAL_PLEDGES	NO	NO
MAXIMUM_ASSIGNED_CONTACT_COUNT	Maximum number of contacts that can be assigned to the solicitor.	NUMBER	AFRCSLT	AFRCSLT_MAX_CONTACTS	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_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
PCT_SOLC_PROGRESS_CAMP_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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
REPORT_TO_ID	Report to solicitor current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
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
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
SOLC_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
SOLC_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_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
SOLICITATION_TYPE	Solicitation type code.	VARCHAR2(63)	AFRCSLT	AFRCSLT_SOLC_CODE	NO	NO
SOLICITATION_TYPE_DESC	Solicitation type description.	VARCHAR2(255)	ATVSOLC	ATVSOLC_DESC	NO	NO
SOLICITOR_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	AFRCSLT	AFRCSLT_ACTIVITY_DATE	NO	NO
SOLICITOR_ID	Solicitor's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
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
SOLICITOR_ORGANIZATION	Solicitor organization code.	VARCHAR2(63)	AFRCSLT	AFRCSLT_SOL_ORG	NO	NO
SOLICITOR_ORGANIZATION_NAME	Solicitor organization name.	VARCHAR2(255)	ASBSORG	ASBSORG_NAME	NO	NO
SOLICITOR_PCT_OF_CAMPAIGN_GOAL	Percentage of the overall campaign goal this solicitor goal represents.	NUMBER	EXPRESSION	(CAMPAIGN_SOLICITOR_GOAL / CAMPAIGN_GOAL * 100)	NO	NO
SOLICITOR_UID	System generated, unique, internal identification number assigned to this solicitor.	NUMBER	AFRCSLT	AFRCSLT_PIDM	NO	NO
SOLICTOR_STATUS	Current solicitor status with this campaign.	VARCHAR2(63)	AFRCSLT	AFRCSLT_SSTA_CODE	NO	NO
SOLICTOR_STATUS_DATE	Date when the status was assigned to the solicitor.	DATE	AFRCSLT	AFRCSLT_SSTA_DATE	NO	NO
SOLICTOR_STATUS_DESC	Solicitor status description.	VARCHAR2(255)	ATVSSTA	ATVSSTA_DESC	NO	NO

Ver: 9.2