Table 'HumanResources.EmployeeDepartmentHistory', Employee department transfers.

Table 'HumanResources.EmployeeDepartmentHistory', Employee department transfers.

Property Name	Property Value
Records	296
Fields	6
Record size (bytes) w/o BLOBs	55

Field statistics for 'EmployeeID' int

Field property	Property Value
Minimum value	1
Maximum value	290
Average value	145.2331081081081
Values variance	7143.5895442052224
Unique values	290

Field statistics for 'DepartmentID' smallint

Field property	Property Value
Minimum value	1
Maximum value	16
Average value	7.2668918918918921
Values variance	7.8641204764086101
Unique values	16

Field statistics for 'ShiftID' tinyint

Field property	Property Value
Minimum value	1
Maximum value	3
Average value	1.5608108108108107
Values variance	0.59967934035730652
Unique values	3

Field statistics for 'StartDate' datetime

Field property	Property Value
Minimum value	1996-07-31 00:00:00.000
Maximum value	2003-12-16 00:00:00.000
Unique values	170

Field statistics for 'EndDate' datetime

Field property	Property Value
Minimum value	1999-08-15 00:00:00.000
Maximum value	2003-12-15 00:00:00.000
Unique values	6

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	1996-07-30 00:00:00.000
Maximum value	2003-12-15 00:00:00.000
Unique values	172