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

SGHE Banner Operational Data Store
Composite View Target: AA_SOL_ORG_FUNDRAISER_GOAL

Description Contains detail information for each solicitor within an organization, who the contact is, participation goal, dollar goal, and anticipated donor count.
Key & Frequency One row per solicitor organization per solicitor uid per year.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
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

 
GIFT_SOCIETY_YEAR Gift society year for the solicitor organization's annual goal.    

ASRSSAG

ASRSSAG_DCYR_CODE

 
GIFT_SOCIETY_YEAR_DESC Gift society club year description.    

ATVDCYR

ATVDCYR_DESC

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

ASRSSAG

ASRSSAG_MAX_CONTACTS

 
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

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

ASRSSAG

ASRSSAG_REPORT_TO_PIDM

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

ASRSSAG

ASRSSAG_ACTIVITY_DATE

 
SOLICITOR_DONOR_COUNT_GOAL Solicitor's annual goal for the number of donors for gifts.    

ASRSSAG

ASRSSAG_DONOR_COUNT_GOAL

 
SOLICITOR_GOAL Amount of the solicitor annual goal for the gift society.    

ASRSSAG

ASRSSAG_DOLLAR_GOAL

 
SOLICITOR_ORGANIZATION Solicitor organization code.    

ASRSSAG

ASRSSAG_SOL_ORG

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

ASRSSAG

ASRSSAG_PARTICIPATION_GOAL

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

ASRSSAG

ASRSSAG_PIDM

 
SOLICITOR_USER_ID Unique identification code of the user who entered or last touched the transaction.    

ASRSSAG

ASRSSAG_USER

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

NA

NA

 


Ver: 8.3