Full expand

Full collapse

WorkdayPattern

Jump to

• Fields
• REST Resources
• Business Views
• Other Properties

Workday patterns define working time in a schedule. Each pattern has a length in days and a set of associated shifts that detail which days and time are working and nonworking. 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 in the schedule. For example, most patterns have a length of seven days to represent a week and will have one or more shifts assigned to represent the expected working days and times in that week.

Label, Plural Label

Workday Pattern, Workday Patterns

Qualified Label, Qualified Plural Label

Workday Pattern, Workday Patterns

Module

oraScmCoreSchedule

Keys

• $primary: id

Expand all

Collapse all

Fields

* Field can't be null

• createdBy (string)*

  The user who created the record.

  Label

  Created By

  Properties

  • not nullable
• description (string)

  Description of the pattern that you provide when creating an instance.

  Label

  Description

  Properties

  • translatable
• id (int64)*

  Value that uniquely identifies the workday pattern. It's a primary key that the application generates when it creates a pattern. This attribute is required.

  Label

  ID

  Properties

  • creatable
  • searchable
  • sortable
  • not nullable
• lengthInDays (int64)

  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.

  Label

  Length in Days

• name (string)*

  Name of the pattern that you provide when creating an instance. This attribute is required.

  Label

  Name

  Properties

  • translatable
  • not nullable
• patternTypeCode (enumeration: PatternTypeCode)*

  Abbreviation that identifies the type of pattern being created. Valid values are time, duration, and elapsed. This attribute is required.

  Label

  Pattern Type Code

  Type

  • Module: oraScmCoreSchedule

  • Enumeration Type: PatternTypeCode

  Properties

  • creatable
  • searchable
  • sortable
  • not nullable

  Valid Values

  • DURATION
  • ELAPSED
  • TIME
• timeCreated (date-time)*

  The date and time when the record was created.

  Label

  Creation Date

  Properties

  • searchable
  • sortable
  • not nullable
• timeUpdated (date-time)*

  The date and time when the record was last updated.

  Label

  Last Updated Date

  Properties

  • searchable
  • sortable
  • not nullable
• updatedBy (string)*

  The user who last updated the record.

  Label

  Last Updated By

  Properties

  • not nullable
• workdayPatternShifts (object-collection)*

  Set of shifts associated to a workday pattern.

  Label

  Workday Pattern Shifts

  Cardinality	Target Object
  One to many	Module: oraScmCoreSchedule Business Object: WorkdayPatternShift

  Additional Mapping Details

  Mapped by relationship: workdayPattern

• $sourceLang (string)*

  The language in which the values of the translatable columns were created, updated, or copied from.

  Label

  Source Language

  Properties

  • translatable
  • not nullable
• $translations (object-collection)*

  Translations for the workday pattern business object.

  Label

  Workday Pattern Translation

  Cardinality	Target Object
  One to many	Module: oraScmCoreSchedule Business Object: WorkdayPatternTranslation

  Additional Mapping Details

  Mapped by relationship: workdayPattern

REST Resources

Version	REST Resource Name
v1	workdayPatterns

Expand all

Collapse all

Business Views

** Available for extracting data

• default

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • description (string)

    Description of the pattern that you provide when creating an instance.

    Label

    Description

    Properties

    • translatable
  • id (int64)

    Value that uniquely identifies the workday pattern. It's a primary key that the application generates when it creates a pattern. This attribute is required.

    Label

    ID

    Properties

    • creatable
    • searchable
    • sortable
    • not nullable
  • lengthInDays (int64)

    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.

    Label

    Length in Days

  • name (string)

    Name of the pattern that you provide when creating an instance. This attribute is required.

    Label

    Name

    Properties

    • translatable
    • not nullable
  • patternTypeCode (enumeration: PatternTypeCode)

    Abbreviation that identifies the type of pattern being created. Valid values are time, duration, and elapsed. This attribute is required.

    Label

    Pattern Type Code

    Type

    • Module: oraScmCoreSchedule

    • Enumeration Type: PatternTypeCode

    Properties

    • creatable
    • searchable
    • sortable
    • not nullable

    Valid Values

    • DURATION
    • ELAPSED
    • TIME
• workdayPatternsExtract**

  Workday patterns define working time in a schedule. Each pattern has a length in days and a set of associated shifts that detail which days and time are working and nonworking. 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 in the schedule. For example, most patterns have a length of seven days to represent a week and will have one or more shifts assigned to represent the expected working days and times in that week.

  Label

  Workday Patterns

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • description (string)

    Description of the pattern that you provide when creating an instance.

    Label

    Description

    Properties

    • translatable
  • id (int64)

    Value that uniquely identifies the workday pattern. It's a primary key that the application generates when it creates a pattern. This attribute is required.

    Label

    ID

    Properties

    • creatable
    • searchable
    • sortable
    • not nullable
  • lengthInDays (int64)

    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.

    Label

    Length in Days

  • name (string)

    Name of the pattern that you provide when creating an instance. This attribute is required.

    Label

    Name

    Properties

    • translatable
    • not nullable
  • patternTypeCode (enumeration: PatternTypeCode)

    Abbreviation that identifies the type of pattern being created. Valid values are time, duration, and elapsed. This attribute is required.

    Label

    Pattern Type Code

    Type

    • Module: oraScmCoreSchedule

    • Enumeration Type: PatternTypeCode

    Properties

    • creatable
    • searchable
    • sortable
    • not nullable

    Valid Values

    • DURATION
    • ELAPSED
    • TIME
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • sortable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

Other Properties

Property	Value
Application Package Name	ora_scm_core_schedule
Extensible	No

Back to Top