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