Shift
A shift represents the working time of a workday. Shifts are used in workday patterns to represent the repetitive definition of working and nonworking time. For example, a workday may have one shift starting at 9 a.m. and ending at 5 p.m.
Label, Plural Label
Shift, Shifts
Qualified Label, Qualified Plural Label
Shift, Shifts
Module
oraScmCoreSchedule
Keys
-
$primary: id
Fields
* Field can't be null- categoryCode (enumeration: ShiftCategoryCode)
Abbreviation that identifies the shift categories, such as working from home or office.
Label
Category Code
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: ShiftCategoryCode
Valid Values
- WORK_FROM_HOME
- WORK_FROM_OFFICE
-
- code (string)
Abbreviation that identifies the shift.
Label
Code
- createdBy (string)*
The user who created the record.
Label
Created By
Properties
- not nullable
- description (string)
Description of the shift that you provide when creating an instance.`
Label
Description
Properties
- translatable
- duration (int64)
Value that identifies the duration of the shift.
Label
Duration
- durationUnit (enumeration: TimeUnit)
Unit of time to associate with the time-duration value.
Label
Duration Unit
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: TimeUnit
Valid Values
- DAYS
- HOURS
- MINUTES
- WEEKS
-
- endTime (int64)
Time in microseconds from midnight when the shift ends.
Label
End Time
- 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
- name (string)*
Name of the shift that you provide when creating an instance. This attribute is required.`
Label
Name
Properties
- translatable
- not nullable
- periodTypeCode (enumeration: AvailabilityCode)
Abbreviation that identifies the shift duration, such as work period or off period.
Label
Period Type Code
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: AvailabilityCode
Valid Values
- OFF_PERIOD
- WORK_PERIOD
-
- shiftDetails (object-collection)*
Set of details for decomposing the shift if it has a type of Time with a detail type of Flexible or Punch. These detail types require one or more shift details to be specified.
Label
Shift Details
Cardinality Target Object One to many - Module: oraScmCoreSchedule
- Business Object: ShiftDetail
Additional Mapping Details
Mapped by relationship: shift
- shiftTypeCode (enumeration: PatternTypeCode)*
Abbreviation that identifies the type of shift being created. Valid values are time, duration, and elapsed. This attribute is required.
Label
Shift Type Code
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: PatternTypeCode
Properties
- creatable
- searchable
- sortable
- not nullable
Valid Values
- DURATION
- ELAPSED
- TIME
-
- startTime (int64)
Time in microseconds from midnight when the shift starts.
Label
Start Time
- timeCreated (date-time)*
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- sortable
- not nullable
- timeDetailTypeCode (enumeration: PatternTypeCode)
Abbreviation that identifies the type of Time shift being created. Valid values are Flexible, Punch, and None. This attribute is required for Time shifts.
Label
Shift Detail Type
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: PatternTypeCode
Valid Values
- DURATION
- ELAPSED
- TIME
-
- 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 shift business object.
Label
Shift Translation
Cardinality Target Object One to many - Module: oraScmCoreSchedule
- Business Object: ShiftTranslation
Additional Mapping Details
Mapped by relationship: shift
REST Resources
| Version | REST Resource Name |
|---|---|
| v1 |
shifts |
Business Views
** Available for extracting data- default
Data Source
RDBMS
Fields
- code (string)
Abbreviation that identifies the shift.
Label
Code
- description (string)
Description of the shift that you provide when creating an instance.`
Label
Description
Properties
- translatable
- duration (int64)
Value that identifies the duration of the shift.
Label
Duration
- durationUnit (enumeration: TimeUnit)
Unit of time to associate with the time-duration value.
Label
Duration Unit
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: TimeUnit
Valid Values
- DAYS
- HOURS
- MINUTES
- WEEKS
-
- endTime (int64)
Time in microseconds from midnight when the shift ends.
Label
End Time
- 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
- name (string)
Name of the shift that you provide when creating an instance. This attribute is required.`
Label
Name
Properties
- translatable
- not nullable
- shiftTypeCode (enumeration: PatternTypeCode)
Abbreviation that identifies the type of shift being created. Valid values are time, duration, and elapsed. This attribute is required.
Label
Shift Type Code
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: PatternTypeCode
Properties
- creatable
- searchable
- sortable
- not nullable
Valid Values
- DURATION
- ELAPSED
- TIME
-
- startTime (int64)
Time in microseconds from midnight when the shift starts.
Label
Start Time
- code (string)
- shiftsExtract**
A shift represents the working time of a workday. Shifts are used in workday patterns to represent the repetitive definition of working and nonworking time. For example, a workday may have one shift starting at 9 a.m. and ending at 5 p.m.
Label
Shifts
Data Source
Read-optimized data store
Fields
- categoryCode (enumeration: ShiftCategoryCode)
Abbreviation that identifies the shift categories, such as working from home or office.
Label
Category Code
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: ShiftCategoryCode
Valid Values
- WORK_FROM_HOME
- WORK_FROM_OFFICE
-
- code (string)
Abbreviation that identifies the shift.
Label
Code
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- not nullable
- description (string)
Description of the shift that you provide when creating an instance.`
Label
Description
Properties
- translatable
- duration (int64)
Value that identifies the duration of the shift.
Label
Duration
- durationUnit (enumeration: TimeUnit)
Unit of time to associate with the time-duration value.
Label
Duration Unit
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: TimeUnit
Valid Values
- DAYS
- HOURS
- MINUTES
- WEEKS
-
- endTime (int64)
Time in microseconds from midnight when the shift ends.
Label
End Time
- 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
- name (string)
Name of the shift that you provide when creating an instance. This attribute is required.`
Label
Name
Properties
- translatable
- not nullable
- periodTypeCode (enumeration: AvailabilityCode)
Abbreviation that identifies the shift duration, such as work period or off period.
Label
Period Type Code
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: AvailabilityCode
Valid Values
- OFF_PERIOD
- WORK_PERIOD
-
- shiftTypeCode (enumeration: PatternTypeCode)
Abbreviation that identifies the type of shift being created. Valid values are time, duration, and elapsed. This attribute is required.
Label
Shift Type Code
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: PatternTypeCode
Properties
- creatable
- searchable
- sortable
- not nullable
Valid Values
- DURATION
- ELAPSED
- TIME
-
- startTime (int64)
Time in microseconds from midnight when the shift starts.
Label
Start Time
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- sortable
- not nullable
- timeDetailTypeCode (enumeration: PatternTypeCode)
Abbreviation that identifies the type of Time shift being created. Valid values are Flexible, Punch, and None. This attribute is required for Time shifts.
Label
Shift Detail Type
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: PatternTypeCode
Valid Values
- DURATION
- ELAPSED
- TIME
-
- 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
- categoryCode (enumeration: ShiftCategoryCode)
Other Properties
| Property | Value |
|---|---|
| Application Package Name | ora_scm_core_schedule |
| Extensible | No |