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

Copyright © 2019, 2025, Oracle and/or its affiliates.