JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

WorkdayPatterns

WorkdayPatterns

Columns

Name Type Description
PatternId [KEY] Long PatternId of WorkdayPatterns
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 Long 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

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839