HumanResources.Shift (table)

wikibot

Table	HumanResources.Shift
Description	Work shift lookup table.

Column	Data Type	Nullable	Default	Description / PK / Index
ShiftID	tinyint	not null		Primary key for Shift records. PK_Shift_ShiftID
Name	dbo.Name	not null		Shift description. AK_Shift_Name
StartTime	datetime	not null		Shift start time. AK_Shift_StartTime_EndTime
EndTime	datetime	not null		Shift end time. AK_Shift_StartTime_EndTime
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
HumanResources.EmployeeDepartmentHistory	ShiftID	ShiftID

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name

Reference Type	Object Type	Referencing Object
Select	View	HumanResources.vEmployeeDepartmentHistory

wikivalues

Table Values

HumanResources.Shift

ShiftID	Name	StartTime	EndTime
1	Day	1900-01-01 07:00:00.000	1900-01-01 15:00:00.000
2	Evening	1900-01-01 15:00:00.000	1900-01-01 23:00:00.000
3	Night	1900-01-01 23:00:00.000	1900-01-01 07:00:00.000

automatically generated

Table	HumanResources.Shift
Description	Work shift lookup table.

Column	Data Type	Nullable	Default	Description / PK / Index
ShiftID	tinyint	not null		Primary key for Shift records. PK_Shift_ShiftID
Name	Name	not null		Shift description. AK_Shift_Name
StartTime	datetime	not null		Shift start time. AK_Shift_StartTime_EndTime
EndTime	datetime	not null		Shift end time. AK_Shift_StartTime_EndTime
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
HumanResources.EmployeeDepartmentHistory	ShiftID	ShiftID

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Schema	Schema	HumanResources

Reference Type	Object Type	Referencing Object
Select	View	HumanResources.vEmployeeDepartmentHistory