JDBC Driver for Oracle SCM

Build 22.0.8462

WorkdayPatterns

The Workday Patterns resource defines how to apply one or more shifts to define the working time for any business object using the associated schedule. Workday patterns have length in days, and have associated shifts that detail what days are active within a pattern. Patterns repeat as part of a schedule definition from the schedule start date to the schedule end date, resulting in the shifts forming repeated patterns within the schedule.

Columns

Name Type Description
PatternId [KEY] String The value that uniquely identifies the workday pattern. It is a primary key that the application generates when it creates a pattern. This attribute is required.
Name String The name of the pattern that you provide when creating an instance. This attribute is required.
Description String The description of the pattern that you provide when creating an instance.
PatternTypeCode String The abbreviation that identifies the type of pattern being created. Valid values are Time, Duration, and Elapsed. This attribute is required.
LengthInDays String The value of the number of days in a workday pattern. Specifies how many days the pattern will consume in a schedule and the assigned shifts in the pattern filling in this set of days, before the pattern repeats. This attribute is required.
CreatedBy String CreatedBy of WorkdayPatterns
CreationDate Datetime CreationDate of WorkdayPatterns
LastUpdateDate Datetime LastUpdateDate of WorkdayPatterns
LastUpdatedBy String LastUpdatedBy of WorkdayPatterns

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