# DW_PREVIOUS_EMPLOYMENT_D

This dimension captures the Previous Employment 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 | Previous Employment Profile Unique Identifier |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | 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 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, 2025, Oracle and/or its affiliates.