DW_PRFL_JOB_WRK_REQ_CRNT_F

This view contains the job profile information for work rewuirement content type

Details

Module: Profile Management

Key Columns

JOB_ID, PROFILE_ITEM_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PROFILE_ITEM_ID NUMBER 38 0 True Key to Profile items DW_PRFL_PROFILE_ITEM_D PROFILE_ITEM_ID
JOB_ID NUMBER 38 0 True Job Identifier DW_JOB_D JOB_ID
SOURCE_RECORD_ID VARCHAR2 64     Unique identifier    
PROFILE_ID NUMBER 38 0   Profile Identifier DW_PRFL_PROFILE_D PROFILE_ID
BUSINESS_GROUP_ID NUMBER 38 0   Business Group    
CONTENT_TYPE_ID NUMBER 38 0   Content type Identifier DW_CONTENT_TYPE_D CONTENT_TYPE_ID
CONTENT_ITEM_ID NUMBER 38 0   Content item Identifier DW_CONTENT_ITEM_D CONTENT_ITEM_ID
SOURCE_TYPE VARCHAR2 32     Source Type. For example, HRTR    
CALENDAR_DATE DATE       Calendar Date    
NAT_TRAVEL_REQUIRED_FLAG VARCHAR2 32          
INTL_TRAVEL_REQUIRED_FLAG VARCHAR2 32          
RELOCATE_FLAG VARCHAR2 32          

Copyright © 2019, 2022, Oracle and/or its affiliates.