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.

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVE_ORGANIZATION_IND Organization status active indicator. Determines if the status is active (Y)es, or inactive (N)o. VARCHAR2(1)

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. VARCHAR2(1)

CALCULATION

NVL(ASBSORG_UPD_WEB_IND)

COLLEGE First level of the institution organization structure that owns the student or the academic instruction for a student course. VARCHAR2(2)

ASBSORG

ASBSORG_COLL_CODE

COLLEGE_DESC SolicOrganization college description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

CONTACT_ADDRESS_TYPE Type of address for the contact. VARCHAR2(2)

ASBSORG

ASBSORG_ATYP_CODE

CONTACT_ADDRESS_TYPE_DESC Address type description for the contact. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

ASBSORG

ASBSORG_CONTACT_PIDM

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

GIFT_SOCIETY_YEAR Solicitor organization year. VARCHAR2(4)

ASBSORG

ASBSORG_YEAR

GIFT_SOCIETY_YEAR_DESC Gift society club year description. VARCHAR2(30)

ATVDCYR

ATVDCYR_DESC

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

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

ASBSORG

ASBSORG_ACTIVITY_DATE

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

CALCULATION

NVL(ASBSORG_DONOR_COUNT_GOAL,)

ORGANIZATION_GOAL Amount of the solicitor organization goal. NUMBER

CALCULATION

NVL(ASBSORG_DOLLAR_GOAL,)

ORGANIZATION_STATUS Current organization status. VARCHAR2(1)

ASBSORG

ASBSORG_SSTA_CODE

ORGANIZATION_STATUS_DESC Organization status description. VARCHAR2(30)

ATVSSTA

ATVSSTA_DESC

ORGANIZATION_TYPE Identifies the type of solicitor organization. VARCHAR2(2)

ASBSORG

ASBSORG_SOTP_TYPE

ORGANIZATION_TYPE_DESC Solicitor organization type description. VARCHAR2(30)

ATVSOTP

ATVSOTP_DESC

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

CALCULATION

NVL=(ASBSORG_PARTICIPATION_GOAL,0)

SOLICITOR_ORGANIZATION Solicitor organization code. VARCHAR2(5)

ASBSORG

ASBSORG_SOL_ORG

SOLICITOR_ORGANIZATION_NAME Solicitor organization name. VARCHAR2(60)

ASBSORG

ASBSORG_NAME

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

NA

NA



Ver: