Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

Banner Operational Data Store
Composite View Target: AA_ORGANIZATION_CONTACT

Key & Frequency One row per entity per contact sequence number.

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

AORCONT_ATYP_CODE

ADDRESS_TYPE_DESC Address type description. VARCHAR2(30)

STVATYP

STVATYP_DESC

CARRIER_ROUTE Address carrier route. VARCHAR2(4)

AORCONT

SPRADDR

AORCONT_CARRIER_ROUTE

SPRADDR_CARRIER_ROUNT

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

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

AORCONT

AORCONT_CONT_ORG_IND

CONTACT_ADDRESS_SOURCE_DESC Contact address source description. VARCHAR2(12)

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_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(1)

AORCONT

AORCONT_EMAL_SRC_IND

CONTACT_EMAIL_SOURCE_DESC Contact email source description. VARCHAR2(12)

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

AORCONT

AORCONT_FAX_SRC_IND

CONTACT_FAX_SOURCE_DESC Contact fax source description. VARCHAR2(12)

CALCULATION

CASE WHEN AORCONT_FAX_SRC_IND

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

AORCONT

SPRIDEN

AORCONT_SURNAME_PREFIX

SPRIDEN_SURNAME_PREFIX

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

AORCONT

SPRIDEN

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_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(1)

AORCONT

AORCONT_TELE_SRC_IND

CONTACT_PHONE_SOURCE_DESC Contact phone source description. VARCHAR2(12)

CALCULATION

CASE WHEN AORCONT_TELE_SRC_IND

CONTACT_SEQUENCE_NUMBER Organization contact internal system generated one-up number. NUMBER(23,20)

AORCONT

AORCONT_SEQ_NO

CONTACT_START_DATE Organization contact start date. DATE

AORCONT

AORCONT_DATE

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

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

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)

AORCONT

GOREMAL

AORCONT_EMAIL_ADDRESS

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)

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

AORCONT

SPRTELE

AORCONT_FAX_AREA

SPRTELE_PHONE_AREA

FAX_COUNTRY_CODE Fax country code designation. VARCHAR2(4)

AORCONT

SPRTELE

AORCONT_CTRY_CODE_FAX

SPRTELE_CTRY_CODE_PHONE

FAX_EXT Fax extension. VARCHAR2(10)

AORCONT

SPRTELE

AORCONT_FAX_EXT

SPRTELE_PHONE_EXT

FAX_NUMBER Fax number. VARCHAR2(12)

AORCONT

SPRTELE

AORCONT_FAX_NUMBER

SPRTELE_PHONE_NUMBER

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

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

AORCONT

AORCONT_FAX_CODE

FAX_TYPE_DESC Fax number type description. VARCHAR2(30)

STVTELE

STVTELE_DESC

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

SPRTELE

SPRTELE_UNLIST_IND

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

AORCONT

SPRADDR

AORCONT_HOUSE_NUMBER

SPRADDR_HOUSE_NUMBER

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)

AORCONT

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

AORCONT

SPRTELE

AORCONT_CTRY_CODE_PHONE

SPRTELE_CTRY_CODE_PHONE

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

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

AORCONT

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

CALCULATION

CASE WHEN AORCONT_PRIMARY_IND

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)

AORCONT

SPRADDR

AORCONT_ADDR_LINE4

SPRADDR_STREET_LINE4

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

NA

NA



Ver: