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