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

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

AA_ORGANIZATION_CONTACT

CONTACT_ACTIVITY_DATE

 
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_ADDR_LINE4 AOACONT COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

STREET_LINE4

 
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_CONT_ORG_IND AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_ADDRESS_SOURCE

 
AORCONT_CORRECTION_DIGIT AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CORRECTION_DIGIT

NA
AORCONT_CTRY_CODE_FAX AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

FAX_COUNTRY_CODE

 
AORCONT_CTRY_CODE_PHONE AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

PHONE_COUNTRY_CODE

 
AORCONT_DATE AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_START_DATE

 
AORCONT_DECEASED_IND AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_DECEASED_IND

 
AORCONT_DELIVERY_POINT AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

DELIVERY_POINT

NA
AORCONT_EMAIL_ADDRESS AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

EMAIL_ADDRESS

 
AORCONT_EMAL_CODE AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

EMAIL_TYPE

 
AORCONT_EMAL_SRC_IND AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_EMAIL_SOURCE

 
AORCONT_END_DATE AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_END_DATE

 
AORCONT_FAX_AREA AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

FAX_AREA

 
AORCONT_FAX_CODE AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

FAX_TYPE

 
AORCONT_FAX_EXT AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

FAX_EXT

 
AORCONT_FAX_NUMBER AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

FAX_NUMBER

 
AORCONT_FAX_SRC_IND AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_FAX_SOURCE

 
AORCONT_FIRST_NAME AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_FIRST_NAME

NA
AORCONT_HOUSE_NUMBER AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

HOUSE_NUMBER

 
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_NOTES AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_COMMENT

 
AORCONT_OCON_CODE AOAORGN       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_SEQ_NO AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_SEQUENCE_NUMBER

 
AORCONT_STAT_CODE_ADDR AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

STATE_PROVINCE

NA
AORCONT_SURNAME_PREFIX AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_LAST_NAME_PREFIX

 
AORCONT_TELE_CODE AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

PHONE_TYPE

 
AORCONT_TELE_SRC_IND AOAORGN COMPOSITE VIEW

AA_ORGANIZATION_CONTACT

CONTACT_PHONE_SOURCE

 
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: