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

Banner Operational Data Store
Composite View Target: AA_SOLICITOR_ORG_FUNDRAISER

Description Contains detail information for each solicitor assigned to the solictor organization.
Key & Frequency One row per solicitor organization per solicitor.

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)

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

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

PCT_PROG_SOLICITOR_DONOR_GOAL Percentage of progress toward the solicitor donor count goal. NUMBER

CONSTANT

FUNCTION

0

TO BE FILLED IN BY DEVELOPER

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

ASRSORG

ASRSOAG_ACTIVITY_DATE

SOLICITOR_ADDRESS_TYPE Type of address for the solicitor. VARCHAR2(2)

ASRSORG

ASRSORG_ATYP_CODE

SOLICITOR_ADDRESS_TYPE_DESC Address type description for the solicitor. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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 Amount of the solicitor goal for the organization. NUMBER

ASRSORG

NVL(ASRSORG_DOLLAR_GOAL,0)

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

ASRSORG

NVL(ASRSORG_MAX_CONTACTS,0)

SOLICITOR_ORGANIZATION Solicitor organization code. VARCHAR2(5)

ASRSORG

ASRSORG_SOL_ORG

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

ASRSORG

NV(ASRSORG_PARTICIPATION_GOAL,0)

SOLICITOR_TYPE Identifies the type of solicitor. VARCHAR2(4)

ASRSORG

ASRSORG_SOLT_TYPE

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

ASRSORG

ASRSORG_SOL_PIDM

SOLICTOR_STATUS Current solicitor status with this organization. VARCHAR2(1)

ASRSORG

ASRSORG_SSTA_CODE

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

ASRSORG

ASRSORG_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: