DW_WORK_REQUIREMENT_D

It stores Profile Work requirment Details

Details

Module: Recruiting

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 Profile Item Identifier    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. unique key    
BUSINESS_GROUP_ID NUMBER 38 0   Identifier of Enterprise, used for multi-tenancy partitioning.    
PROFILE_ID NUMBER 38 0   Profile Identifier    
DATE_FROM DATE       Date From    
DATE_TO DATE       Date To    
IMPORTANCE NUMBER 38 0   Importance    
ITEM_TEXT_240_1 VARCHAR2 256     Relocation Reason    
ITEM_TEXT_30_1 VARCHAR2 32     National Travel Flag    
ITEM_TEXT_30_2 VARCHAR2 32     National Travel Frequency    
ITEM_TEXT_30_3 VARCHAR2 32     International Travel Flag    
ITEM_TEXT_30_4 VARCHAR2 32     International Travel Frequency    
ITEM_TEXT_30_5 VARCHAR2 32     Relocation Flag    
ITEM_TEXT_30_6 VARCHAR2 32     All Location Flag    
ITEM_TEXT_30_7 VARCHAR2 32     Temporary Assignment Flag    
ITEM_TEXT_30_8 VARCHAR2 32     Part-Time Assignment Flag    
ITEM_TEXT_30_9 VARCHAR2 32     Flexible Work Flag    
ITEM_TEXT_30_10 VARCHAR2 32     Currency Code    
ITEM_TEXT_30_11 VARCHAR2 32     Pay Frequency    
ITEM_NUMBER_1 NUMBER 38 0   First Preferred Location for Person Profile and Work Duration in Months for Model Profile    
ITEM_NUMBER_2 NUMBER 38 0   Second Preferred Location for Person Profile and Work Duration in Years for Model Profile    
ITEM_NUMBER_3 NUMBER 38 0   Preferred Location 3    
ITEM_NUMBER_4 NUMBER 38 0   Preferred Location ID 4    
ITEM_NUMBER_5 NUMBER 38 0   Excluded Location ID1    
ITEM_NUMBER_6 NUMBER 38 0   Excluded Location ID2    
ITEM_NUMBER_7 NUMBER 38 0   Excluded Location ID3    
ITEM_NUMBER_8 NUMBER 38 0   Excluded Location ID4    
ITEM_NUMBER_9 NUMBER 38 0   Minimum Pay    
ITEM_NUMBER_10 NUMBER 38 0   Relocate Duration    

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