Full expand

Full collapse

WorkdayPatternShift

Jump to

• Fields
• Reference Objects
• REST Resources
• Business Views
• Other Properties

Workday patterns have one or more shifts specifying how to repeat working and nonworking time over the duration of the pattern. For example, a pattern for a five-day work week might have one shift from 9 a.m. to 5 p.m. used for five days of the seven-day length. A pattern for a 24-hour workday operating seven days of the week might have three shifts used on all seven days of the pattern length.

Label, Plural Label

Workday Pattern Shift, Workday Pattern Shifts

Qualified Label, Qualified Plural Label

Workday Pattern Shift, Workday Pattern Shifts

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
• endDay (int64)

  Day within the pattern when you stop using the shift.

  Label

  End Day

• id (int64)*

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

  Label

  ID

  Properties

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

  Number that identifies the order of the assigned shift for the duration pattern. This number isn't currently used for time or elapsed patterns.

  Label

  Sequence Number

• startDay (int64)

  Day within the pattern when you begin using the shift.

  Label

  Start Day

• 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

Expand all

Collapse all

Reference Objects

• shift (object)

  Reference to the shift assigned to the workday pattern.

  Label

  Shift

  Cardinality	Target Object
  One to One	Module: oraScmCoreSchedule Business Object: Shift

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  shiftId	id

• workdayPattern (object)

  Object reference to the associated parent workday pattern.

  Label

  Workday Pattern

  Cardinality	Target Object
  One to One	Module: oraScmCoreSchedule Business Object: WorkdayPattern

  Additional Mapping Details

  Mapped by relationship: workdayPatternShifts

  Field in Current Object	Field in Target Object
  patternId	id

REST Resources

Version	REST Resource Name
v1	workdayPatternShifts

Expand all

Collapse all

Business Views

** Available for extracting data

• default

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • id (int64)

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

    Label

    ID

    Properties

    • creatable
    • searchable
    • sortable
    • not nullable
• workdayPatternShiftsExtract**

  Workday patterns have one or more shifts specifying how to repeat working and nonworking time over the duration of the pattern. For example, a pattern for a five-day work week might have one shift from 9 a.m. to 5 p.m. used for five days of the seven-day length. A pattern for a 24-hour workday operating seven days of the week might have three shifts used on all seven days of the pattern length.

  Label

  Workday Pattern Shifts

  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
  • endDay (int64)

    Day within the pattern when you stop using the shift.

    Label

    End Day

  • id (int64)

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

    Label

    ID

    Properties

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

    Number that identifies the order of the assigned shift for the duration pattern. This number isn't currently used for time or elapsed patterns.

    Label

    Sequence Number

  • startDay (int64)

    Day within the pattern when you begin using the shift.

    Label

    Start Day

  • 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

  Expand all

  Collapse all

  Reference Object

  • shift (Shift)

    Reference to the shift assigned to the workday pattern.

    Business Object

    Shift

    Expand all

    Collapse all

    Fields

    • id (int64)

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

      Label

      ID

      Properties

      • creatable
      • searchable
      • sortable
      • not nullable

  • workdayPattern (WorkdayPattern)

    Object reference to the associated parent workday pattern.

    Business Object

    WorkdayPattern

    Expand all

    Collapse all

    Fields

    • 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

Other Properties

Property	Value
Application Package Name	ora_scm_core_schedule
Extensible	No

Back to Top