Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Advancement Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: ORGANIZATION_CONTACT

Description Contains information related to all contacts associated with an advancement organization including primary contact indicator, contact type, job category, title, name, primary address, phone and email.
Key & Frequency One row per entity per contact.
Recommended Search Columns ENTITY_UID

Target Column Business Definition Database Data Type Source Name Source Column
ADDRESS_COUNT Count of current active addresses for this person or entity. NUMBER

FUNCTION

MSKFUNC.F_COUNT_ADDRESSES

ADDRESS_TYPE Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent. VARCHAR2(63)

AORCONT

SPRADDR

AORCONT_ATYP_CODE

SPRADDR_ATYP_CODE

ADDRESS_TYPE_DESC Address type description. VARCHAR2(255)

STVATYP

STVATYP_DESC

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

NA

NA

CARRIER_ROUTE Address carrier route. VARCHAR2(63)

AORCONT

AORCONT_CARRIER_ROUTE

CITY Address city, town or municipality. VARCHAR2(255)

AORCONT

AORCONT_ADDR_CITY

CONTACT_FIRST_NAME Organizational contact's first name. VARCHAR2(255)

AORCONT

SPRIDEN

AORCONT_FIRST_NAME

SPRIDEN_FIRST_NAME

CONTACT_LAST_NAME Organizational contact's last name. VARCHAR2(255)

AORCONT

SPRIDEN

AORCONT_LAST_NAME

SPRIDEN_LAST_NAME

CONTACT_MIDDLE_INITIAL Organizational contact's middle initial. VARCHAR2(1)

AOBORGN

AORCONT

SPRIDEN

AOBORGN_MI_CONTACT

AORCONT_MI

SPRIDEN_MI

CONTACT_NAME_PREFIX Prefix used before a person's name. VARCHAR2(255)

AORCONT

SPBPERS

AORCONT_NAME_PREFIX

SPBPERS_NAME_PREFIX

CONTACT_NAME_SUFFIX Suffix for the person's name. VARCHAR2(255)

AORCONT

SPBPERS

AORCONT_NAME_SUFFIX

SPBPERS_NAME_SUFFIX

CONTACT_TYPE Type of contact between the institution and the organization. VARCHAR2(63)

AORCONT

AORCONT_OCON_CODE

CONTACT_TYPE_DESC Contact type description. VARCHAR2(255)

ATVOCON

ATVOCON_DESC

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

AORCONT

AORCONT_CONTACT_PIDM

CORRECTION_DIGIT Correction digit associated with the address for bar code mailing. NUMBER

AORCONT

SPRADDR

AORCONT_CORRECTION_DIGIT

SPRADDR_CORRECTION_DIGIT

COUNTY County for this address. VARCHAR2(63)

AORCONT

SPRADDR

AORCONT_CNTY_CODE_ADDR

SPRADDR_CNTY_CODE

COUNTY_DESC County name for the address. VARCHAR2(255)

STVCNTY

STVCNTY_DESC

DELIVERY_POINT Delivery point associated with the address for barcode mailings. NUMBER

AORCONT

SPRADDR

AORCONT_DELIVERY_POINT

SPRADDR_DELIVERY_POINT

EMAIL_ADDRESS Preferred email address. VARCHAR2(255)

GOREMAL

GOREMAL_EMAIL_ADDRESS

EMAIL_DESC Organization's preferred email type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EMAIL_TYPE Type of email address recorded. VARCHAR2(255)

GOREMAL

GOREMAL_EMAL_CODE

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

AOBORGN

AORCONT

AOBORGN_PIDM

AORCONT_PIDM

GEOGRAPHIC_REGION_COUNT Count of geographic regions associated with an address record. NUMBER

FUNCTION

MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS

ID Person's or organization's current identification number. VARCHAR2(9)

SPRIDEN

SPRIDEN_ID

JOB_CATEGORY Job category associated with the organizational contact's title. VARCHAR2(63)

AOBORGN

AORCONT

AOBORGN_JOBC_CODE

AORCONT_JOBC_CODE

JOB_CATEGORY_DESC Job category code description. VARCHAR2(255)

ATVJOBC

ATVJOBC_DESC

JOB_TITLE Organizational contact's job title. VARCHAR2(255)

AOBORGN

AORCONT

AOBORGN_TITLE_CONTACT

AORCONT_TITLE

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

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(63)

FUNCTION

F_FORMAT_NAME

NATION Address nation/country code. VARCHAR2(63)

AORCONT

SPRADDR

AORCONT_NATN_CODE_ADDR

SPRADDR_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(255)

STVNATN

STVNATN_NATION

PHONE_AREA Phone area code. VARCHAR2(63)

AORCONT

SPRTELE

AORCONT_PHONE_AREA

SPRTELE_PHONE_AREA

PHONE_COUNT Count of phone records. NUMBER

FUNCTION

MSKFUNC.F_COUNT_TELEPHONES

PHONE_DESC Telephone number type description. VARCHAR2(255)

STVTELE

STVTELE_DESC

PHONE_EXT Phone extension. VARCHAR2(63)

AORCONT

SPRTELE

AORCONT_PHONE_EXT

SPRTELE_PHONE_EXT

PHONE_NUMBER Phone number. VARCHAR2(63)

AORCONT

SPRTELE

AORCONT_PHONE_NUMBER

SPRTELE_PHONE_NUMBER

PHONE_NUMBER_COMBINED Organizational contact's telephone number. VARCHAR2(63)

CALCULATION

AORCONT_PHONE_AREA||AORCONT_PHONE_NUMBER||AORCONT_PHONE_EXT

SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA||SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT

PHONE_TYPE Telephone type code associated with the organization's preferred telephone number. VARCHAR2(255)

SPRTELE

SPRTELE_TELE_CODE

PHONE_UNLIST_IND Specifies if the phone number is unlisted. VARCHAR2(255)

SPRTELE

SPRTELE_UNLIST_IND

POSTAL_CODE Address postal code. VARCHAR2(63)

AORCONT

SPRADDR

AORCONT_ZIPC_CODE_ADDR

SPRADDR_ZIP

PRIMARY_CONTACT_IND Indicates whether this contact is the institution's primary contact. VARCHAR2(1)

CONSTANT

SOURCE AOBORGN THEN 'Y', ELSE 'N'

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

NA

NA

STATE_PROVINCE State or province associated with this address. VARCHAR2(63)

AORCONT

SPRADDR

AORCONT_STAT_CODE_ADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_DESC State/province description. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

STREET_LINE1 First line of the address. VARCHAR2(255)

AORCONT

SPRADDR

AORCONT_ADDR_LINE1

SPRADDR_STREET_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(255)

AORCONT

SPRADDR

AORCONT_ADDR_LINE2

SPRADDR_STREET_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(255)

AORCONT

SPRADDR

AORCONT_ADDR_LINE3

SPRADDR_STREET_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(255)

NA

NA



Ver: 8.0