This table stores information specific to Shifts
Module: Global Human Resources
SHIFT_ID
| 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.