DW_PRFL_PRSN_WRK_REQ_D

This dimension holds information about Person Profile type for Work Requirement

Details

Module: Profile Management

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 Key to Profile items
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. Primary Key consisting of Assignment Identifier and Calendar Date
PROFILE_ID NUMBER 38 0 Primary key of Profile DW_PRFL_PROFILE_D PROFILE_ID
BUSINESS_GROUP_ID NUMBER 38 0 Business Group
SECTION_ID NUMBER 38 0 Section Identifier
DATE_FROM DATE Date From
DATE_TO DATE Date To
QUALIFIER_ID1 NUMBER 38 0 The instance qualifier to use for the item
SOURCE_TYPE VARCHAR2 32 Source Type. For example, HRTR
CONTENT_TYPE_ID NUMBER 38 0 Content type Identifier DW_CONTENT_TYPE_D CONTENT_TYPE_ID
CONTENT_ITEM_ID NUMBER 38 0 Content item Identifier DW_CONTENT_ITEM_D CONTENT_ITEM_ID
NAT_TRAVEL_FLAG VARCHAR2 32 Domestic Travel
INTL_TRAVEL_FLAG VARCHAR2 32 International Travel
RELOCATE_FLAG VARCHAR2 32 Willing to Relocate
MINIMUM_PAY NUMBER 38 0 Minimum Pay
PAY_FREQUENCY VARCHAR2 32 Pay Frequency
EXCLUDED_LOCATION_ID1 NUMBER 38 0 Excluded Location1
EXCLUDED_LOCATION_ID2 NUMBER 38 0 Excluded Location2
EXCLUDED_LOCATION_ID3 NUMBER 38 0 Excluded Location3
EXCLUDED_LOCATION_ID4 NUMBER 38 0 Excluded Location4
PREFERRED_LOCATION_ID1 NUMBER 38 0 Preferred Location1
PREFERRED_LOCATION_ID2 NUMBER 38 0 Preferred Location2
PREFERRED_LOCATION_ID3 NUMBER 38 0 Preferred Location3
PREFERRED_LOCATION_ID4 NUMBER 38 0 Preferred Location4
FLEXIBLE_WORK_FLAG VARCHAR2 32 Work Flexible Schedule