shift_history

ent_id

int32

Y

N

The entity to which the shift is assigned.

shift_start_utc

tdatetime

Y

N

The shift start time, in UTC.

shift_start_local

tdatetime

N

N

The shift start time, in the local time of the entity.

shift_end_utc

tdatetime

N

Y

The shift end time, in UTC.

shift_end_local

tdatetime

N

Y

The shift end time, in the local time of the entity.

pattern_id

int32

N

Y

The shift pattern to which the shift is associated.

shift_id

int32

N

N

The shift ID.

comments

string2000

N

Y

Comments that were entered for the shift pattern to which the shift is associated.

user_comments

string2000

N

Y

Comments entered by a user about the shift.

spare1

string80

N

Y

User-defined content.

spare2

string80

N

Y

User-defined content.

spare3

string80

N

Y

User-defined content.

spare4

string80

N

Y

User-defined content.

last_edit_comment

notes

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.