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
ADDRESS_TYPE
SOLICITOR_ORGANIZATION, SOLICITOR_UID

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACTIVE_SOLICITOR_IND Solicitor status active indicator. Determines if the status is active (Y)es, or inactive (N)o.    

ATVSSTA

ATVSSTA_ACTIVE_IND

 
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

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.    

CALCULATION

NVL(ASRSORG_UPD_WEB_IND)

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

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.    

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.    

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.    

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.    

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.    

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.    

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.    

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.    

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.    

FUNCTION

MAKFUNC.F_SOL_FR_PD_PAID_COUNT

 
SOLICITOR_ACTIVITY_DATE Date information for this record in the table was entered or last updated.    

ASRSORG

ASRSOAG_ACTIVITY_DATE

 
SOLICITOR_ADDRESS_TYPE Type of address for the solicitor.    

ASRSORG

ASRSORG_ATYP_CODE

 
SOLICITOR_ADDRESS_TYPE_DESC Address type description for the solicitor.    

FUNCTION

GOKODSF.F_GET_DESC

 
SOLICITOR_CITY Address, city, town or municipality of the organization solicitor's address.    

SPRADDR

SPRADDR_CITY

 
SOLICITOR_COUNTY County of the organization solicitor's address.    

SPRADDR

SPRADDR_CNTY_CODE

 
SOLICITOR_COUNTY_DESC County description of the organization solicitor's address.    

STVCNTY

STVCNTY_DESC

 
SOLICITOR_DONOR_COUNT_GOAL Solicitor's goal for the number of donors for the year.    

ASRSORG

NVL(ASRSORG_DONOR_COUNT_GOAL,0)

 
SOLICITOR_GOAL Amount of the solicitor goal for the organization.    

ASRSORG

NVL(ASRSORG_DOLLAR_GOAL,0)

 
SOLICITOR_ID Solicitor's current identification number.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
SOLICITOR_MAX_CONTACT_COUNT Maximum number of contacts that can be assigned to the solicitor.    

ASRSORG

NVL(ASRSORG_MAX_CONTACTS,0)

 
SOLICITOR_NAME Name of the solicitor (last name, first name, middle initial) or organization name.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
SOLICITOR_NATION Nation/country code of the organization solicitor's address.    

SPRADDR

SPRADDR_NATN_CODE

 
SOLICITOR_NATION_DESC Address nation/county description of the organization solicitor's address.    

STVNATN

STVNATN_NATION

 
SOLICITOR_ORGANIZATION Solicitor organization code.    

ASRSORG

ASRSORG_SOL_ORG

 
SOLICITOR_ORGANIZATION_NAME Solicitor organization name.    

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.    

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.    

FUNCTION

MAKFUNC.F_SOL_FR_OUTRIGHT_GIFT_COUNT

 
SOLICITOR_PARTICIPATION_GOAL Solicitor���s goal for percentage of contacts who are expected to donate.    

ASRSORG

NVL(ASRSORG_PARTICIPATION_GOAL,0)

 
SOLICITOR_PCT_OF_ORG_GOAL Percentage of the overall solicitor organization goal this solicitor's goal represents.    

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.    

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.    

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.    

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.    

FUNCTION

MAKFUNC.F_SOL_FR_PLEDGE_PAYMENTS

 
SOLICITOR_POSTAL_CODE Address postal code associated with the organization solicitor's address.    

SPRADDR

SPRADDR_ZIP

 
SOLICITOR_STATE_PROVINCE State or province of the organization solicitor's address.    

SPRADDR

SPRADDR_STAT_CODE

 
SOLICITOR_STATE_PROVINCE_DESC State/province description of the organization solicitor's address.    

STVSTAT

STVSTAT_DESC

 
SOLICITOR_STATUS Current solicitor status with this organization.    

ASRSORG

ASRSORG_SSTA_CODE

 
SOLICITOR_STATUS_DATE Date when the status was assigned to the solicitor    

ASRSORG

ASRSORG_SSTA_DATE

 
SOLICITOR_STATUS_DESC Solicitor status description.    

ATVSSTA

ATVSSTA_DESC

 
SOLICITOR_STREET_LINE1 First line of the organization solicitor's address.    

SPRADDR

SPRADDR_STREET_LINE1

 
SOLICITOR_STREET_LINE2 Second line of the organization solicitor's address.    

SPRADDR

SPRADDR_STREET_LINE2

 
SOLICITOR_STREET_LINE3 Third line of the organization solicitor's address.    

SPRADDR

SPRADDR_STREET_LINE3

 
SOLICITOR_STREET_LINE4 Fourth line of the organization solicitor's address.    

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.    

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.    

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.    

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.    

FUNCTION

MAKFUNC.F_SOL_FR_TOTAL_PLEDGES

 
SOLICITOR_TYPE Identifies the type of solicitor.    

ASRSORG

ASRSORG_SOLT_TYPE

 
SOLICITOR_TYPE_DESC Solicitor type description.    

ATVSOTP

ATVSOTP_DESC

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

ASRSORG

ASRSORG_SOL_PIDM

 


Ver: 8.3