DW_WORK_REQUIREMENT_D
It stores Profile Work requirment Details
Details
Module: Recruiting
Key Columns
PROFILE_ITEM_ID
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 |