JDBC Driver for Oracle SCM

Build 22.0.8462

Schedules

The Schedules resource defines a schedule of working time assigned to one or more business objects.

Columns

Name Type Description
ScheduleId [KEY] String The value that uniquely identifies the schedule. It is a primary key that the application generates when it creates a schedule. This attribute is required.
ScheduleTypeCode String Specifies the type of schedule being created. Valid values are Time, Duration, and Elapsed. This attribute is required.
Name String The name of the schedule that the user specifies when creating an instance. This attribute is required.
Description String The description of the schedule that the user specifies when creating an instance.
EffectiveFromDate Date The date when the modeling of working and non-working time using the assigned workday patterns starts. This attribute is required.
EffectiveToDate Date The date when the modeling of working and non-working time using the assigned workday patterns stops. This attribute is required.
CategoryCode String The abbreviation that identifies the category. For example, Pager, UK SSP, or Work.
DeletedFlag Bool 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 is not active. The default value is true.
QuarterlyTypeCode String The 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.
NumberOfAssignments Long The number of business objects associated with a schedule. A value greater than zero restricts how the schedule can be updated.
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.
FirstDayOfWorkWeek String FirstDayOfWorkWeek of Schedules
CreatedBy String CreatedBy of Schedules
CreationDate Datetime CreationDate of Schedules
LastUpdateDate Datetime LastUpdateDate of Schedules
LastUpdatedBy String LastUpdatedBy of Schedules

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462