Shifts

Full shift/segment detail for a specific ShiftId, not an employee+date range read. ShiftId values can be pulled from the Schedules table's Shifts aggregate column (each shift object's id field). Same schema as the objects in that array; use this table to look up one shift directly by id.

Columns

Name	Type	References
ShiftId [KEY]	Long
PersonId	Long	Employees.PersonId
EmployeeQualifier	String
ShiftStartDateTime	Datetime
ShiftEndDateTime	Datetime
IsLocked	Boolean
IsPosted	Boolean
IsGenerated	Boolean
IsDeleted	Boolean
IsSelfServiced	Boolean
IsOpen	Boolean
ModifiedDateTime	Datetime
Segments	String