This dimension captures the Previous Employment Details
Module: Recruiting
PROFILE_ITEM_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
PROFILE_ITEM_ID | NUMBER | 38 | 0 | True | Previous Employment Profile Unique Identifier | ||
SOURCE_RECORD_ID | NUMBER | 38 | 0 | unique key | |||
BUSINESS_GROUP_ID | NUMBER | 38 | 0 | Identifier of Enterprise, used for multi-tenancy partitioning | |||
PROFILE_ID | NUMBER | 38 | 0 | Profile Id | |||
DATE_FROM | DATE | Previous Employment Date From | |||||
DATE_TO | DATE | Previous Employment Date To | |||||
ITEM_TEXT_240_1 | VARCHAR2 | 256 | Employer Name | ||||
ITEM_TEXT_240_2 | VARCHAR2 | 256 | Other Job Function | ||||
ITEM_TEXT_240_3 | VARCHAR2 | 256 | Supervisor Phone Number | ||||
ITEM_TEXT_240_4 | VARCHAR2 | 256 | Supervisor Email | ||||
ITEM_TEXT_240_6 | VARCHAR2 | 256 | Supervisor Name | ||||
ITEM_TEXT_240_7 | VARCHAR2 | 256 | Supervisor Title | ||||
ITEM_TEXT_240_8 | VARCHAR2 | 256 | Starting Position | ||||
ITEM_TEXT_240_9 | VARCHAR2 | 256 | Job Title | ||||
ITEM_TEXT_240_10 | VARCHAR2 | 256 | Department | ||||
ITEM_TEXT_240_11 | VARCHAR2 | 256 | Employer Phone | ||||
ITEM_TEXT_240_13 | VARCHAR2 | 256 | Business Type | ||||
ITEM_TEXT_240_14 | VARCHAR2 | 256 | Other Compensation | ||||
ITEM_TEXT_30_1 | VARCHAR2 | 32 | Current Job Flag | ||||
ITEM_TEXT_30_2 | VARCHAR2 | 32 | Supervisor contact allowed flag | ||||
ITEM_TEXT_30_3 | VARCHAR2 | 32 | Employer City | ||||
ITEM_TEXT_30_7 | VARCHAR2 | 32 | Job Function | ||||
ITEM_TEXT_30_8 | VARCHAR2 | 32 | Business Type | ||||
ITEM_TEXT_30_9 | VARCHAR2 | 32 | Full Time Code | ||||
ITEM_TEXT_30_10 | VARCHAR2 | 32 | Internal Flag | ||||
ITEM_DATE_1 | DATE | Start Date | |||||
ITEM_DATE_2 | DATE | End Date | |||||
ITEM_NUMBER_1 | NUMBER | 38 | 0 | Direct Reports | |||
ITEM_NUMBER_8 | NUMBER | 38 | 0 | Job Family ID | |||
ITEM_DECIMAL_1 | NUMBER | Start Compensation | |||||
ITEM_DECIMAL_2 | NUMBER | End Compensation |
Copyright © 2019, 2023, Oracle and/or its affiliates.