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