DW_PRFL_PRSN_WRK_REQ_D

This dimension holds information about Person Profile type for Work Requirement

Details

Module: Profile Management

Key Columns

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    
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. Primary Key consisting of Assignment Identifier and Calendar Date    
PROFILE_ID NUMBER 38 0   Primary key of Profile DW_PRFL_PROFILE_D PROFILE_ID
BUSINESS_GROUP_ID NUMBER 38 0   Business Group    
SECTION_ID NUMBER 38 0   Section Identifier    
DATE_FROM DATE       Date From    
DATE_TO DATE       Date To    
QUALIFIER_ID1 NUMBER 38 0   The instance qualifier to use for the item    
SOURCE_TYPE VARCHAR2 32     Source Type. For example, HRTR    
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
NAT_TRAVEL_FLAG VARCHAR2 32     Domestic Travel    
INTL_TRAVEL_FLAG VARCHAR2 32     International Travel    
RELOCATE_FLAG VARCHAR2 32     Willing to Relocate    
MINIMUM_PAY NUMBER 38 0   Minimum Pay    
PAY_FREQUENCY VARCHAR2 32     Pay Frequency    
EXCLUDED_LOCATION_ID1 NUMBER 38 0   Excluded Location1    
EXCLUDED_LOCATION_ID2 NUMBER 38 0   Excluded Location2    
EXCLUDED_LOCATION_ID3 NUMBER 38 0   Excluded Location3    
EXCLUDED_LOCATION_ID4 NUMBER 38 0   Excluded Location4    
PREFERRED_LOCATION_ID1 NUMBER 38 0   Preferred Location1    
PREFERRED_LOCATION_ID2 NUMBER 38 0   Preferred Location2    
PREFERRED_LOCATION_ID3 NUMBER 38 0   Preferred Location3    
PREFERRED_LOCATION_ID4 NUMBER 38 0   Preferred Location4    
FLEXIBLE_WORK_FLAG VARCHAR2 32     Work Flexible Schedule    

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