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

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, contact start and end date, job category, title, contact name, primary address, phone, fax and email.
Key & Frequency One row per entity per contact sequence number.
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

AORCONT_ATYP_CODE

ADDRESS_TYPE_DESC Address type description. VARCHAR2(255)

STVATYP

STVATYP_DESC

ADMINISTRATIVE_GROUP Administrative-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

SPRADDR

AORCONT_CARRIER_ROUTE

SPRADDR_CARRIER_ROUNT

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

AORCONT

SPRADDR

AORCONT_ADDR_CITY

SPRADDR_CITY

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

AORCONT

AORCONT_ACTIVITY_DATE

CONTACT_ADDRESS_SOURCE Indicates whether this contact address information is sourced from the (O)rganization address type, (C)onstituent address type, or manually entered as No Source. VARCHAR2(63)

AORCONT

AORCONT_CONT_ORG_IND

CONTACT_ADDRESS_SOURCE_DESC Contact address source description. VARCHAR2(255)

CALCULATION

CASE WHEN AORCONT_CONT_ORG_IND

CONTACT_ADDRESS_STATUS_IND Indicates whether the address information is active or inactive. VARCHAR2(1)

SPRADDR

SPRADDR_STATUS_IND

CONTACT_COMMENT Comment related to organization contact. VARCHAR2(4000)

AORCONT

AORCONT_NOTES

CONTACT_DECEASED_IND Indicates whether this person is deceased. VARCHAR2(1)

AORCONT

SPBPERS

AORCONT_DECEASED_IND

SPBPERS_DEAD_IND

CONTACT_DECEASED_IND_DESC Contact deceased indicator description. VARCHAR2(255)

CALCULATION

CASE WHEN CONTACT_DECEASED_IND

CONTACT_EMAIL_SOURCE Indicates whether this contact email information is sourced from the (O)rganization email type, (C)onstituent email type, or manually entered as No Source. VARCHAR2(63)

AORCONT

AORCONT_EMAL_SRC_IND

CONTACT_EMAIL_SOURCE_DESC Contact email source description. VARCHAR2(255)

CALCULATION

CASE WHEN AORCONT_EMAL_SRC_IND

CONTACT_END_DATE Organization contact end date. DATE

AORCONT

AORCONT_END_DATE

CONTACT_FAX_SOURCE Indicates whether this contact fax information is sourced from the (O)rganization fax type, (C)onstituent fax type, or manually entered as No Source. VARCHAR2(63)

AORCONT

AORCONT_FAX_SRC_IND

CONTACT_FAX_SOURCE_DESC Contact fax source description. VARCHAR2(255)

CALCULATION

CASE WHEN AORCONT_FAX_SRC_IND

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_LAST_NAME_PREFIX Last name prefix of the person. VARCHAR2(255)

AORCONT

SPRIDEN

AORCONT_SURNAME_PREFIX

SPRIDEN_SURNAME_PREFIX

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

AORCONT

SPRIDEN

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_PHONE_SOURCE Indicates whether this contact phone information is sourced from the (O)rganization phone type, (C)onstituent phone type, or manually entered as No Source. VARCHAR2(63)

AORCONT

AORCONT_TELE_SRC_IND

CONTACT_PHONE_SOURCE_DESC Contact phone source description. VARCHAR2(255)

CALCULATION

CASE WHEN AORCONT_TELE_SRC_IND

CONTACT_SEQUENCE_NUMBER Organization contact internal system generated one-up number. NUMBER

AORCONT

AORCONT_SEQ_NO

CONTACT_START_DATE Organization contact start date. DATE

AORCONT

AORCONT_DATE

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

CONTACT_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

NA

NULL

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)

AORCONT

GOREMAL

AORCONT_EMAIL_ADDRESS

GOREMAL_EMAIL_ADDRESS

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

GTVEMAL

GTVEMAL_DESC

EMAIL_TYPE Type of email address recorded. VARCHAR2(63)

AORCONT

AORCONT_EMAL_CODE

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

AORCONT

AORCONT_PIDM

FAX_AREA Fax area code. VARCHAR2(63)

AORCONT

SPRTELE

AORCONT_FAX_AREA

SPRTELE_PHONE_AREA

FAX_COUNTRY_CODE Fax country code designation. VARCHAR2(63)

AORCONT

SPRTELE

AORCONT_CTRY_CODE_FAX

SPRTELE_CTRY_CODE_PHONE

FAX_EXT Fax extension. VARCHAR2(63)

AORCONT

SPRTELE

AORCONT_FAX_EXT

SPRTELE_PHONE_EXT

FAX_NUMBER Fax number. VARCHAR2(63)

AORCONT

SPRTELE

AORCONT_FAX_NUMBER

SPRTELE_PHONE_NUMBER

FAX_NUMBER_COMBINED Organizational contact's fax number. VARCHAR2(63)

CALCULATION

CALCULATION

AORCONT_FAX_AREA||AORCONT_FAX_NUMBER||AORCONT_FAX_EXT

SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA||SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT

FAX_TYPE Fax type code associated with the contact preferred fax number. VARCHAR2(63)

AORCONT

AORCONT_FAX_CODE

FAX_TYPE_DESC Fax number type description. VARCHAR2(255)

STVTELE

STVTELE_DESC

FAX_UNLIST_IND Indicates whether the fax number is unlisted. VARCHAR2(1)

SPRTELE

SPRTELE_UNLIST_IND

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

FUNCTION

MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS

HOUSE_NUMBER House number associated with the address. VARCHAR2(63)

AORCONT

SPRADDR

AORCONT_HOUSE_NUMBER

SPRADDR_HOUSE_NUMBER

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

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

AORCONT

AORCONT_JOBC_CODE

JOB_CATEGORY_DESC Job category code description. VARCHAR2(255)

ATVJOBC

ATVJOBC_DESC

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

AORCONT

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)

SPRIDEN

SPRIDEN_LAST_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_COUNTRY_CODE Telephone country code designation. VARCHAR2(63)

AORCONT

SPRTELE

AORCONT_CTRY_CODE_PHONE

SPRTELE_CTRY_CODE_PHONE

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

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 contact telephone number. VARCHAR2(63)

AORCONT

AORCONT_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)

CALCULATION

CASE WHEN AORCONT_PRIMARY_IND

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)

AORCONT

SPRADDR

AORCONT_ADDR_LINE4

SPRADDR_STREET_LINE4



Ver: 9.1