cmn_schedule_span
Records specific time spans within schedules, such as working hours, holidays, or exceptions.
Columns
| Name | Type | ReadOnly | References | Description |
| start_date_time | String | False |
Specifies the start date and time of the schedule span, marking when the defined period begins. | |
| yearly_type | String | False |
Indicates how the schedule span recurs on a yearly basis, such as by specific date or week. | |
| sys_updated_on | Datetime | False |
Displays the date and time when the schedule span record was last updated. | |
| show_as | String | False |
Determines how the time span appears on the schedule view, such as busy, free, or blocked. | |
| days_of_week | String | False |
Lists the days of the week when the schedule span is active, such as Monday through Friday. | |
| sys_id [KEY] | String | False |
Provides the system identifier (sys_id) that uniquely identifies the schedule span record in the Common Schedule Span (cmn_schedule_span) table. | |
| notes | String | False |
Contains additional details or comments related to the schedule span. | |
| repeat_type | String | False |
Defines the type of recurrence for the schedule span, such as daily, weekly, or monthly. | |
| parent | String | False |
References the parent schedule record that this span belongs to. | |
| schedule | String | False |
Identifies the associated schedule that includes this time span. | |
| all_day | String | False |
Indicates whether the schedule span covers the entire day rather than specific hours. | |
| float_week | String | False |
Specifies the week of the month when the span occurs, such as first, second, or last. | |
| sys_created_on | Datetime | False |
Displays the date and time when the schedule span record was first created. | |
| type | String | False |
Indicates the general type of the schedule span, such as standard, exception, or blackout period. | |
| monthly_type | String | False |
Defines how the schedule span repeats monthly, such as by day of the month or weekday occurrence. | |
| sys_updated_by | String | False |
Lists the user or process that last updated the schedule span record. | |
| sys_class_name | String | False |
Specifies the system class name that defines the type of record stored in the Common Schedule Span (cmn_schedule_span) table. | |
| repeat_count | String | False |
Indicates the number of times the schedule span repeats according to its recurrence rules. | |
| override_start_date | String | False |
Specifies a custom start date that overrides the regular schedule start time, if applicable. | |
| name | String | False |
Lists the name of the schedule span for identification within the schedule configuration. | |
| repeat_until | String | False |
Defines the date or condition until which the schedule span continues to repeat. | |
| float_day | String | False |
Indicates the day of the week when a floating recurrence occurs, such as the first Monday of each month. | |
| sys_mod_count | String | False |
Tracks the total number of times the schedule span record has been modified. | |
| end_date_time | String | False |
Specifies the end date and time of the schedule span, marking when the defined period concludes. | |
| month | String | False |
Lists the month or months during which the schedule span applies. | |
| sys_created_by | String | False |
Lists the user or process that originally created the schedule span record. |