Go To View:  RETURN TO BANNER ODS META DATA 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, 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 Name Business Definition Database Data Type Domain Value Source Name Source Column
ADDRESS_COUNT Address Count Count of current active addresses for this person or entity. NUMBER  

FUNCTION

FUNCTION

MSKFUNC.F_COUNT_ADDRESSES

MSKFUNC.F_COUNT_ADDRESSES

ADDRESS_TYPE 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 Address type description. VARCHAR2(255)  

STVATYP

STVATYP_DESC

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

NA

NA

CARRIER_ROUTE Carrier Route Address carrier route. VARCHAR2(63)  

AORCONT

SPRADDR

AORCONT_CARRIER_ROUTE

SPRADDR_CARRIER_ROUNT

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

AORCONT

SPRADDR

AORCONT_ADDR_CITY

SPRADDR_CITY

CONTACT_ACTIVITY_DATE 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 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 Contact address source description. VARCHAR2(255)  

CALCULATION

CASE WHEN AORCONT_CONT_ORG_IND

CONTACT_ADDRESS_STATUS_IND Contact Address Status Indicator Indicates whether the address information is active or inactive. VARCHAR2(1)  

SPRADDR

SPRADDR_STATUS_IND

CONTACT_COMMENT Contact Comment Comment related to organization contact. VARCHAR2(4000)  

AORCONT

AORCONT_NOTES

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

AORCONT

SPBPERS

AORCONT_DECEASED_IND

SPBPERS_DEAD_IND

CONTACT_DECEASED_IND_DESC Contact Deceased Indicator Description Contact deceased indicator description. VARCHAR2(255)  

CALCULATION

CASE WHEN CONTACT_DECEASED_IND

CONTACT_EMAIL_SOURCE 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 Contact email source description. VARCHAR2(255)  

CALCULATION

CASE WHEN AORCONT_EMAL_SRC_IND

CONTACT_END_DATE Contact End Date Organization contact end date. DATE  

AORCONT

AORCONT_END_DATE

CONTACT_FAX_SOURCE 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 Contact fax source description. VARCHAR2(255)  

CALCULATION

CASE WHEN AORCONT_FAX_SRC_IND

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

AORCONT

SPRIDEN

AORCONT_FIRST_NAME

SPRIDEN_FIRST_NAME

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

AORCONT

SPRIDEN

AORCONT_LAST_NAME

SPRIDEN_LAST_NAME

CONTACT_LAST_NAME_PREFIX Contact Last Name Prefix Last name prefix of the person. VARCHAR2(255)  

AORCONT

SPRIDEN

AORCONT_SURNAME_PREFIX

SPRIDEN_SURNAME_PREFIX

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

AORCONT

SPRIDEN

AORCONT_MI

SPRIDEN_MI

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

AORCONT

SPBPERS

AORCONT_NAME_PREFIX

SPBPERS_NAME_PREFIX

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

AORCONT

SPBPERS

AORCONT_NAME_SUFFIX

SPBPERS_NAME_SUFFIX

CONTACT_PHONE_SOURCE 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 Contact phone source description. VARCHAR2(255)  

CALCULATION

CASE WHEN AORCONT_TELE_SRC_IND

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

AORCONT

AORCONT_SEQ_NO

CONTACT_START_DATE Contact Start Date Organization contact start date. DATE  

AORCONT

AORCONT_DATE

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

AORCONT

AORCONT_OCON_CODE

CONTACT_TYPE_DESC Contact Type Description Contact type description. VARCHAR2(255)  

ATVOCON

ATVOCON_DESC

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

AORCONT

AORCONT_CONTACT_PIDM

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

NA

NULL

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

AORCONT

SPRADDR

AORCONT_CORRECTION_DIGIT

SPRADDR_CORRECTION_DIGIT

COUNTY County County for this address. VARCHAR2(63)  

AORCONT

SPRADDR

AORCONT_CNTY_CODE_ADDR

SPRADDR_CNTY_CODE

COUNTY_DESC County Description County name for the address. VARCHAR2(255)  

STVCNTY

STVCNTY_DESC

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

AORCONT

SPRADDR

AORCONT_DELIVERY_POINT

SPRADDR_DELIVERY_POINT

EMAIL_ADDRESS Email Address Preferred email address. VARCHAR2(255)  

AORCONT

GOREMAL

AORCONT_EMAIL_ADDRESS

GOREMAL_EMAIL_ADDRESS

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

GTVEMAL

GTVEMAL_DESC

EMAIL_TYPE Email Type Type of email address recorded. VARCHAR2(63)  

AORCONT

AORCONT_EMAL_CODE

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

AORCONT

AORCONT_PIDM

FAX_AREA Fax Area Fax area code. VARCHAR2(63)  

AORCONT

SPRTELE

AORCONT_FAX_AREA

SPRTELE_PHONE_AREA

FAX_COUNTRY_CODE Fax Country Code Fax country code designation. VARCHAR2(63)  

AORCONT

SPRTELE

AORCONT_CTRY_CODE_FAX

SPRTELE_CTRY_CODE_PHONE

FAX_EXT Fax Extension Fax extension. VARCHAR2(63)  

AORCONT

SPRTELE

AORCONT_FAX_EXT

SPRTELE_PHONE_EXT

FAX_NUMBER Fax Number Fax number. VARCHAR2(63)  

AORCONT

SPRTELE

AORCONT_FAX_NUMBER

SPRTELE_PHONE_NUMBER

FAX_NUMBER_COMBINED 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 Fax type code associated with the contact preferred fax number. VARCHAR2(63)  

AORCONT

AORCONT_FAX_CODE

FAX_TYPE_DESC Fax Type Description Fax number type description. VARCHAR2(255)  

STVTELE

STVTELE_DESC

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

SPRTELE

SPRTELE_UNLIST_IND

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

FUNCTION

FUNCTION

MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS

MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS

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

AORCONT

SPRADDR

AORCONT_HOUSE_NUMBER

SPRADDR_HOUSE_NUMBER

ID ID Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent. VARCHAR2(9)  

SPRIDEN

SPRIDEN

SPRIDEN_ID

SPRIDEN_ID

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

AORCONT

AORCONT_JOBC_CODE

JOB_CATEGORY_DESC Job Category Description Job category code description. VARCHAR2(255)  

ATVJOBC

ATVJOBC_DESC

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

AORCONT

AORCONT_TITLE

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

NA

NA

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

NA

NA

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

SPRIDEN

SPRIDEN

SPRIDEN_LAST_NAME

SPRIDEN_LAST_NAME

NATION Nation Address nation/country code. VARCHAR2(63)  

AORCONT

SPRADDR

AORCONT_NATN_CODE_ADDR

SPRADDR_NATN_CODE

NATION_DESC Nation Description Address nation/country description. VARCHAR2(255)  

STVNATN

STVNATN_NATION

PHONE_AREA Phone Area Phone area code. VARCHAR2(63)  

AORCONT

SPRTELE

AORCONT_PHONE_AREA

SPRTELE_PHONE_AREA

PHONE_COUNT Phone Count Count of phone records. NUMBER  

FUNCTION

FUNCTION

MSKFUNC.F_COUNT_TELEPHONES

MSKFUNC.F_COUNT_TELEPHONES

PHONE_COUNTRY_CODE Phone Country Code Telephone country code designation. VARCHAR2(63)  

AORCONT

SPRTELE

AORCONT_CTRY_CODE_PHONE

SPRTELE_CTRY_CODE_PHONE

PHONE_DESC Phone Description Telephone number type description. VARCHAR2(255)  

STVTELE

STVTELE_DESC

PHONE_EXT Phone Extension Phone extension. VARCHAR2(63)  

AORCONT

SPRTELE

AORCONT_PHONE_EXT

SPRTELE_PHONE_EXT

PHONE_NUMBER Phone Number Phone number. VARCHAR2(63)  

AORCONT

SPRTELE

AORCONT_PHONE_NUMBER

SPRTELE_PHONE_NUMBER

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

CALCULATION

CALCULATION

CALCULATION

CALCULATION

AORCONT_PHONE_AREA||AORCONT_PHONE_NUMBER||AORCONT_PHONE_EXT

AORCONT_PHONE_AREA||AORCONT_PHONE_NUMBER||AORCONT_PHONE_EXT

SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA||SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT

SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA||SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT

PHONE_TYPE Phone Type Telephone type code associated with the contact telephone number. VARCHAR2(63)  

AORCONT

AORCONT_TELE_CODE

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

SPRTELE

SPRTELE_UNLIST_IND

POSTAL_CODE Postal Code Address postal code. VARCHAR2(63)  

AORCONT

SPRADDR

AORCONT_ZIPC_CODE_ADDR

SPRADDR_ZIP

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

CALCULATION

CALCULATION

CASE WHEN AORCONT_PRIMARY_IND

CASE WHEN AORCONT_PRIMARY_IND

PROCESS_GROUP 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 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 State/province description. VARCHAR2(255)  

STVSTAT

STVSTAT_DESC

STREET_LINE1 Street Line 1 First line of the address. VARCHAR2(255)  

AORCONT

SPRADDR

AORCONT_ADDR_LINE1

SPRADDR_STREET_LINE1

STREET_LINE2 Street Line 2 Second line of the address. VARCHAR2(255)  

AORCONT

SPRADDR

AORCONT_ADDR_LINE2

SPRADDR_STREET_LINE2

STREET_LINE3 Street Line 3 Third line of the address. VARCHAR2(255)  

AORCONT

SPRADDR

AORCONT_ADDR_LINE3

SPRADDR_STREET_LINE3

STREET_LINE4 Street Line 4 Fourth line of the address. VARCHAR2(255)  

AORCONT

SPRADDR

AORCONT_ADDR_LINE4

SPRADDR_STREET_LINE4



Ver: 9.0