Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
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
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
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
CAMPAIGN	Campaign	User defined code for a campaign.	VARCHAR2(63)		AFRCSLT	AFRCSLT_CAMPAIGN
CAMPAIGN_NAME	Campaign Name	Campaign name.	VARCHAR2(255)		AFBCAMP	AFBCAMP_NAME
CAMPAIGN_SOLICITOR_GOAL	Campaign Solicitor Goal	Amount of the solicitor goal for this campaign.	NUMBER		AFRCSLT	NVL(AFRSCLT_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
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
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
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
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
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
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
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
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
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
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
MAXIMUM_ASSIGNED_CONTACT_COUNT	Maximum Assigned Contact Count	Maximum number of contacts that can be assigned to the solicitor.	NUMBER		AFRCSLT	AFRCSLT_MAX_CONTACTS
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_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
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
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
REPORT_TO_ID	Report To ID	Report to solicitor current identification number.	VARCHAR2(63)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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
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
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
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
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
SOLICITATION_TYPE	Solicitation Type	Solicitation type code.	VARCHAR2(63)		AFRCSLT	AFRCSLT_SOLC_CODE
SOLICITATION_TYPE_DESC	Solicitation Type Description	Solicitation type description.	VARCHAR2(255)		ATVSOLC	ATVSOLC_DESC
SOLICITOR_ACTIVITY_DATE	Solicitor Activity Date	Date information for this record in the table was entered or last updated.	DATE		AFRCSLT	AFRCSLT_ACTIVITY_DATE
SOLICITOR_ID	Solicitor ID	Solicitor's current identification number.	VARCHAR2(63)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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
SOLICITOR_ORGANIZATION	Solicitor Organization	Solicitor organization code.	VARCHAR2(63)		AFRCSLT	AFRCSLT_SOL_ORG
SOLICITOR_ORGANIZATION_NAME	Solicitor Organization Name	Solicitor organization name.	VARCHAR2(255)		ASBSORG	ASBSORG_NAME
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)
SOLICITOR_UID	Solicitor UID	System generated, unique, internal identification number assigned to this solicitor.	NUMBER		AFRCSLT	AFRCSLT_PIDM
SOLICTOR_STATUS	Solictor Status	Current solicitor status with this campaign.	VARCHAR2(63)		AFRCSLT	AFRCSLT_SSTA_CODE
SOLICTOR_STATUS_DATE	Solictor Status Date	Date when the status was assigned to the solicitor	DATE		AFRCSLT	AFRCSLT_SSTA_DATE
SOLICTOR_STATUS_DESC	Solictor Status Description	Solicitor status description.	VARCHAR2(255)		ATVSSTA	ATVSSTA_DESC

Ver: 9.0