# 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, 2025, Oracle and/or its affiliates.