Schedules
Schedules
Columns
| Name | Type | Description |
| ScheduleId [KEY] | Long | ScheduleId of Schedules |
| 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 | Int | 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 |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |