Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: AORCONT Advancement
SGHE Banner Operational Data Store Composite View Source: AORCONT - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
AORCONT_ADDR_CITY AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CITY

NA
AORCONT_ADDR_LINE1 AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

STREET_LINE1

NA
AORCONT_ADDR_LINE2 AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

STREET_LINE2

NA
AORCONT_ADDR_LINE3 AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

STREET_LINE3

NA
AORCONT_ATYP_CODE AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

ADDRESS_TYPE

NA
AORCONT_CARRIER_ROUTE AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CARRIER_ROUTE

NA
AORCONT_CNTY_CODE_ADDR AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

COUNTY

NA
AORCONT_CONTACT_PIDM NA COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_UID

NA
AORCONT_CORRECTION_DIGIT AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CORRECTION_DIGIT

NA
AORCONT_DELIVERY_POINT AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

DELIVERY_POINT

NA
AORCONT_FIRST_NAME AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_FIRST_NAME

NA
AORCONT_JOBC_CODE AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

JOB_CATEGORY

NA
AORCONT_LAST_NAME AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_LAST_NAME

NA
AORCONT_MI AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_MIDDLE_INITIAL

NA
AORCONT_NAME_PREFIX AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_NAME_PREFIX

NA
AORCONT_NAME_SUFFIX AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_NAME_SUFFIX

NA
AORCONT_NATN_CODE_ADDR AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

NATION

NA
AORCONT_OCON_CODE AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_TYPE

NA
AORCONT_PHONE_AREA AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

PHONE_AREA

NA
AORCONT_PHONE_EXT AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

PHONE_EXT

NA
AORCONT_PHONE_NUMBER AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

PHONE_NUMBER

NA
AORCONT_PIDM NA COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

ENTITY_UID

NA
AORCONT_STAT_CODE_ADDR AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

STATE_PROVINCE

NA
AORCONT_TITLE AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

JOB_TITLE

NA
AORCONT_ZIPC_CODE_ADDR AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

POSTAL_CODE

NA


Ver: 8.0