Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AA_ORGANIZATION_CONTACT

Description Source composite view contains information on all organization contacts including name, address, phone, email and job criteria.

Target Column Business Definition Database Data Type Source Name Source Column
ADDRESS_TYPE Type of address for this address record. For example, address types of mailing, temporary summer, billing and permanent. VARCHAR2(2)

AORCONT

SPRADDR

AORCONT_ATYP_CODE

SPRADDR_ATYP_CODE

ADDRESS_TYPE_DESC Address type description. VARCHAR2(30)

STVATYP

STVATYP_DESC

CARRIER_ROUTE Address carrier route. VARCHAR2(4)

AORCONT

AORCONT_CARRIER_ROUTE

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

AORCONT

AORCONT_ADDR_CITY

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

AORCONT

SPRIDEN

AORCONT_FIRST_NAME

SPRIDEN_FIRST_NAME

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

AORCONT

SPRIDEN

AORCONT_LAST_NAME

SPRIDEN_LAST_NAME

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

AOBORGN

AORCONT

SPRIDEN

AOBORGN_MI_CONTACT

AORCONT_MI

SPRIDEN_MI

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

AORCONT

SPBPERS

AORCONT_NAME_PREFIX

SPBPERS_NAME_PREFIX

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

AORCONT

SPBPERS

AORCONT_NAME_SUFFIX

SPBPERS_NAME_SUFFIX

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

AORCONT

AORCONT_OCON_CODE

CONTACT_TYPE_DESC Contact type description. VARCHAR2(30)

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

AORCONT

SPRADDR

AORCONT_CNTY_CODE_ADDR

SPRADDR_CNTY_CODE

COUNTY_DESC County name for the address. VARCHAR2(30)

STVCNTY

STVCNTY_DESC

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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

AORCONT

SPRADDR

AORCONT_DELIVERY_POINT

SPRADDR_DELIVERY_POINT

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

EMAIL_ADDRESS Preferred email address. VARCHAR2(128)

GOREMAL

GOREMAL_EMAIL_ADDRESS

EMAIL_DESC Description for the type of email associated with the organization's preferred email. VARCHAR2(60)

GTVEMAL

GTVEMAL_DESC

EMAIL_TYPE Type of email address recorded. VARCHAR2(4)

GOREMAL

GOREMAL_EMAL_CODE

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

AOBORGN

AORCONT

AOBORGN_PIDM

AORCONT_PIDM

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

AOBORGN

AORCONT

AOBORGN_JOBC_CODE

AORCONT_JOBC_CODE

JOB_CATEGORY_DESC Job category code description. VARCHAR2(60)

ATVJOBC

ATVJOBC_DESC

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

AOBORGN

AORCONT

AOBORGN_TITLE_CONTACT

AORCONT_TITLE

MIF_DESC Institution description for the record 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

NATION Nation/country code associated with the address. VARCHAR2(5)

AORCONT

SPRADDR

AORCONT_NATN_CODE_ADDR

SPRADDR_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(30)

STVNATN

STVNATN_NATION

PHONE_AREA Phone area code. VARCHAR2(6)

AORCONT

SPRTELE

AORCONT_PHONE_AREA

SPRTELE_PHONE_AREA

PHONE_DESC Telephone number type description. VARCHAR2(30)

STVTELE

STVTELE_DESC

PHONE_EXT Phone extension. VARCHAR2(10)

AORCONT

SPRTELE

AORCONT_PHONE_EXT

SPRTELE_PHONE_EXT

PHONE_NUMBER Phone number. VARCHAR2(12)

AORCONT

SPRTELE

AORCONT_PHONE_NUMBER

SPRTELE_PHONE_NUMBER

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

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

SPRTELE

SPRTELE_TELE_CODE

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

SPRTELE

SPRTELE_UNLIST_IND

POSTAL_CODE Postal code for the organizational contact's address. VARCHAR2(30)

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'

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

AORCONT

SPRADDR

AORCONT_STAT_CODE_ADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_DESC State/province description. VARCHAR2(30)

STVSTAT

STVSTAT_DESC

STREET_LINE1 First line of the address. VARCHAR2(75)

AORCONT

SPRADDR

AORCONT_ADDR_LINE1

SPRADDR_STREET_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(75)

AORCONT

SPRADDR

AORCONT_ADDR_LINE2

SPRADDR_STREET_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(75)

AORCONT

SPRADDR

AORCONT_ADDR_LINE3

SPRADDR_STREET_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(75)

NA

NA

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

NA

NA



Ver: 8.0