# DW_WS_WORK_PATTERN_SHIFT_D

This table stores work pattern shift information.

## Details

Module: Global Human Resources

## Key Columns

WORK_PATTERN_SHIFT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
WORK_PATTERN_SHIFT_ID | NUMBER | 38 | 0 | True | Unique system generated identifier for a work pattern shift. |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Unique source record identifier for the work pattern shift row. |  |
WORK_PATTERN_ID | NUMBER | 38 | 0 |  | Identifier of the work pattern to which this shift pertains. |  |
DAY_INDEX | NUMBER | 38 | 0 |  | Identifies the day sequence index within the work pattern cycle. |  |
START_TIME_OFFSET | NUMBER | 38 | 0 |  | Offset (in minutes) representing the shift start time. |  |
END_TIME_OFFSET | NUMBER | 38 | 0 |  | Offset (in minutes) representing the shift end time. |  |
BREAK_DURATION | NUMBER | 38 | 0 |  | Unpaid break duration for the shift. |  |
PAID_BREAK_DURATION | NUMBER | 38 | 0 |  | Paid break duration for the shift. |  |
DURATION | NUMBER | 38 | 0 |  | Total work duration for the shift. |  |
ENTERPRISE_ID | NUMBER | 38 | 0 |  | Enterprise identifier. |  |
SHIFT_ID | NUMBER | 38 | 0 |  | Identifier of the shift associated to the work pattern. |  |

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