HWR_PER_PRFL_SYNC_VL

Details

• Schema: FUSION

• Object owner: HWR

• Object type: VIEW

Columns

Name
PRFL_ID SOURCE_ID AUTH_TOKEN REFRESH_TOKEN TOKEN_TYPE AUTH_SECRET AUTH_EXPIRATION_DATE STATE_DATA META_DATA STATE DETAIL_STATE_DATA LAST_DWNLD_DT_PRFL_CORE LAST_DWNLD_DT_PRFL_RLTNS LAST_DWNLD_DT_PRFL_POSTS GBL_PRFL_ID LINKED_PRFL_ID LINKED_SOURCE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.PRFL_ID, B.SOURCE_ID, B.AUTH_TOKEN, B.REFRESH_TOKEN, B.TOKEN_TYPE, B.AUTH_SECRET, B.AUTH_EXPIRATION_DATE, B.STATE_DATA, B.META_DATA, B.STATE, S.DETAIL_STATE_DATA, B.LAST_DWNLD_DT_PRFL_CORE, B.LAST_DWNLD_DT_PRFL_RLTNS, B.LAST_DWNLD_DT_PRFL_POSTS, B.GBL_PRFL_ID, B.LINKED_PRFL_ID, B.LINKED_SOURCE_ID, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM HWR_PER_PRFL_SYNC B LEFT JOIN HWR_PER_PRFL_SYNC_STATE S ON B.PRFL_ID = S.PRFL_ID AND B.SOURCE_ID = S.SOURCE_ID