Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Advancement Reporting View Reports

Banner Operational Data Store
Reporting View Target: SOLICITOR_ORG_FUNDRAISER

Description Contains detail information for each solicitor assigned to the solicitor organization.
Key & Frequency One row per solicitor organization per solicitor.
Recommended Search Columns SOLICITOR_ORGANIZATION
ADDRESS_TYPE
SOLICITOR_ORGANIZATION, SOLICITOR_UID

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