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_ORGANIZATION

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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACTIVE_ORGANIZATION_IND Organization status active indicator. Determines if the status is active (Y)es, or inactive (N)o.    

ATVSSTA

ATVSSTA_ACTIVE_IND

 
ALLOW_WEB_UPDATE_IND Determines if the organization can be updated via the web. (Y)es, the organization can be updated via the web, (N)o, the organization cannot be updated via the web.    

CALCULATION

NVL(ASBSORG_UPD_WEB_IND)

 
COLLEGE College associated with the solicitor organization.    

ASBSORG

ASBSORG_COLL_CODE

 
COLLEGE_DESC SolicOrganization college description.    

FUNCTION

GOKODSF.F_GET_DESC

 
CONTACT_ADDRESS_TYPE Type of address for the contact.    

ASBSORG

ASBSORG_ATYP_CODE

 
CONTACT_ADDRESS_TYPE_DESC Address type description for the contact.    

FUNCTION

GOKODSF.F_GET_DESC

 
CONTACT_ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity.    

ASBSORG

ASBSORG_CONTACT_PIDM

 
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 Solicitor organization year.    

ASBSORG

ASBSORG_YEAR

 
GIFT_SOCIETY_YEAR_DESC Gift society club year description.    

ATVDCYR

ATVDCYR_DESC

 
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

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

ASBSORG

ASBSORG_ACTIVITY_DATE

 
ORGANIZATION_DONOR_COUNT_GOAL Solicitor organization's goal for the number of donors for the year.    

CALCULATION

NVL(ASBSORG_DONOR_COUNT_GOAL,)

 
ORGANIZATION_GOAL Amount of the solicitor organization goal.    

CALCULATION

NVL(ASBSORG_DOLLAR_GOAL,)

 
ORGANIZATION_STATUS Current organization status.    

ASBSORG

ASBSORG_SSTA_CODE

 
ORGANIZATION_STATUS_DESC Organization status description.    

ATVSSTA

ATVSSTA_DESC

 
ORGANIZATION_TYPE Identifies the type of solicitor organization.    

ASBSORG

ASBSORG_SOTP_TYPE

 
ORGANIZATION_TYPE_DESC Solicitor organization type description.    

ATVSOTP

ATVSOTP_DESC

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

CALCULATION

NVL=(ASBSORG_PARTICIPATION_GOAL,0)

 
SOLICITOR_ORGANIZATION Solicitor organization code.    

ASBSORG

ASBSORG_SOL_ORG

 
SOLICITOR_ORGANIZATION_NAME Solicitor organization name.    

ASBSORG

ASBSORG_NAME

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

NA

NA

 


Ver: 8.3