Full expand

Full collapse

ScheduleException

Jump to

• Fields
• REST Resources
• Business Views
• Other Properties

A schedule exception defines a global change to the working time that you assign to one or more schedules. For example, a holiday. When assigned to a schedule, the exception updates the working time for all business objects using the associated schedule.

Label, Plural Label

Schedule Exception, Schedule Exceptions

Qualified Label, Qualified Plural Label

Schedule Exception, Schedule Exceptions

Module

oraScmCoreSchedule

Keys

• $primary: id

Expand all

Collapse all

Fields

* Field can't be null

• allDayFlag (boolean)*

  Contains one of the following values: true or false. If true, then the exception is for the entire day and the Exception Start and the Exception End values are dates. If false, then the exception is for a subset of hours within each day in the exception range and the Exception Start and the Exception End values include date and time values. The default value is false.

  Label

  All Day Flag

  Properties

  • not nullable
• categoryCode (enumeration: ExceptionCategoryCode)

  Abbreviation that identifies the category, such as holiday and training.

  Label

  Category Code

  Type

  • Module: oraScmCoreSchedule

  • Enumeration Type: ExceptionCategoryCode

  Valid Values

  • HOLIDAY
  • TRAINING
• createdBy (string)*

  The user who created the record.

  Label

  Created By

  Properties

  • not nullable
• description (string)

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

  Label

  Description

  Properties

  • translatable
• exceptionEndDate (date-time)*

  Date when the schedule no longer uses the exception.

  Label

  Exception End Date

  Properties

  • creatable
  • not nullable
• exceptionStartDate (date-time)*

  Date when the schedule starts to use the exception.

  Label

  Exception Start Date

  Properties

  • creatable
  • not nullable
• id (int64)*

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

  Label

  ID

  Properties

  • creatable
  • searchable
  • sortable
  • not nullable
• name (string)*

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

  Label

  Name

  Properties

  • translatable
  • not nullable
• periodTypeCode (enumeration: AvailabilityCode)*

  Abbreviation that identifies the type of period, such as off period and work period.

  Label

  Period Type Code

  Type

  • Module: oraScmCoreSchedule

  • Enumeration Type: AvailabilityCode

  Properties

  • not nullable

  Valid Values

  • OFF_PERIOD
  • WORK_PERIOD
• shortCode (string)

  Abbreviation that identifies the exception that's displayed.

  Label

  Short Code

• 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
• $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 schedule exception business object.

  Label

  Schedule Exception Translation

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

  Additional Mapping Details

  Mapped by relationship: scheduleException

REST Resources

Version	REST Resource Name
v1	scheduleExceptions

Expand all

Collapse all

Business Views

** Available for extracting data

• default

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • allDayFlag (boolean)

    Contains one of the following values: true or false. If true, then the exception is for the entire day and the Exception Start and the Exception End values are dates. If false, then the exception is for a subset of hours within each day in the exception range and the Exception Start and the Exception End values include date and time values. The default value is false.

    Label

    All Day Flag

    Properties

    • not nullable
  • description (string)

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

    Label

    Description

    Properties

    • translatable
  • exceptionEndDate (date-time)

    Date when the schedule no longer uses the exception.

    Label

    Exception End Date

    Properties

    • creatable
    • not nullable
  • exceptionStartDate (date-time)

    Date when the schedule starts to use the exception.

    Label

    Exception Start Date

    Properties

    • creatable
    • not nullable
  • id (int64)

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

    Label

    ID

    Properties

    • creatable
    • searchable
    • sortable
    • not nullable
  • name (string)

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

    Label

    Name

    Properties

    • translatable
    • not nullable
• scheduleExceptionsExtract**

  A schedule exception defines a global change to the working time that you assign to one or more schedules. For example, a holiday. When assigned to a schedule, the exception updates the working time for all business objects using the associated schedule.

  Label

  Schedule Exceptions

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • allDayFlag (boolean)

    Contains one of the following values: true or false. If true, then the exception is for the entire day and the Exception Start and the Exception End values are dates. If false, then the exception is for a subset of hours within each day in the exception range and the Exception Start and the Exception End values include date and time values. The default value is false.

    Label

    All Day Flag

    Properties

    • not nullable
  • categoryCode (enumeration: ExceptionCategoryCode)

    Abbreviation that identifies the category, such as holiday and training.

    Label

    Category Code

    Type

    • Module: oraScmCoreSchedule

    • Enumeration Type: ExceptionCategoryCode

    Valid Values

    • HOLIDAY
    • TRAINING
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • description (string)

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

    Label

    Description

    Properties

    • translatable
  • exceptionEndDate (date-time)

    Date when the schedule no longer uses the exception.

    Label

    Exception End Date

    Properties

    • creatable
    • not nullable
  • exceptionStartDate (date-time)

    Date when the schedule starts to use the exception.

    Label

    Exception Start Date

    Properties

    • creatable
    • not nullable
  • id (int64)

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

    Label

    ID

    Properties

    • creatable
    • searchable
    • sortable
    • not nullable
  • name (string)

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

    Label

    Name

    Properties

    • translatable
    • not nullable
  • periodTypeCode (enumeration: AvailabilityCode)

    Abbreviation that identifies the type of period, such as off period and work period.

    Label

    Period Type Code

    Type

    • Module: oraScmCoreSchedule

    • Enumeration Type: AvailabilityCode

    Properties

    • not nullable

    Valid Values

    • OFF_PERIOD
    • WORK_PERIOD
  • shortCode (string)

    Abbreviation that identifies the exception that's displayed.

    Label

    Short Code

  • 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