JDBC Driver for Oracle SCM

Build 22.0.8462

Shifts

The Shifts resource gets the values for the working time for any business object using the associated schedule. Shifts repeat in Workday Patterns that repeat as part of a Schedule definition. Business objects that reference Schedule use the Shift definition to know which days and times are the working and non-working periods.

Columns

Name Type Description
ShiftId [KEY] String The value that uniquely identifies the shift. It is a primary key that the application generates when it creates a shift. This attribute is required.
Name String The name of the shift that you provide when creating an instance. This attribute is required.
Description String The description of the shift that you provide when creating an instance.
Code String The abbreviation that identifies the shift.
StartTime String The time when the shift starts. The text is formatted as
EndTime String EndTime of Shifts
Duration String The value that identifies the duration of the shift.
DurationUnit String The unit of time to associate with the time-duration value.
CategoryCode String The abbreviation that identifies the shift categories, such as working from home or office.
PeriodTypeCode String The abbreviation that identifies the shift duration, such as work period or off period.
ShiftTypeCode String The abbreviation that identifies the type of shift being created. Valid values are Time, Duration, and Elapsed. This attribute is required.
ShiftDetailTypeCode String The abbreviation that identifies the type of Time shift being created. Valid values are Flexible, Punch, and None. This attribute is required for Time shifts.
CreatedBy String CreatedBy of Shifts
CreationDate Datetime CreationDate of Shifts
LastUpdateDate Datetime LastUpdateDate of Shifts
LastUpdatedBy String LastUpdatedBy of Shifts

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462