Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Advancement Reporting View Reports

Banner Operational Data Store
Reporting View Target: 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.
Recommended Search Columns SOLICITOR_ORGANIZATION, CONTACT_ENTITY_UID
ADDRESS_TYPE
ENTITY_UID, ADDRESS_TYPE

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

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

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(63)

ASBSORG

ASBSORG_COLL_CODE

COLLEGE_DESC SolicOrganization college description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

ASBSORG

ASBSORG_ATYP_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

CONTACT_CITY Address, city, town or municipality of the organization contact's address. VARCHAR2(63)

SPRADDR

SPRADDR_CITY

CONTACT_COUNTY County of the organization contact's address. VARCHAR2(63)

SPRADDR

SPRADDR_CNTY_CODE

CONTACT_COUNTY_DESC County description of the organization contact's address. VARCHAR2(255)

STVCNTY

STVCNTY_DESC

CONTACT_ENTITY_IND Indicates whether the contact entity is a person or an organization. VARCHAR2(1)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

ASBSORG

ASBSORG_CONTACT_PIDM

CONTACT_ID Current identification number for the contact person or organization. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

CONTACT_NAME Name of the person or organization to contact (last name, first name, middle initial). VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

CONTACT_NATION Nation/country code of the organization contact's address. VARCHAR2(63)

SPRADDR

SPRADDR_NATN_CODE

CONTACT_NATION_DESC Address nation/county description of the organization contact's address. VARCHAR2(255)

STVNATN

STVNATN_NATION

CONTACT_POSTAL_CODE Address postal code associated with the organization contact's address. VARCHAR2(63)

SPRADDR

SPRADDR_ZIP

CONTACT_STATE_PROVINCE State or province of the organization contact's address. VARCHAR2(63)

SPRADDR

SPRADDR_STAT_CODE

CONTACT_STATE_PROVINCE_DESC State/province description of the organization contact's address. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

CONTACT_STREET_LINE1 First line of the organization contact's address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE1

CONTACT_STREET_LINE2 Second line of the organization contact's address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE2

CONTACT_STREET_LINE3 Third line of the organization contact's address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE3

CONTACT_STREET_LINE4 Fourth line of the organization contact's address. VARCHAR2(255)

SPRADDR

SPRADDR_STREET_LINE4

GIFT_SOCIETY_YEAR Solicitor organization year. VARCHAR2(63)

ASBSORG

ASBSORG_YEAR

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

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,0)

ORGANIZATION_GOAL Amount of the solicitor organization goal. NUMBER

CALCULATION

NVL(ASBSORG_DOLLAR_GOAL,0)

ORGANIZATION_OUTRIGHT_GIFTS Total amount of outright gifts received as a result of this solicitor organization. NUMBER

FUNCTION

MAKFUNC.F_ORG_OUTRIGHT_GIFTS

ORGANIZATION_PLEDGE_BALANCE Total amount of outstanding pledges made as a result of this solicitor organization. NUMBER

CALCULATION

MAKFUNC.F_ORG_TOTAL_PLEDGES - MAKFUNC.F_ORG_PLEDGE_PAYMENTS

ORGANIZATION_PLEDGE_COUNT Total number of pledges made as a result of this solicitor organization. NUMBER

FUNCTION

MAKFUNC.F_ORG_PLEDGE_COUNT

ORGANIZATION_PLEDGE_PAYMENTS Total amount of pledge payments received as a result of this solicitor organization. NUMBER

FUNCTION

MAKFUNC.F_ORG_PLEDGE_PAYMENTS

ORGANIZATION_STATUS Current organization status. VARCHAR2(63)

ASBSORG

ASBSORG_SSTA_CODE

ORGANIZATION_STATUS_DESC Organization status description. VARCHAR2(255)

ATVSSTA

ATVSSTA_DESC

ORGANIZATION_TOTAL_DONOR_COUNT Total number of donors who have made one or more gifts as a result of this solicitor organization. This includes donors who have received hard credit from gifts and includes pledges made with no payment received to date. NUMBER

FUNCTION

MAKFUNC.F_ORG_TOTAL_DONOR_COUNT

ORGANIZATION_TOTAL_GIFTS Total amount of gifts received as a result of this solicitor organization. This includes pledge payments and outright gifts. NUMBER

FUNCTION

MAKFUNC.F_ORG_TOTAL_GIFTS

ORGANIZATION_TOTAL_GIFT_COUNT Total number of gifts made to this solicitor organization. This includes both payments and outright gifts. NUMBER

FUNCTION

MAKFUNC.F_ORG_TOTAL_GIFT_COUNT

ORGANIZATION_TOTAL_PLEDGES Total amount of pledges made as a result of this solicitor organization. NUMBER

FUNCTION

MAKFUNC.F_ORG_TOTAL_PLEDGES

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

ASBSORG

ASBSORG_SOTP_TYPE

ORGANIZATION_TYPE_DESC Solicitor organization type description. VARCHAR2(255)

ATVSOTP

ATVSOTP_DESC

ORG_OUTRIGHT_GIFT_COUNT Total number of outright gifts made to this solicitor organization. NUMBER

FUNCTION

MAKFUNC.F_ORG_OUTRIGHT_GIFT_COUNT

ORG_OUTRIGHT_GIFT_DONOR_COUNT Total number of donors who made one or more outright gifts to this solicitor organization. NUMBER

FUNCTION

MAKFUNC.F_ORG_OUTRIGHT_DONOR_COUNT

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

CALCULATION

NVL=(ASBSORG_PARTICIPATION_GOAL,0)

ORG_PLEDGE_DONOR_COUNT Total number of donors who made one or more pledges as a result of this solicitor organization. This includes original donors and any individuals who received hard credit. NUMBER

FUNCTION

MAKFUNC.F_ORG_PLEDGE_DONOR_COUNT

ORG_PLEDGE_DONOR_NO_PAY_COUNT Total number of donors who have not made any payments toward their pledges to this solicitor organization. NUMBER

FUNCTION

MAKFUNC.F_ORG_PLEDGE_DONOR_NP_COUNT

ORG_PLEDGE_DONOR_PAID_COUNT Total number of donors who have made payments toward their pledges for this solicitor organization. This could be fully paid or partial paid. NUMBER

FUNCTION

MAKFUNC.F_ORG_TOTAL_DONOR_COUNT

PCT_PROGRESS_DONOR_COUNT_GOAL Percentage of the solicitor organization's donor count goal that has been reached by the sum of all donors for gifts and or outstanding pledges. NUMBER

CALCULATION

MAKFUNC.F_ORG_TOTAL_DONOR_COUNT / ORGANIZATION_DONOR_COUNT_GOAL * 100

PCT_PROGRESS_ORGANIZATION_GOAL Percentage of the solicitor organization goal that has been reached by the sum of gifts and outstanding pledges. NUMBER

CALCULATION

(MAKFUNC.F_ORG_TOTAL_GIFTS + MAKFUNC.F_ORG_TOTAL_PLEDGES - MAKFUNC.F_ORG_PLEDGE_PAYMENTS) / ORGANIZATION_GOAL * 100

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

NA

NA

SOLICITOR_ORGANIZATION Solicitor organization code. VARCHAR2(63)

ASBSORG

ASBSORG_SOL_ORG

SOLICITOR_ORGANIZATION_NAME Solicitor organization name. VARCHAR2(255)

ASBSORG

ASBSORG_NAME



Ver: 9.1