Table 'Sales.SalesPerson', Sales representative current information.

Table 'Sales.SalesPerson', Sales representative current information.

Property NameProperty Value
Records17
Fields9
Record size (bytes) w/o BLOBs136

Field statistics for 'SalesPersonID' int

Field propertyProperty Value
Minimum value268
Maximum value290
Average value281.64705882352939
Values variance33.617647058825241
Unique values17

Field statistics for 'TerritoryID' int

Field propertyProperty Value
Minimum value1
Maximum value10
Average value4.7857142857142856
Values variance9.1043956043956022
Unique values10

Field statistics for 'SalesQuota' money(19,4)

Field propertyProperty Value
Minimum value250000.0000
Maximum value300000.0000
Average value260714.28571428571
Values variance453296703.29670596
Unique values2

Field statistics for 'Bonus' money(19,4)

Field propertyProperty Value
Minimum value.0000
Maximum value6700.0000
Average value2859.4117647058824
Values variance5167959.0073529407
Unique values14

Field statistics for 'CommissionPct' smallmoney(10,4)

Field propertyProperty Value
Minimum value.0000
Maximum value.0200
Average value1.1764705882352938E-2
Values variance4.2191176470588349E-5
Unique values8

Field statistics for 'SalesYTD' money(19,4)

Field propertyProperty Value
Minimum value.0000
Maximum value5200475.2313
Average value2605530.9490823527
Values variance2688695493924.3262
Unique values17

Field statistics for 'SalesLastYear' money(19,4)

Field propertyProperty Value
Minimum value.0000
Maximum value2396539.7601
Average value1393291.9779058823
Values variance721216164980.78296
Unique values14

Field statistics for 'rowguid' uniqueidentifier

Field propertyProperty Value
Unique values17

Field statistics for 'ModifiedDate' datetime

Field propertyProperty Value
Minimum value2001-01-28 00:00:00.000
Maximum value2003-06-24 00:00:00.000
Unique values7