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
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	NVL(ASRSORG_UPD_WEB_IND)
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	NA
DOMAIN_VALUE	Domain Value	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
PCT_PROG_SOLICITOR_DONOR_GOAL	Percent Program Solicitor Donor Goal	Percentage of progress toward the solicitor donor count goal.	NUMBER		CONSTANT FUNCTION	0 TO BE FILLED IN BY DEVELOPER
SOLICITOR_ACTIVITY_DATE	Solicitor Activity Date	Date information for this record in the table was entered or last updated.	DATE		ASRSORG	ASRSOAG_ACTIVITY_DATE
SOLICITOR_ADDRESS_TYPE	Solicitor Address Type	Type of address for the solicitor.	VARCHAR2(2)		ASRSORG	ASRSORG_ATYP_CODE
SOLICITOR_ADDRESS_TYPE_DESC	Solicitor Address Type Description	Address type description for the solicitor.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
SOLICITOR_DONOR_COUNT_GOAL	Solicitor Donor Count Goal	Solicitor's goal for the number of donors for the year.	NUMBER		ASRSORG	NVL(ASRSORG_DONOR_COUNT_GOAL,0)
SOLICITOR_GOAL	Solicitor Goal	Amount of the solicitor goal for the organization.	NUMBER		ASRSORG	NVL(ASRSORG_DOLLAR_GOAL,0)
SOLICITOR_MAX_CONTACT_COUNT	Solicitor Maximum Contact Count	Maximum number of contacts that can be assigned to the solicitor.	NUMBER		ASRSORG	NVL(ASRSORG_MAX_CONTACTS,0)
SOLICITOR_ORGANIZATION	Solicitor Organization	Solicitor organization code.	VARCHAR2(5)		ASRSORG	ASRSORG_SOL_ORG
SOLICITOR_PARTICIPATION_GOAL	Solicitor Participation Goal	Solicitor's goal for percentage of contacts who are expected to donate.	NUMBER		ASRSORG	NV(ASRSORG_PARTICIPATION_GOAL,0)
SOLICITOR_TYPE	Solicitor Type	Identifies the type of solicitor.	VARCHAR2(4)		ASRSORG	ASRSORG_SOLT_TYPE
SOLICITOR_UID	Solicitor UID	System generated, unique, internal identification number assigned to this solicitor.	NUMBER(8)		ASRSORG	ASRSORG_SOL_PIDM
SOLICTOR_STATUS	Solictor Status	Current solicitor status with this organization.	VARCHAR2(1)		ASRSORG	ASRSORG_SSTA_CODE
SOLICTOR_STATUS_DATE	Solictor Status Date	Date when the status was assigned to the solicitor	DATE		ASRSORG	ASRSORG_SSTA_DATE
SOLICTOR_STATUS_DESC	Solictor Status Description	Solicitor status description.	VARCHAR2(30)		ATVSSTA	ATVSSTA_DESC
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: