ADO.NET Provider for Oracle Fusion Cloud SCM

Build 25.0.9434

ShiftsshiftDetails

Breaks down shifts into detailed time segments for precise schedule management.

Columns

Name Type Description
ShiftsShiftId [KEY] Long Unique identifier linking this shift detail entry to a specific shift.
ShiftDetailsId [KEY] Long Unique identifier for the shift detail entry.
Name String The name assigned to the shift detail.
Day Long Indicates the day of the shift detail, applicable for shifts longer than 24 hours.
StartTime String The time when the shift detail starts, formatted as 'hh:mm AM/PM'.
Duration Decimal Total duration of the shift detail based on its start time and length.
DurationUnit String Unit of time associated with the shift detail duration (for example, hours, minutes).
MinimumBreakMinutes Long Minimum number of minutes allowed for a break within this shift detail.
MaximumBreakMinutes Long Maximum number of minutes allowed for a break within this shift detail.
CoreWorkFlag Bool Indicates whether the shift detail represents core working time. 'True' means core working time; 'False' means not core working time (default: False).
CreatedBy String Username or system entity that created this shift detail entry.
CreationDate Datetime Timestamp indicating when this shift detail entry was initially created.
LastUpdateDate Datetime Timestamp indicating when this shift detail entry was last updated.
LastUpdatedBy String Username or system entity that last modified this shift detail entry.
Finder String A system-defined query or lookup used to retrieve shift detail records.
ShiftId Long Unique identifier linking this shift detail entry to its parent shift.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434