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   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.