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

SGHE Banner Operational Data Store
Reporting View Target: SOLICITOR_ORG_FUNDRAISER

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

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

NVL(ASRSORG_UPD_WEB_IND)

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 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 Percent Progress 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 Percent Solc Program Organization 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 Percent Solicitor Progress Organization 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 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 Solicitor 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 Solicitor Percent Of Organization 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 Solicitor 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 Solicitor 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 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(63)  

ASRSORG

ASRSORG_ATYP_CODE

SOLICITOR_ADDRESS_TYPE_DESC Solicitor Address Type Description Address type description for the solicitor. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

SOLICITOR_CITY Solicitor City Address, city, town or municipality of the organization solicitor's address. VARCHAR2(63)  

SPRADDR

SPRADDR_CITY

SOLICITOR_COUNTY Solicitor County County of the organization solicitor's address. VARCHAR2(63)  

SPRADDR

SPRADDR_CNTY_CODE

SOLICITOR_COUNTY_DESC Solicitor County Description County description of the organization solicitor's address. VARCHAR2(255)  

STVCNTY

STVCNTY_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_ID Solicitor ID Solicitor's current identification number. VARCHAR2(63)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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_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_NATION Solicitor Nation Nation/country code of the organization solicitor's address. VARCHAR2(63)  

SPRADDR

SPRADDR_NATN_CODE

SOLICITOR_NATION_DESC Solicitor Nation Description Address nation/county description of the organization solicitor's address. VARCHAR2(255)  

STVNATN

STVNATN_NATION

SOLICITOR_ORGANIZATION Solicitor Organization Solicitor organization code. VARCHAR2(63)  

ASRSORG

ASRSORG_SOL_ORG

SOLICITOR_ORGANIZATION_NAME Solicitor Organization Name Solicitor organization name. VARCHAR2(255)  

ASBSORG

ASBSORG_NAME

SOLICITOR_OUTRIGHT_GIFTS 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 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 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 Solicitor Percent Of Organization 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 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 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 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 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 Solicitor Postal Code Address postal code associated with the organization solicitor's address. VARCHAR2(63)  

SPRADDR

SPRADDR_ZIP

SOLICITOR_STATE_PROVINCE Solicitor State Province State or province of the organization solicitor's address. VARCHAR2(63)  

SPRADDR

SPRADDR_STAT_CODE

SOLICITOR_STATE_PROVINCE_DESC Solicitor State Province Description State/province description of the organization solicitor's address. VARCHAR2(255)  

STVSTAT

STVSTAT_DESC

SOLICITOR_STATUS Solictor Status Current solicitor status with this organization. VARCHAR2(63)  

ASRSORG

ASRSORG_SSTA_CODE

SOLICITOR_STATUS_DATE Solictor Status Date Date when the status was assigned to the solicitor DATE  

ASRSORG

ASRSORG_SSTA_DATE

SOLICITOR_STATUS_DESC Solictor Status Description Solicitor status description. VARCHAR2(255)  

ATVSSTA

ATVSSTA_DESC

SOLICITOR_STREET_LINE1 Solicitor Street Line 1 First line of the organization solicitor's address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE1

SOLICITOR_STREET_LINE2 Solicitor Street Line 2 Second line of the organization solicitor's address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE2

SOLICITOR_STREET_LINE3 Solicitor Street Line 3 Third line of the organization solicitor's address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE3

SOLICITOR_STREET_LINE4 Solicitor Street Line 4 Fourth line of the organization solicitor's address. VARCHAR2(255)  

SPRADDR

SPRADDR_STREET_LINE4

SOLICITOR_TOTAL_DONOR_COUNT 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 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 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 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 Solicitor Type Identifies the type of solicitor. VARCHAR2(63)  

ASRSORG

ASRSORG_SOLT_TYPE

SOLICITOR_TYPE_DESC Solicitor Type Description Solicitor type description. VARCHAR2(255)  

ATVSOTP

ATVSOTP_DESC

SOLICITOR_UID Solicitor UID System generated, unique, internal identification number assigned to this solicitor. NUMBER  

ASRSORG

ASRSORG_SOL_PIDM



Ver: 9.0