shift_schedule
- Last UpdatedNov 12, 2024
- 2 minute read
The shift_schedule table defines a shift schedule that is associated to a shift pattern and a shift. The shift schedule can include up to 3 breaks. Breaks are optional and could be used for capacity planning. Only standard recurring shift patterns and overtime shift patterns can have shift schedules.
There is a one-to-many relationship between shift and shift_schedule.
If there is no shift schedule defined for an entity or any of its descendants, then automatic shift changes will not work.
Breaks are not normalized for ease of accessing data. Exceptions also need to be able to override any defined breaks.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
pattern_id |
int32 |
Y |
N |
The ID of the shift pattern to which the shift schedule is associated. |
|
start_time |
time0 |
Y |
N |
The shift schedule start time. |
|
end_time |
time0 |
Y |
N |
The shift schedule end time. |
|
end_day_span |
int32 |
N |
N |
For a shift schedule that spans one or more days, specifies the number of days beyond the start day of the day the shift schedule ends, up to 7. 0 indicates that the shift schedule does not span into another day. |
|
shift_id |
int32 |
Y |
N |
The ID of the shift that has been associated to this shift schedule. |
|
sunday |
logical |
N |
N |
The days of the week to which the shift applies. True = applies to that day False = does not apply to that day |
|
monday |
||||
|
tuesday |
||||
|
wednesday |
||||
|
thursday |
||||
|
friday |
||||
|
saturday |
||||
|
break1_start |
time0 |
N |
Y |
Start and end times for the three available break periods that can be defined for shift schedules in regular shift patterns. Break time periods always occur within the shift schedule time period. |
|
break1_end |
||||
|
break2_start |
||||
|
break2_end |
||||
|
break3_start |
||||
|
break3_end |
||||
|
spare1 |
string80 |
N |
Y |
User-defined content, by language term 3018. |
|
spare2 |
string80 |
N |
Y |
User-defined content, by language term 3019. |
|
spare3 |
string80 |
N |
Y |
User-defined content, by language term 3020. |
|
spare4 |
string80 |
N |
Y |
User-defined content, by language term 3021. |
|
spare5 |
string80 |
N |
Y |
User-defined content, by language term 3022. |
|
spare6 |
string80 |
N |
Y |
User-defined content, by language term 3023. |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
Y |
The user who added or last changed this record. |
|
last_edit_at |
tdatetime |
N |
N |
When this record was added or last changed. |
|
row_id |
int32 |
N |
N |
Unique row identifier. |
FK from pattern_id to shift_pattern (Cascade delete)
FK from shift_id to shift (Cascade delete)