Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

Banner Operational Data Store
Composite View Target: AA_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.

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

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)

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

AFRCSLT

AFRCSLT_CAMPAIGN

CAMPAIGN_SOLICITOR_GOAL Amount of the solicitor goal for this campaign. NUMBER

AFRCSLT

NVL(AFRSCLT_GOAL,0)

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

NA

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

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

AFRCSLT

AFRCSLT_MAX_CONTACTS

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

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

AFRCSLT

AFRCSLT_REPORT_TO_PIDM

SOLICITATION_TYPE Solicitation type code. VARCHAR2(15)

AFRCSLT

AFRCSLT_SOLC_CODE

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

AFRCSLT

AFRCSLT_ACTIVITY_DATE

SOLICITOR_ORGANIZATION Solicitor organization code. VARCHAR2(5)

AFRCSLT

AFRCSLT_SOL_ORG

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(1)

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(30)

ATVSSTA

ATVSSTA_DESC

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

NA

NA



Ver: