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

SGHE 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 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

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)

CAMPAIGN Campaign User defined code for a campaign. VARCHAR2(5)  

AFRCSLT

AFRCSLT_CAMPAIGN

CAMPAIGN_SOLICITOR_GOAL Campaign Solicitor Goal Amount of the solicitor goal for this campaign. NUMBER  

AFRCSLT

NVL(AFRSCLT_GOAL,0)

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

NA

NA

DOMAIN_VALUE 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 Assigned Contact Count Maximum number of contacts that can be assigned to the solicitor. NUMBER(3)  

AFRCSLT

AFRCSLT_MAX_CONTACTS

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

NA

NA

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

NA

NA

REPORT_TO_UID Report To UID Solicitor unique identification to report to that is one level higher in the organization hierarchy. NUMBER(8)  

AFRCSLT

AFRCSLT_REPORT_TO_PIDM

SOLICITATION_TYPE Solicitation Type Solicitation type code. VARCHAR2(15)  

AFRCSLT

AFRCSLT_SOLC_CODE

SOLICITOR_ACTIVITY_DATE 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 Solicitor organization code. VARCHAR2(5)  

AFRCSLT

AFRCSLT_SOL_ORG

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

AFRCSLT

AFRCSLT_PIDM

SOLICTOR_STATUS Solictor Status Current solicitor status with this campaign. VARCHAR2(1)  

AFRCSLT

AFRCSLT_SSTA_CODE

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

AFRCSLT

AFRCSLT_SSTA_DATE

SOLICTOR_STATUS_DESC Solictor Status Description Solicitor status description. VARCHAR2(30)  

ATVSSTA

ATVSSTA_DESC

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

NA

NA



Ver: