RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: AORCONT Advancement Reporting View Meta Data Reports
SGHE Operational Data Store Reporting View Source: AORCONT

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

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

CITY

CITY_1

CITY_2

NA
AORCONT_ADDR_LINE1 AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

STREET_LINE1_1

STREET_LINE1_2

STREET_LINE1

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_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

STREET_LINE3_2

STREET_LINE3

STREET_LINE3_1

NA
AORCONT_ATYP_CODE AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

ADDRESS_TYPE

ADDRESS_TYPE_2

ADDRESS_TYPE_1

NA
AORCONT_CARRIER_ROUTE AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CARRIER_ROUTE

NA
AORCONT_CNTY_CODE_ADDR AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

COUNTY_1

COUNTY_2

COUNTY

NA
AORCONT_CONTACT_PIDM NA

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

CONTACT_UID_2

CONTACT_UID_1

CONTACT_UID

NA
AORCONT_CORRECTION_DIGIT AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

CORRECTION_DIGIT

NA
AORCONT_DELIVERY_POINT AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

DELIVERY_POINT

NA
AORCONT_FIRST_NAME AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

CONTACT_FIRST_NAME_1

CONTACT_FIRST_NAME

CONTACT_FIRST_NAME_2

NA
AORCONT_JOBC_CODE AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

JOB_CATEGORY

NA
AORCONT_LAST_NAME AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

CONTACT_LAST_NAME_2

CONTACT_LAST_NAME

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

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

NATION

NATION_1

NATION_2

NA
AORCONT_OCON_CODE AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

CONTACT_TYPE_2

CONTACT_TYPE

CONTACT_TYPE_1

NA
AORCONT_PHONE_AREA AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

PHONE_AREA_2

PHONE_AREA

PHONE_AREA_1

NA
AORCONT_PHONE_EXT AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT_SLOT

PHONE_EXT

PHONE_EXT_2

PHONE_EXT_1

NA
AORCONT_PHONE_NUMBER AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

PHONE_NUMBER_2

PHONE_NUMBER

PHONE_NUMBER_1

NA
AORCONT_PIDM NA

REPORTING VIEW

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

ENTITY_UID

ENTITY_UID

NA
AORCONT_STAT_CODE_ADDR AOAORGN

REPORTING VIEW

ORGANIZATION_CONTACT_SLOT

ORGANIZATION_CONTACT

ORGANIZATION_CONTACT_SLOT

STATE_PROVINCE_2

STATE_PROVINCE

STATE_PROVINCE_1

NA
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_2

POSTAL_CODE_1

POSTAL_CODE

NA


Ver: 3.1