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

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

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_ACTIVITY_DATE

 
AORCONT_ADDR_CITY AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

CITY_2

CITY_1

CITY

NA
AORCONT_ADDR_LINE1 AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

STREET_LINE1_1

STREET_LINE1

STREET_LINE1_2

NA
AORCONT_ADDR_LINE2 AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

STREET_LINE2_1

STREET_LINE2_2

STREET_LINE2

NA
AORCONT_ADDR_LINE3 AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

STREET_LINE3

STREET_LINE3_1

STREET_LINE3_2

NA
AORCONT_ADDR_LINE4 AOACONT

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

STREET_LINE4_2

STREET_LINE4_1

STREET_LINE4

 
AORCONT_ATYP_CODE AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ADDRESS_TYPE_2

ADDRESS_TYPE

ADDRESS_TYPE_1

NA
AORCONT_CARRIER_ROUTE AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CARRIER_ROUTE

NA
AORCONT_CNTY_CODE_ADDR AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

COUNTY

COUNTY_1

COUNTY_2

NA
AORCONT_CONTACT_PIDM NA

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

CONTACT_UID_2

CONTACT_UID

CONTACT_UID_1

NA
AORCONT_CONT_ORG_IND AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_ADDRESS_SOURCE

 
AORCONT_CORRECTION_DIGIT AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CORRECTION_DIGIT

NA
AORCONT_CTRY_CODE_FAX AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

FAX_COUNTRY_CODE

 
AORCONT_CTRY_CODE_PHONE AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

PHONE_COUNTRY_CODE

 
AORCONT_DATE AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_START_DATE

 
AORCONT_DECEASED_IND AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_DECEASED_IND

 
AORCONT_DELIVERY_POINT AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

DELIVERY_POINT

NA
AORCONT_EMAIL_ADDRESS AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

EMAIL_ADDRESS

 
AORCONT_EMAL_CODE AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

EMAIL_TYPE

 
AORCONT_EMAL_SRC_IND AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_EMAIL_SOURCE

 
AORCONT_END_DATE AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_END_DATE

 
AORCONT_FAX_AREA AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

FAX_AREA

 
AORCONT_FAX_CODE AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

FAX_TYPE

 
AORCONT_FAX_EXT AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

FAX_EXT

 
AORCONT_FAX_NUMBER AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

FAX_NUMBER

 
AORCONT_FAX_SRC_IND AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_FAX_SOURCE

 
AORCONT_FIRST_NAME AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

CONTACT_FIRST_NAME

CONTACT_FIRST_NAME_2

CONTACT_FIRST_NAME_1

NA
AORCONT_HOUSE_NUMBER AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

HOUSE_NUMBER

 
AORCONT_JOBC_CODE AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

JOB_CATEGORY

NA
AORCONT_LAST_NAME AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

CONTACT_LAST_NAME

CONTACT_LAST_NAME_2

CONTACT_LAST_NAME_1

NA
AORCONT_MI AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

CONTACT_MIDDLE_INITIAL

CONTACT_MIDDLE_INITIAL_1

CONTACT_MIDDLE_INITIAL_2

NA
AORCONT_NAME_PREFIX AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_NAME_PREFIX

NA
AORCONT_NAME_SUFFIX AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_NAME_SUFFIX

NA
AORCONT_NATN_CODE_ADDR AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

NATION_1

NATION

NATION_2

NA
AORCONT_NOTES AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_COMMENT

 
AORCONT_OCON_CODE AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

CONTACT_TYPE_2

CONTACT_TYPE_1

CONTACT_TYPE

NA
AORCONT_PHONE_AREA AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

PHONE_AREA

PHONE_AREA_1

PHONE_AREA_2

NA
AORCONT_PHONE_EXT AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

PHONE_EXT_2

PHONE_EXT_1

PHONE_EXT

NA
AORCONT_PHONE_NUMBER AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

PHONE_NUMBER

PHONE_NUMBER_1

PHONE_NUMBER_2

NA
AORCONT_PIDM NA

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ENTITY_UID

ENTITY_UID

NA
AORCONT_SEQ_NO AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_SEQUENCE_NUMBER

 
AORCONT_STAT_CODE_ADDR AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

STATE_PROVINCE

STATE_PROVINCE_1

STATE_PROVINCE_2

NA
AORCONT_SURNAME_PREFIX AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_LAST_NAME_PREFIX

 
AORCONT_TELE_CODE AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

PHONE_TYPE

 
AORCONT_TELE_SRC_IND AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_PHONE_SOURCE

 
AORCONT_TITLE AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

JOB_TITLE

NA
AORCONT_ZIPC_CODE_ADDR AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

POSTAL_CODE_1

POSTAL_CODE_2

POSTAL_CODE

NA


Ver: 9.1