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

SGHE Banner Operational Data Store
Composite View Target: AA_ORGANIZATION_CONTACT

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

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ADDRESS_TYPE 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 Address type description. VARCHAR2(30)  

STVATYP

STVATYP_DESC

CARRIER_ROUTE Carrier Route Address carrier route. VARCHAR2(4)  

AORCONT

SPRADDR

AORCONT_CARRIER_ROUTE

SPRADDR_CARRIER_ROUNT

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

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

AORCONT

AORCONT_CONT_ORG_IND

CONTACT_ADDRESS_SOURCE_DESC Contact Address Source Description Contact address source description. VARCHAR2(12)  

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

AORCONT

AORCONT_EMAL_SRC_IND

CONTACT_EMAIL_SOURCE_DESC Contact Email Source Description Contact email source description. VARCHAR2(12)  

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

AORCONT

AORCONT_FAX_SRC_IND

CONTACT_FAX_SOURCE_DESC Contact Fax Source Description Contact fax source description. VARCHAR2(12)  

CALCULATION

CASE WHEN AORCONT_FAX_SRC_IND

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

AORCONT

SPRIDEN

AORCONT_FIRST_NAME

SPRIDEN_FIRST_NAME

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

AORCONT

SPRIDEN

AORCONT_LAST_NAME

SPRIDEN_LAST_NAME

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

AORCONT

SPRIDEN

AORCONT_SURNAME_PREFIX

SPRIDEN_SURNAME_PREFIX

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

AORCONT

SPRIDEN

AORCONT_MI

SPRIDEN_MI

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

AORCONT

SPBPERS

AORCONT_NAME_PREFIX

SPBPERS_NAME_PREFIX

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

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

AORCONT

AORCONT_TELE_SRC_IND

CONTACT_PHONE_SOURCE_DESC Contact Phone Source Description Contact phone source description. VARCHAR2(12)  

CALCULATION

CASE WHEN AORCONT_TELE_SRC_IND

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

AORCONT

AORCONT_SEQ_NO

CONTACT_START_DATE Contact Start Date Organization contact start date. DATE  

AORCONT

AORCONT_DATE

CONTACT_TYPE   Type of contact between the institution and the organization. VARCHAR2(3)      
CONTACT_TYPE_DESC Contact Type Description Contact type description. VARCHAR2(30)  

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

AORCONT

SPRADDR

AORCONT_CNTY_CODE_ADDR

SPRADDR_CNTY_CODE

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

STVCNTY

STVCNTY_DESC

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

NA

SYSDATE

DELIVERY_POINT 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 Email Address Preferred email address. VARCHAR2(128)  

AORCONT

GOREMAL

AORCONT_EMAIL_ADDRESS

GOREMAL_EMAIL_ADDRESS

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

GTVEMAL

GTVEMAL_DESC

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

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

AORCONT

SPRTELE

AORCONT_FAX_AREA

SPRTELE_PHONE_AREA

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

AORCONT

SPRTELE

AORCONT_CTRY_CODE_FAX

SPRTELE_CTRY_CODE_PHONE

FAX_EXT Fax Extension Fax extension. VARCHAR2(10)  

AORCONT

SPRTELE

AORCONT_FAX_EXT

SPRTELE_PHONE_EXT

FAX_NUMBER Fax Number Fax number. VARCHAR2(12)  

AORCONT

SPRTELE

AORCONT_FAX_NUMBER

SPRTELE_PHONE_NUMBER

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

AORCONT

AORCONT_FAX_CODE

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

STVTELE

STVTELE_DESC

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

SPRTELE

SPRTELE_UNLIST_IND

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

AORCONT

SPRADDR

AORCONT_HOUSE_NUMBER

SPRADDR_HOUSE_NUMBER

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

AORCONT

AORCONT_JOBC_CODE

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

ATVJOBC

ATVJOBC_DESC

JOB_TITLE 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 Nation/country code associated with the address. VARCHAR2(5)  

AORCONT

SPRADDR

AORCONT_NATN_CODE_ADDR

SPRADDR_NATN_CODE

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

STVNATN

STVNATN_NATION

PHONE_AREA Phone Area Phone area code. VARCHAR2(6)  

AORCONT

SPRTELE

AORCONT_PHONE_AREA

SPRTELE_PHONE_AREA

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

AORCONT

SPRTELE

AORCONT_CTRY_CODE_PHONE

SPRTELE_CTRY_CODE_PHONE

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

STVTELE

STVTELE_DESC

PHONE_EXT Phone Extension Phone extension. VARCHAR2(10)  

AORCONT

SPRTELE

AORCONT_PHONE_EXT

SPRTELE_PHONE_EXT

PHONE_NUMBER Phone Number Phone number. VARCHAR2(12)  

AORCONT

SPRTELE

AORCONT_PHONE_NUMBER

SPRTELE_PHONE_NUMBER

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

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

AORCONT

AORCONT_TELE_CODE

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

SPRTELE

SPRTELE_UNLIST_IND

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

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

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

STVSTAT

STVSTAT_DESC

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

AORCONT

SPRADDR

AORCONT_ADDR_LINE1

SPRADDR_STREET_LINE1

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

AORCONT

SPRADDR

AORCONT_ADDR_LINE2

SPRADDR_STREET_LINE2

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

AORCONT

SPRADDR

AORCONT_ADDR_LINE3

SPRADDR_STREET_LINE3

STREET_LINE4 Street Line 4 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: