util_shift_link
- Last UpdatedNov 19, 2024
- 2 minute read
The util_shift_link table specifies a shift during which a utilization event occurred. For a given utilization event, there will be a separate record for each shift during which the event occurred. This table allows utilization events to be properly broken down by the shifts in which they occur, which in turn allows their correct duration to be reported.
-
Each record in the table identifies the actual utilization event in the util_history table using the ent_id and event_time_utc fields as keys. These two fields uniquely identify records in the util_history table.
-
Each record identifies the shift using the shift_start_utc field.
-
A record can optionally include a value for the row ID of a record in the job_history, which identifies the job that was running while the event was occurring.
-
When a util_history record is deleted, any util_shift_link records linked to that util_history record (identified by the ent_id and event_time_utc fields) are deleted.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
ent_id |
int32 |
Y |
N |
The ID of the entity at which the utilization event took place. |
|
act_event_time_utc |
tdatetime2 |
Y |
N |
The actual start time of the event, in UTC. The actual start time can be different than the start time within the linked shift (event_time_utc) if the event duration spans two or more shifts and the event was not actually started in the linked shift. |
|
event_time_utc |
tdatetime2 |
Y |
N |
The start time of the event within the linked shift, in UTC. If the event was started within the linked shift, the value for this column and the act_event_time_utc column will be the same. If the event started in a previous shift, this will be the shift start time. |
|
event_time_local |
tdatetime2 |
N |
N |
The start time of the event within the linked shift, in the local time of the entity. |
|
shift_start_utc |
tdatetime |
N |
N |
The start time of the shift, in UTC. Used to identify the shift to which the utilization event is linked. |
|
job_hist_row_id |
int32 |
N |
Y |
The row ID of the record in the Job_History table for the job that was running while the event was occurring. |
|
last_edit_comment |
notes |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
Y |
Who last changed this record. |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed. |
|
row_id |
bigint |
N |
N |
Unique row identifier, for audit trail. |
FK from ent_id to util_history. (Cascade delete, in combination with matching act_event_time_utc value)
FK from act_event_time_utc to util_history. (Cascade delete, in combination with matching ent_id value)
FK from job_hist_row_id to job_history.