# DW_WS_SHIFT_D

This table stores information specific to Shifts

## Details

Module: Global Human Resources

## Key Columns

SHIFT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
SHIFT_ID | NUMBER | 38 | 0 | True | Unique identifier for the shift. |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Unique source record identifier for the shift row. |  |
SHIFT_CODE | VARCHAR2 | 32 |  |  | Unique code entered when creating a shift to help users identify the shift. | DW_WS_SHIFT_TYPE_D_TL | EXTENDED_LOOKUP_CODE_ID
START_TIME_OFFSET | NUMBER | 38 | 0 |  | Offset from midnight saved in minutes defining the start time of the shift. |  |
END_TIME_OFFSET | NUMBER | 38 | 0 |  | Offset from midnight saved in minutes defining the end time of the shift. |  |
WORK_DURATION | NUMBER | 38 | 0 |  | Work duration of the shift in minutes. |  |
BREAK_DURATION | NUMBER | 38 | 0 |  | Break duration of the shift in minutes. |  |
SHIFT_CATEGORY | VARCHAR2 | 32 |  |  | A category such as day or night that helps classify the shifts. | DW_WS_SHIFTS_CATEGORY_D_TL | SHIFTS_CATEGORY
ACTIVE_FLAG | VARCHAR2 | 16 |  |  | Flag indicating whether the shift is active or inactive. | DW_YN_LKP_TL | YN_LKP_CODE
END_PLUS_DAYS | NUMBER | 38 | 0 |  | Identifies whether the end time offset comes one day after the start time offset (1) or on the same day (0). |  |
ENTERPRISE_ID | NUMBER | 38 | 0 |  | Enterprise identifier. |  |

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