Target Column	Business Definition	Database Data Type	Source Name	Source Column
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
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	NVL(ASRSORG_UPD_WEB_IND)
CAMPAIGN	Campaign that the constituent has responded to with a gift or pledge payment.	VARCHAR2(5)	AFRCSLT	AFRCSLT_CAMPAIGN
CAMPAIGN_SOLICITOR_GOAL	Amount of the solicitor goal for this campaign.	NUMBER	AFRCSLT	NVL(AFRSCLT_GOAL,0)
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	NA
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA
MAXIMUM_ASSIGNED_CONTACT_COUNT	Maximum number of contacts that can be assigned to the solicitor.	NUMBER	AFRCSLT	AFRCSLT_MAX_CONTACTS
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
REPORT_TO_UID	Solicitor unique identification to report to that is one level higher in the organization hierarchy.	NUMBER	AFRCSLT	AFRCSLT_REPORT_TO_PIDM
SOLICITATION_TYPE	Solicitation type code.	VARCHAR2(15)	AFRCSLT	AFRCSLT_SOLC_CODE
SOLICITOR_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	AFRCSLT	AFRCSLT_ACTIVITY_DATE
SOLICITOR_ORGANIZATION	Solicitor organization code.	VARCHAR2(5)	AFRCSLT	AFRCSLT_SOL_ORG
SOLICITOR_UID	System generated, unique, internal identification number assigned to this solicitor.	NUMBER	AFRCSLT	AFRCSLT_PIDM
SOLICTOR_STATUS	Current solicitor status with this campaign.	VARCHAR2(1)	AFRCSLT	AFRCSLT_SSTA_CODE
SOLICTOR_STATUS_DATE	Date when the status was assigned to the solicitor.	DATE	AFRCSLT	AFRCSLT_SSTA_DATE
SOLICTOR_STATUS_DESC	Solicitor status description.	VARCHAR2(30)	ATVSSTA	ATVSSTA_DESC
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: