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

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

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

 
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)

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

 
PCT_PROG_SOLICITOR_DONOR_GOAL Percentage of progress toward the solicitor donor count goal.    

FUNCTION

TO BE FILLED IN BY DEVELOPER

 
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_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_MAX_CONTACT_COUNT Maximum number of contacts that can be assigned to the solicitor.    

ASRSORG

NVL(ASRSORG_MAX_CONTACTS,0)

 
SOLICITOR_ORGANIZATION Solicitor organization code.    

ASRSORG

ASRSORG_SOL_ORG

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

ASRSORG

NV(ASRSORG_PARTICIPATION_GOAL,0)

 
SOLICITOR_TYPE Identifies the type of solicitor.    

ASRSORG

ASRSORG_SOLT_TYPE

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

ASRSORG

ASRSORG_SOL_PIDM

 
SOLICTOR_STATUS Current solicitor status with this organization.    

ASRSORG

ASRSORG_SSTA_CODE

 
SOLICTOR_STATUS_DATE Date when the status was assigned to the solicitor    

ASRSORG

ASRSORG_SSTA_DATE

 
SOLICTOR_STATUS_DESC Solicitor status description.    

ATVSSTA

ATVSSTA_DESC

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

NA

NA

 


Ver: 8.3