It stores Profile Work requirment Details
Module: Recruiting
PROFILE_ITEM_ID
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 | 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, 2023, Oracle and/or its affiliates.