ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

WorkdayPatternsworkdayPatternShifts

Lists shifts assigned to specific workday patterns, supporting detailed scheduling configurations.

Columns

Name Type Description
WorkdayPatternsPatternId [KEY] Long Unique identifier linking this shift entry to a specific workday pattern.
PatternDetailId [KEY] Long Unique identifier for the specific shift detail within the workday pattern.
SequenceNumber Long Order number of the assigned shift within the Duration pattern. This is not currently used for Time or Elapsed patterns.
StartDay Long The day within the pattern when this shift begins.
EndDay Long The day within the pattern when this shift ends.
ShiftId Long Unique identifier for the shift assigned to the pattern. This attribute is required.
ShiftName String The name of the shift associated with the workday pattern.
CreatedBy String Username or system entity that created this workday pattern shift entry.
CreationDate Datetime Timestamp indicating when this workday pattern shift entry was initially created.
LastUpdateDate Datetime Timestamp indicating when this workday pattern shift entry was last updated.
LastUpdatedBy String Username or system entity that last modified this workday pattern shift entry.
Finder String A system-defined query or lookup used to retrieve workday pattern shift records.
PatternId Long Unique identifier for the workday pattern associated with this shift.

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