HWR_CONTACT_INFO_VL

Details

• Schema: FUSION

• Object owner: HWR

• Object type: VIEW

Columns

Name
CONTACT_INFO_ID SOURCE_ID ADDRESS EMAIL HASHING_TYPE ONLINE_ACCOUNT ONLINE_ACCT_HOMEPAGE PHONE URL LATITUDE LONGITUDE ADDRESS_LINE_1 ADDRESS_LINE_2 ADDRESS_LINE_3 ADDRESS_LINE_4 BUILDING FLOOR_NUMBER TOWN_OR_CITY REGION_1 REGION_2 REGION_3 COUNTRY POSTAL_CODE LONG_POSTAL_CODE TIMEZONE_CODE DERIVED_LOCALE PRFL_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.CONTACT_INFO_ID , B.SOURCE_ID , B.ADDRESS , B.EMAIL , B.HASHING_TYPE , B.ONLINE_ACCOUNT , B.ONLINE_ACCT_HOMEPAGE , B.PHONE , B.URL , B.LATITUDE , B.LONGITUDE , B.ADDRESS_LINE_1 , B.ADDRESS_LINE_2 , B.ADDRESS_LINE_3 , B.ADDRESS_LINE_4 , B.BUILDING , B.FLOOR_NUMBER , B.TOWN_OR_CITY , B.REGION_1 , B.REGION_2 , B.REGION_3 , B.COUNTRY , B.POSTAL_CODE , B.LONG_POSTAL_CODE , B.TIMEZONE_CODE , B.DERIVED_LOCALE , X.PRFL_ID , B.CREATED_BY , B.CREATION_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATE_LOGIN FROM HWR_CONTACT_INFO_B B LEFT JOIN HWR_CONTACT_INFO_PRFL_X X ON (B.CONTACT_INFO_ID = X.CONTACT_INFO_ID AND B.SOURCE_ID = X.SOURCE_ID)