shift_to_go
- Last UpdatedNov 12, 2024
- 2 minute read
The shift_to_go table details the imminent shift changes over the short term for each entity, typically over the next week, taking into account any standard shift patterns and any defined shift exceptions (i.e., holiday or overtime shift patterns). All times are local.
Null shifts are not included in the schedule, so the end_time is used to determine when to end a shift. The break times are inherited from the shift_schedule table, but if a shift exception shortens a shift to exclude a break, then its relevant break times are set to null in the appropriate row in this table.
The data in this table is kept updated internally by the background service and is available as a read‑only table for any application or user. It should not be updated by any application or user. The data in this table is not used for shift changes, which are evaluated every minute by the background service.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
ent_id |
int32 |
Y |
N |
The ID of an entity to which the shift pattern is linked, either directly or through inheritance from the parent entity specified in shift_sched_ent_id. |
|
start_time |
tdatetime |
Y |
N |
When the shift starts and ends. |
|
end_time |
tdatetime |
N |
N |
|
|
shift_id |
int32 |
N |
N |
The shift ID. Null shifts are NOT included in this table |
|
break1_start |
time0 |
N |
Y |
The start and end times of optional breaks in the shift's schedule. |
|
break1_end |
||||
|
break2_start |
||||
|
break2_end |
||||
|
break3_start |
||||
|
break3_end |
||||
|
shift_start_utc |
tdatetime |
N |
N |
The shift start time, in UTC. |
|
shift_end_utc |
tdatetime |
N |
N |
The shift end time, in UTC. |
|
shift_sched_ent_id |
int32 |
N |
Y |
The ID of the entity to which the shift pattern is directly assigned. The entity must have the capability to schedule shifts. |
|
pattern_id |
int32 |
N |
Y |
The ID of the shift pattern to which this shift schedule is associated. |
|
ent_tz_id |
string80 |
N |
N |
The entity's time zone. |
|
last_edit_comment |
string2000 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
created_at_utc |
tdatetime2 |
N |
N |
When the shift was created. |
|
row_id |
int32 |
N |
N |
Unique row identifier. |
FK from ent_id to ent. (Cascade delete)
FK from shift_id to shift. (Cascade delete)