Table 'HumanResources.Employee', Employee information such as salary, department, and title.

Table 'HumanResources.Employee', Employee information such as salary, department, and title.

Property Name	Property Value
Records	290
Fields	16
Record size (bytes) w/o BLOBs	728

Field statistics for 'EmployeeID' int identity

Field property	Property Value
Minimum value	1
Maximum value	290
Average value	145.5
Values variance	7032.5
Unique values	290

Field statistics for 'NationalIDNumber' nvarchar(15)

Field property	Property Value
Minimum value	10708100
Maximum value	999440576
Unique values	290

Field statistics for 'ContactID' int

Field property	Property Value
Minimum value	1001
Maximum value	1290
Average value	1145.5
Values variance	7032.5
Unique values	290

Field statistics for 'LoginID' nvarchar(256)

Field property	Property Value
Minimum value	adventure-works\alan0
Maximum value	adventure-works\zheng0
Unique values	290

Field statistics for 'ManagerID' int

Field property	Property Value
Minimum value	3
Maximum value	288
Average value	108.21107266435986
Values variance	7348.6879325259524
Unique values	47

Field statistics for 'Title' nvarchar(50)

Field property	Property Value
Minimum value	Accountant
Maximum value	Vice President of Sales
Unique values	67

Field statistics for 'BirthDate' datetime

Field property	Property Value
Minimum value	1941-11-17 00:00:00.000
Maximum value	1981-07-01 00:00:00.000
Unique values	279

Field statistics for 'MaritalStatus' nchar(1)

Field property	Property Value
Minimum value	M
Maximum value	S
Unique values	2

Field statistics for 'Gender' nchar(1)

Field property	Property Value
Minimum value	F
Maximum value	M
Unique values	2

Field statistics for 'HireDate' datetime

Field property	Property Value
Minimum value	1996-07-31 00:00:00.000
Maximum value	2003-07-01 00:00:00.000
Unique values	164

Field statistics for 'SalariedFlag' Flag

Field property	Property Value
Unique values	2

Field statistics for 'VacationHours' smallint

Field property	Property Value
Minimum value	0
Maximum value	99
Average value	50.613793103448273
Values variance	828.64617587400073
Unique values	100

Field statistics for 'SickLeaveHours' smallint

Field property	Property Value
Minimum value	20
Maximum value	80
Average value	45.306896551724137
Values variance	211.4245197470469
Unique values	51

Field statistics for 'CurrentFlag' Flag

Field property	Property Value
Unique values	1

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	290

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2004-07-31 00:00:00.000
Maximum value	2005-01-26 09:17:08.637
Unique values	2