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

SGHE Banner Operational Data Store
Reporting View Target: CAMPAIGN_FUNDRAISER

Description Contains detail information for each solicitor assigned to the campaign by solicitation type and or by solicitor organization or by neither.
Key & Frequency One row per campaign per solicitor type per solicitor organization per solicitor uid.
Recommended Search Columns CAMPAIGN_TYPE
SOLICITOR_ORGANIZATION
CAMPAIGN, SOLICITATION_TYPE, SOLICITOR_ORGANIZATION, SOLICITOR_UID
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

ASRSORG_UPD_WEB_IND

CAMPAIGN Campaign that the constituent has responded to with a gift or pledge payment. VARCHAR2(63)

AFRCSLT

AFRCSLT_CAMPAIGN

CAMPAIGN_NAME Campaign name. VARCHAR2(255)

AFBCAMP

AFBCAMP_NAME

CAMPAIGN_SOLICITOR_GOAL Amount of the solicitor goal for this campaign. NUMBER

AFRCSLT

NVL(AFRSCLT_GOAL,0)

CAMPAIGN_TYPE Type of campaign recorded. VARCHAR2(63)

AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Campaign type description. VARCHAR2(255)

ATVCMTP

ATVCMTP_DESC

CAMP_SOLC_OUTRIGHT_GIFT_COUNT Total number of outright gifts made to this campaign solicitor combination. NUMBER

FUNCTION

MAKFUNC.F_CAMP_SOL_OUTRIGHT_GC_COUNT

CAMP_SOLC_PLEDGE_DONOR_COUNT Total number of donors who made one or more pledges to this campaign solicitor combination. This includes original donors and any individuals who received hard credit. NUMBER

FUNCTION

MAKFUNC.F_CAMP_SOL_PLEDGE_DONOR_COUNT

CAMP_SOLC_TOTAL_DONOR_COUNT Total number of donors who have made one or more gifts to this campaign designation combination. This includes donors who have received hard credit from gifts and includes pledges made with no payment received to date. NUMBER

FUNCTION

MAKFUNC.F_CAMP_SOL_TOTAL_DONOR_COUNT

CAMP_SOLC_TOTAL_GIFT_COUNT Total number of gifts made to this campaign solicitor combination. This includes both payments and outright gifts. NUMBER

FUNCTION

MAKFUNC.F_CAMP_SOL_TOTAL_GIFT_COUNT

CAMP_SOLICITOR_OUTRIGHT_GIFTS Total amount received toward this campaign solicitor combination for outright gifts. NUMBER

FUNCTION

MAKFUNC.F_CAMP_SOL_OUTRIGHT_GIFTS

CAMP_SOLICITOR_PLEDGE_BALANCE Total amount of outstanding pledges for this campaign solicitor combination. NUMBER

FUNCTION

MAKFUNC.F_CAMP_SOL_TOTAL_PLEDGES - MAKFUNC.F_CAMP_SOL_PLEDGE_PAYMENTS

CAMP_SOLICITOR_PLEDGE_COUNT Total number of pledges made to this campaign solicitor combination. NUMBER

FUNCTION

MAKFUNC.F_CAMP_SOL_PLEDGE_COUNT

CAMP_SOLICITOR_PLEDGE_PAYMENTS Total amount of pledge payments made to this campaign solicitor combination. NUMBER

FUNCTION

MAKFUNC.F_CAMP_SOL_PLEDGE_PAYMENTS

CAMP_SOLICITOR_TOTAL_GIFTS Total amount of gifts received toward this campaign solicitor combination, including pledge payments and outright gifts. NUMBER

FUNCTION

MAKFUNC.F_CAMP_SOL_TOTAL_GIFTS

CAMP_SOLICITOR_TOTAL_PLEDGES Total amount of pledges made to this campaign solicitor combination. NUMBER

FUNCTION

MAKFUNC.F_CAMP_SOL_TOTAL_PLEDGES

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

AFRCSLT

AFRCSLT_MAX_CONTACTS

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 campaign represented by the gift amount received for this solicitor. This includes the outstanding pledge balance. NUMBER

EXPRESSION

NVL(CASE WHEN(CAMPAIGN_SOLICITOR_GOAL > 0

PCT_SOLC_PROGRESS_CAMP_GOAL Percentage of progress toward the campaign goal represented by the gift amount received for this solicitor. This includes the outstanding pledge balance. NUMBER

EXPRESSION

CASE WHEN (CAMPAIGN_GOAL > 0

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

REPORT_TO_ID Report to solicitor current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

REPORT_TO_NAME Report to solicitor name (last name, first name, middle initial) or organization name. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

REPORT_TO_UID Solicitor unique identification to report to that is one level higher in the organization hierarchy. NUMBER

AFRCSLT

AFRCSLT_REPORT_TO_PIDM

SOLC_OUTRIGHT_GIFT_DONOR_COUNT Total number of donors who made one or more outright gifts to this campaign solicitor combination. NUMBER

FUNCTION

MAKFUNC.F_CAMP_SOL_OUTRIGHT_GD_COUNT

SOLC_PLEDGE_DONOR_NO_PAY_COUNT Total number of donors who have not made any payments toward their pledges to this campaign solicitor combination. NUMBER

FUNCTION

MAKFUNC.F_CAMP_SOL_PD_NP_COUNT

SOLC_PLEDGE_DONOR_PAID_COUNT Total number of donors who have made payments toward their pledges to this campaign solicitor combination. This could be fully paid or partial paid. NUMBER

FUNCTION

MAKFUNC.F_CAMP_SOL_PD_PAID_COUNT

SOLICITATION_TYPE Solicitation type code. VARCHAR2(63)

AFRCSLT

AFRCSLT_SOLC_CODE

SOLICITATION_TYPE_DESC Solicitation type description. VARCHAR2(255)

ATVSOLC

ATVSOLC_DESC

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

AFRCSLT

AFRCSLT_ACTIVITY_DATE

SOLICITOR_ID Solicitor's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

SOLICITOR_ORGANIZATION Solicitor organization code. VARCHAR2(63)

AFRCSLT

AFRCSLT_SOL_ORG

SOLICITOR_ORGANIZATION_NAME Solicitor organization name. VARCHAR2(255)

ASBSORG

ASBSORG_NAME

SOLICITOR_PCT_OF_CAMPAIGN_GOAL Percentage of the overall campaign goal this solicitor goal represents. NUMBER

EXPRESSION

(CAMPAIGN_SOLICITOR_GOAL / CAMPAIGN_GOAL * 100)

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

AFRCSLT

AFRCSLT_PIDM

SOLICTOR_STATUS Current solicitor status with this campaign. VARCHAR2(63)

AFRCSLT

AFRCSLT_SSTA_CODE

SOLICTOR_STATUS_DATE Date when the status was assigned to the solicitor. DATE

AFRCSLT

AFRCSLT_SSTA_DATE

SOLICTOR_STATUS_DESC Solicitor status description. VARCHAR2(255)

ATVSSTA

ATVSSTA_DESC



Ver: 8.5