This table stores work pattern shift information.
Module: Global Human Resources
WORK_PATTERN_SHIFT_ID
| 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.