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 Local Source Target Type Target Target Column Local Target Calculation Formula
AORCONT_ACTIVITY_DATE AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_ACTIVITY_DATE

NO

 
AORCONT_ADDR_CITY AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

CITY_1

CITY

CITY_2

NO

NO

NO

NA
AORCONT_ADDR_LINE1 AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

STREET_LINE1

STREET_LINE1_1

STREET_LINE1_2

NO

NO

NO

NA
AORCONT_ADDR_LINE2 AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

STREET_LINE2_1

STREET_LINE2

STREET_LINE2_2

NO

NO

NO

NA
AORCONT_ADDR_LINE3 AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

STREET_LINE3_2

STREET_LINE3

STREET_LINE3_1

NO

NO

NO

NA
AORCONT_ADDR_LINE4 AOACONT NO

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

STREET_LINE4

STREET_LINE4_1

STREET_LINE4_2

NO

NO

NO

 
AORCONT_ATYP_CODE AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ADDRESS_TYPE_1

ADDRESS_TYPE

ADDRESS_TYPE_2

NO

NO

NO

NA
AORCONT_CARRIER_ROUTE AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

CARRIER_ROUTE

NO

NA
AORCONT_CNTY_CODE_ADDR AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

COUNTY_1

COUNTY

COUNTY_2

NO

NO

NO

NA
AORCONT_CONTACT_PIDM NA NO

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

CONTACT_UID_2

CONTACT_UID

CONTACT_UID_1

NO

NO

NO

NA
AORCONT_CONT_ORG_IND AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_ADDRESS_SOURCE

NO

 
AORCONT_CORRECTION_DIGIT AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

CORRECTION_DIGIT

NO

NA
AORCONT_CTRY_CODE_FAX AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

FAX_COUNTRY_CODE

NO

 
AORCONT_CTRY_CODE_PHONE AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

PHONE_COUNTRY_CODE

NO

 
AORCONT_DATE AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_START_DATE

NO

 
AORCONT_DECEASED_IND AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_DECEASED_IND

NO

 
AORCONT_DELIVERY_POINT AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

DELIVERY_POINT

NO

NA
AORCONT_EMAIL_ADDRESS AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

EMAIL_ADDRESS

NO

 
AORCONT_EMAL_CODE AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

EMAIL_TYPE

NO

 
AORCONT_EMAL_SRC_IND AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_EMAIL_SOURCE

NO

 
AORCONT_END_DATE AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_END_DATE

NO

 
AORCONT_FAX_AREA AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

FAX_AREA

NO

 
AORCONT_FAX_CODE AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

FAX_TYPE

NO

 
AORCONT_FAX_EXT AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

FAX_EXT

NO

 
AORCONT_FAX_NUMBER AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

FAX_NUMBER

NO

 
AORCONT_FAX_SRC_IND AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_FAX_SOURCE

NO

 
AORCONT_FIRST_NAME AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

CONTACT_FIRST_NAME_1

CONTACT_FIRST_NAME_2

CONTACT_FIRST_NAME

NO

NO

NO

NA
AORCONT_HOUSE_NUMBER AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

HOUSE_NUMBER

NO

 
AORCONT_JOBC_CODE AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

JOB_CATEGORY

NO

NA
AORCONT_LAST_NAME AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

CONTACT_LAST_NAME_1

CONTACT_LAST_NAME

CONTACT_LAST_NAME_2

NO

NO

NO

NA
AORCONT_MI AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

CONTACT_MIDDLE_INITIAL

CONTACT_MIDDLE_INITIAL_1

CONTACT_MIDDLE_INITIAL_2

NO

NO

NO

NA
AORCONT_NAME_PREFIX AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_NAME_PREFIX

NO

NA
AORCONT_NAME_SUFFIX AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_NAME_SUFFIX

NO

NA
AORCONT_NATN_CODE_ADDR AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

NATION

NATION_1

NATION_2

NO

NO

NO

NA
AORCONT_NOTES AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_COMMENT

NO

 
AORCONT_OCON_CODE AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

CONTACT_TYPE

CONTACT_TYPE_1

CONTACT_TYPE_2

NO

NO

NO

NA
AORCONT_PHONE_AREA AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

PHONE_AREA_2

PHONE_AREA

PHONE_AREA_1

NO

NO

NO

NA
AORCONT_PHONE_EXT AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

PHONE_EXT_2

PHONE_EXT_1

PHONE_EXT

NO

NO

NO

NA
AORCONT_PHONE_NUMBER AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

PHONE_NUMBER

PHONE_NUMBER_1

PHONE_NUMBER_2

NO

NO

NO

NA
AORCONT_PIDM NA NO

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ENTITY_UID

ENTITY_UID

NO

NO

NA
AORCONT_SEQ_NO AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_SEQUENCE_NUMBER

NO

 
AORCONT_STAT_CODE_ADDR AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

STATE_PROVINCE_1

STATE_PROVINCE

STATE_PROVINCE_2

NO

NO

NO

NA
AORCONT_SURNAME_PREFIX AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_LAST_NAME_PREFIX

NO

 
AORCONT_TELE_CODE AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

PHONE_TYPE

NO

 
AORCONT_TELE_SRC_IND AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

CONTACT_PHONE_SOURCE

NO

 
AORCONT_TITLE AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

JOB_TITLE

NO

NA
AORCONT_ZIPC_CODE_ADDR AOAORGN NO

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

POSTAL_CODE

POSTAL_CODE_1

POSTAL_CODE_2

NO

NO

NO

NA


Ver: 9.2