1. Tables and Views for HCM
  2. HWR_RESUME_VL

HWR_RESUME_VL

Details

  • Schema: FUSION

  • Object owner: HWR

  • Object type: VIEW

Columns

Name

RESUME_ID

ORIGINAL_ID

SOURCE_ID

DOWNLOAD_DATE

RESUME_TEXT

RESUME

MIME_TYPE

RESUME_METADATA

CHECKSUM

GBL_PRFL_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

B.RESUME_ID,

B.ORIGINAL_ID,

B.SOURCE_ID,

B.DOWNLOAD_DATE,

B.RESUME_TEXT,

B.RESUME,

B.MIME_TYPE,

B.RESUME_METADATA,

B.CHECKSUM,

X.GBL_PRFL_ID,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN

FROM

HWR_RESUME B

LEFT JOIN

HWR_RESUME_GBL_PRFL_X X ON (B.RESUME_ID = X.RESUME_ID AND B.SOURCE_ID = X.SOURCE_ID)