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
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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)
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PCT_PROGRESS_SOLICITOR_GOAL	Percentage progress toward the solicitor goal for this organization represented by the gift amount received for this solicitor. This includes the outstanding pledge balance.	NUMBER	FUNCTION	(MAKFUNC.F_SOL_FR_TOTAL_PLEDGES + MAKFUNC.F_SOL_FR_TOTAL_GIFTS + MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS) / SOLICITOR_GOAL * 100
PCT_PROG_SOLICITOR_DONOR_GOAL	Percentage of progress toward the solicitor donor count goal.	NUMBER	FUNCTION	MAKFUNC.F_SOL_FR_TOTAL_DONOR_COUNT/SOLICITOR_DONOR_COUNT_GOAL
PCT_SOLC_PROG_ORG_DONOR_GOAL	Percentage of progress toward the organization donor count goal represented by the count of donors for this solicitor.	NUMBER	FUNCTION	MAKFUNC.F_SOL_FR_TOTAL_DONOR_COUNT/ORGANIZATION_DONOR_COUNT_GOAL
PCT_SOLICITOR_PROG_ORG_GOAL	Percentage of progress toward the organization goal represented by the gift amount received for this solicitor. This includes the outstanding pledge balance.	NUMBER	CALCULATION	(MAKFUNC.F_SOL_FR_TOTAL_PLEDGES + MAKFUNC.F_SOL_FR_TOTAL_GIFTS + MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS) / ORGANIZATION_GOAL * 100
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
SOLC_OUTRIGHT_GIFT_DONOR_COUNT	Total number of donors who made one or more outright gifts to this fundraiser for a solicitor organization and or type of solicitation regardless of campaign.	NUMBER	FUNCTION	MAKFUNC.F_SOL_FR_OUTRIGHT_GD_COUNT
SOLC_PERCENT_OF_ORG_DONOR_GOAL	Percentage of the overall solicitor organization donor count goal this solicitor's donor count goal represents.	NUMBER	ASRSORG	ASRSORG_DONOR_COUNT_GOAL/ASBSORG_DONOR_COUNT_GOAL * 100
SOLC_PLEDGE_DONOR_NO_PAY_COUNT	Total number of donors who have not made any payments toward their pledges to this fundraiser for a solicitor organization and or type of solicitation regardless of campaign.	NUMBER	FUNCTION	MAKFUNC.F_SOL_FR_PD_NP_COUNT
SOLC_PLEDGE_DONOR_PAID_COUNT	Total number of donors who have made payments toward their pledges for this fundraiser for a solicitor organization and or type of solicitation regardless of campaign. This could be fully paid or partial paid.	NUMBER	FUNCTION	MAKFUNC.F_SOL_FR_PD_PAID_COUNT
SOLICITOR_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	ASRSORG	ASRSOAG_ACTIVITY_DATE
SOLICITOR_ADDRESS_TYPE	Type of address for the solicitor.	VARCHAR2(63)	ASRSORG	ASRSORG_ATYP_CODE
SOLICITOR_ADDRESS_TYPE_DESC	Address type description for the solicitor.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
SOLICITOR_CITY	Address, city, town or municipality of the organization solicitor's address.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY
SOLICITOR_COUNTY	County of the organization solicitor's address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
SOLICITOR_COUNTY_DESC	County description of the organization solicitor's address.	VARCHAR2(255)	STVCNTY	STVCNTY_DESC
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	Amount of the solicitor goal for the organization.	NUMBER	ASRSORG	NVL(ASRSORG_DOLLAR_GOAL,0)
SOLICITOR_ID	Solicitor's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
SOLICITOR_MAX_CONTACT_COUNT	Maximum number of contacts that can be assigned to the solicitor.	NUMBER	ASRSORG	NVL(ASRSORG_MAX_CONTACTS,0)
SOLICITOR_NAME	Name of the solicitor (last name, first name, middle initial) or organization name.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
SOLICITOR_NATION	Nation/country code of the organization solicitor's address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
SOLICITOR_NATION_DESC	Address nation/county description of the organization solicitor's address.	VARCHAR2(255)	STVNATN	STVNATN_NATION
SOLICITOR_ORGANIZATION	Solicitor organization code.	VARCHAR2(63)	ASRSORG	ASRSORG_SOL_ORG
SOLICITOR_ORGANIZATION_NAME	Solicitor organization name.	VARCHAR2(255)	ASBSORG	ASBSORG_NAME
SOLICITOR_OUTRIGHT_GIFTS	Total amount of outright gifts received as a result of this fundraiser for a solicitor organization and or type of solicitation regardless of campaign.	NUMBER	FUNCTION	MAKFUNC.F_SOL_FR_OUTRIGHT_GIFTS
SOLICITOR_OUTRIGHT_GIFT_COUNT	Total number of outright gifts made to this fundraiser for a solicitor organization and or type of solicitation regardless of campaign.	NUMBER	FUNCTION	MAKFUNC.F_SOL_FR_OUTRIGHT_GIFT_COUNT
SOLICITOR_PARTICIPATION_GOAL	Solicitor's goal for percentage of contacts who are expected to donate.	NUMBER	ASRSORG	NVL(ASRSORG_PARTICIPATION_GOAL,0)
SOLICITOR_PCT_OF_ORG_GOAL	Percentage of the overall solicitor organization goal this solicitor's goal represents.	NUMBER	CALCULATION	ASRSORG_DOLLAR_GOAL / ASBSORG_DOLLAR_GOAL * 100
SOLICITOR_PLEDGE_BALANCE	Total amount of outstanding pledges made as a result of this fundraiser for a solicitor organization and or type of solicitation regardless of campaign.	NUMBER	CALCULATION	MAKFUNC.F_SOL_FR_TOTAL_PLEDGES - MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS
SOLICITOR_PLEDGE_COUNT	Total number of pledges made as a result of this fundraiser for a solicitor organization and or type of solicitation regardless of campaign.	NUMBER	FUNCTION	MAKFUNC.F_SOL_FR_PLEDGE_COUNT
SOLICITOR_PLEDGE_DONOR_COUNT	Total number of donors who made one or more pledges as a result of this fundraiser for a solicitor organization and or type of solicitation regardless of campaign. This includes original donors and any individuals who received hard credit.	NUMBER	FUNCTION	MAKFUNC.F_SOL_FR_PLEDGE_DONOR_COUNT
SOLICITOR_PLEDGE_PAYMENTS	Total amount of pledge payments received as a result of this fundraiser for a solicitor organization and or type of solicitation regardless of campaign.	NUMBER	FUNCTION	MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS
SOLICITOR_POSTAL_CODE	Address postal code associated with the organization solicitor's address.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
SOLICITOR_STATE_PROVINCE	State or province of the organization solicitor's address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
SOLICITOR_STATE_PROVINCE_DESC	State/province description of the organization solicitor's address.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC
SOLICITOR_STATUS	Current solicitor status with this organization.	VARCHAR2(63)	ASRSORG	ASRSORG_SSTA_CODE
SOLICITOR_STATUS_DATE	Date when the status was assigned to the solicitor.	DATE	ASRSORG	ASRSORG_SSTA_DATE
SOLICITOR_STATUS_DESC	Solicitor status description.	VARCHAR2(255)	ATVSSTA	ATVSSTA_DESC
SOLICITOR_STREET_LINE1	First line of the organization solicitor's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1
SOLICITOR_STREET_LINE2	Second line of the organization solicitor's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
SOLICITOR_STREET_LINE3	Third line of the organization solicitor's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
SOLICITOR_STREET_LINE4	Fourth line of the organization solicitor's address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4
SOLICITOR_TOTAL_DONOR_COUNT	Total number of donors who have made one or more gifts as a result of this fundraiser for a solicitor organization and or type of solicitation regardless of campaign. This includes donors who have received hard credit from gifts and includes pledges made with no payment received to date.	NUMBER	FUNCTION	MAKFUNC.F_SOL_FR_TOTAL_DONOR_COUNT
SOLICITOR_TOTAL_GIFTS	Total amount of gifts received as a result of this fundraiser for a solicitor organization and or type of solicitation regardless of campaign. This includes pledge payments and outright gifts.	NUMBER	FUNCTION	MAKFUNC.F_SOL_FR_TOTAL_GIFTS
SOLICITOR_TOTAL_GIFT_COUNT	Total number of gifts made to this solicitor fundraiser for a solicitor organization and or type of solicitation regardless of campaign. This includes both payments and outright gifts.	NUMBER	FUNCTION	MAKFUNC.F_SOL_FR_TOTAL_GIFT_COUNT
SOLICITOR_TOTAL_PLEDGES	Total amount of pledges made as a result of this fundraiser for a solicitor organization and or type of solicitation regardless of campaign.	NUMBER	FUNCTION	MAKFUNC.F_SOL_FR_TOTAL_PLEDGES
SOLICITOR_TYPE	Identifies the type of solicitor.	VARCHAR2(63)	ASRSORG	ASRSORG_SOLT_TYPE
SOLICITOR_TYPE_DESC	Solicitor type description.	VARCHAR2(255)	ATVSOTP	ATVSOTP_DESC
SOLICITOR_UID	System generated, unique, internal identification number assigned to this solicitor.	NUMBER	ASRSORG	ASRSORG_SOL_PIDM

Ver: 9.1