Schedule
A schedule defines the working and nonworking period of time and may be assigned to one or more business objects. For example a schedule might represent a workweek of five days, having two weekend days as nonworking time from January 1, 2020 to December 31, 2050.
Label, Plural Label
Schedule, Schedules
Qualified Label, Qualified Plural Label
Schedule, Schedules
Module
oraScmCoreSchedule
Keys
-
$primary: id
Fields
* Field can't be null- activeFlag (boolean)
Contains one of the following values: true or false. If true, then the schedule is active and may be used. If false, then the schedule isn't active. The default value is true.
Label
Active Flag
- categoryCode (enumeration: ScheduleCategoryCode)
Abbreviation that identifies the category. For example, Pager, UK SSP, or Work.
Label
Category Code
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: ScheduleCategoryCode
Valid Values
- PAGER
- WORK
-
- createdBy (string)*
The user who created the record.
Label
Created By
Properties
- not nullable
- description (string)
Description of the schedule that the user specifies when creating an instance.
Label
Description
Properties
- translatable
- effectiveFromDate (date)*
Date when the modeling of working and nonworking time using the assigned workday patterns starts. This attribute is required.
Label
Effective from Date
Properties
- creatable
- not nullable
- effectiveToDate (date)*
Date when the modeling of working and nonworking time using the assigned workday patterns stops. This attribute is required.
Label
Effective to Date
Properties
- creatable
- not nullable
- firstDayOfWorkWeekCode (string)*
Specifies the day of the week which identifies the start of a work week. Valid values are SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY and SATURDAY. The default is MONDAY.
Label
First Day of Week Code
Properties
- not nullable
- id (int64)*
Value that uniquely identifies the schedule. It's a primary key that the application generates when it creates a schedule. This attribute is required.
Label
ID
Properties
- creatable
- searchable
- sortable
- not nullable
- name (string)*
Name of the schedule that the user specifies when creating an instance. This attribute is required.
Label
Name
Properties
- translatable
- not nullable
- quarterlyTypeCode (enumeration: ScheduleQuarterCode)
Value that defines the model of a quarter for a schedule. For example, 13 periods, 4 Weeks - 4 Weeks - 5 Weeks, 4 Weeks - 5 Weeks - 4 Weeks, 5 Weeks - 4 Weeks - 4 Weeks, or Monthly.
Label
Quarterly Type Code
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: ScheduleQuarterCode
Valid Values
- 13_PERIODS
- 4/4/5
- 4/5/4
- 5/4/4
- MONTHLY
-
- scheduleAssignedExceptions (object-collection)*
Set of schedule exceptions associated to a schedule.
Label
Schedule Assigned Exceptions
Cardinality Target Object One to many - Module: oraScmCoreSchedule
- Business Object: ScheduleAssignedException
Additional Mapping Details
Mapped by relationship: schedule
- scheduleAssignedWorkdayPatterns (object-collection)*
Set of workday patterns associated to a schedule.
Label
Schedule Assigned Workday Patterns
Cardinality Target Object One to many - Module: oraScmCoreSchedule
- Business Object: ScheduleAssignedWorkdayPattern
Additional Mapping Details
Mapped by relationship: schedule
- scheduleTypeCode (enumeration: PatternTypeCode)*
Specifies the type of schedule being created. Valid values are Time, Duration, and Elapsed. This attribute is required.
Label
Schedule Type Code
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: PatternTypeCode
Properties
- 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
- $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)*
The translatable information for the business object. Each business object record will have a set of translation records, one per installed language. Translation records are automatically maintained as you manage the business object.
Label
Schedule Translation
Cardinality Target Object One to many - Module: oraScmCoreSchedule
- Business Object: ScheduleTranslation
Additional Mapping Details
Mapped by relationship: schedule
REST Resources
| Version | REST Resource Name |
|---|---|
| v1 |
schedules |
Business Views
** Available for extracting data- default
Data Source
RDBMS
Fields
- description (string)
Description of the schedule that the user specifies when creating an instance.
Label
Description
Properties
- translatable
- effectiveFromDate (date)
Date when the modeling of working and nonworking time using the assigned workday patterns starts. This attribute is required.
Label
Effective from Date
Properties
- creatable
- not nullable
- effectiveToDate (date)
Date when the modeling of working and nonworking time using the assigned workday patterns stops. This attribute is required.
Label
Effective to Date
Properties
- creatable
- not nullable
- id (int64)
Value that uniquely identifies the schedule. It's a primary key that the application generates when it creates a schedule. This attribute is required.
Label
ID
Properties
- creatable
- searchable
- sortable
- not nullable
- name (string)
Name of the schedule that the user specifies when creating an instance. This attribute is required.
Label
Name
Properties
- translatable
- not nullable
- quarterlyTypeCode (enumeration: ScheduleQuarterCode)
Value that defines the model of a quarter for a schedule. For example, 13 periods, 4 Weeks - 4 Weeks - 5 Weeks, 4 Weeks - 5 Weeks - 4 Weeks, 5 Weeks - 4 Weeks - 4 Weeks, or Monthly.
Label
Quarterly Type Code
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: ScheduleQuarterCode
Valid Values
- 13_PERIODS
- 4/4/5
- 4/5/4
- 5/4/4
- MONTHLY
-
- scheduleTypeCode (enumeration: PatternTypeCode)
Specifies the type of schedule being created. Valid values are Time, Duration, and Elapsed. This attribute is required.
Label
Schedule Type Code
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: PatternTypeCode
Properties
- searchable
- sortable
- not nullable
Valid Values
- DURATION
- ELAPSED
- TIME
-
- description (string)
- schedulesExtract**
A schedule defines the working and nonworking period of time and may be assigned to one or more business objects. For example a schedule might represent a workweek of five days, having two weekend days as nonworking time from January 1, 2020 to December 31, 2050.
Label
Schedules
Data Source
Read-optimized data store
Fields
- activeFlag (boolean)
Contains one of the following values: true or false. If true, then the schedule is active and may be used. If false, then the schedule isn't active. The default value is true.
Label
Active Flag
- categoryCode (enumeration: ScheduleCategoryCode)
Abbreviation that identifies the category. For example, Pager, UK SSP, or Work.
Label
Category Code
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: ScheduleCategoryCode
Valid Values
- PAGER
- WORK
-
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- not nullable
- description (string)
Description of the schedule that the user specifies when creating an instance.
Label
Description
Properties
- translatable
- effectiveFromDate (date)
Date when the modeling of working and nonworking time using the assigned workday patterns starts. This attribute is required.
Label
Effective from Date
Properties
- creatable
- not nullable
- effectiveToDate (date)
Date when the modeling of working and nonworking time using the assigned workday patterns stops. This attribute is required.
Label
Effective to Date
Properties
- creatable
- not nullable
- id (int64)
Value that uniquely identifies the schedule. It's a primary key that the application generates when it creates a schedule. This attribute is required.
Label
ID
Properties
- creatable
- searchable
- sortable
- not nullable
- name (string)
Name of the schedule that the user specifies when creating an instance. This attribute is required.
Label
Name
Properties
- translatable
- not nullable
- quarterlyTypeCode (enumeration: ScheduleQuarterCode)
Value that defines the model of a quarter for a schedule. For example, 13 periods, 4 Weeks - 4 Weeks - 5 Weeks, 4 Weeks - 5 Weeks - 4 Weeks, 5 Weeks - 4 Weeks - 4 Weeks, or Monthly.
Label
Quarterly Type Code
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: ScheduleQuarterCode
Valid Values
- 13_PERIODS
- 4/4/5
- 4/5/4
- 5/4/4
- MONTHLY
-
- scheduleTypeCode (enumeration: PatternTypeCode)
Specifies the type of schedule being created. Valid values are Time, Duration, and Elapsed. This attribute is required.
Label
Schedule Type Code
Type
-
Module: oraScmCoreSchedule
-
Enumeration Type: PatternTypeCode
Properties
- 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
- activeFlag (boolean)
Other Properties
| Property | Value |
|---|---|
| Application Package Name | ora_scm_core_schedule |
| Extensible | No |