table icon Table: Employee

Properties

Property Value
Name Employee
ID 981578535
Owner dbo
Schema HumanResources
Filegroup PRIMARY
Data Size (KB) 56 KB
Index Size (KB) 136 KB
Rows 290
Unused (KB) 8 KB
ANSI Null On true
Quoted Identifier true
Lock Escalation TABLE
Lock On Bulk Load false
Lob Data Space
Filestream Data Space ID
Has Unchecked Assembly Data false
Text In Row Limit (bytes) Option not set
Large Value Types Out Of Row false
FullText Change Tracking On false
Tracked By Cdc false
Published false
Schema Published false
Replicated false
Replication Filter false
Merge Published false
Sync Tran Subscribed false
MS Shipped false
Modify Date 11/26/2011 3:07:40 PM
Create Date 8/8/2010 5:21:51 PM

Extended Properties

Name Value
MS_Description Employee information such as salary, department, and title.

Columns

Column ID Column Name Datatype Nullable Is Sparse Is Column Set
1 BusinessEntityID int false false false
2 NationalIDNumber nvarchar(15) false false false
3 LoginID nvarchar(256) false false false
4 OrganizationNode hierarchyid true false false
5 OrganizationLevel smallint true false false
6 JobTitle nvarchar(50) false false false
7 BirthDate date false false false
8 MaritalStatus nchar(1) false false false
9 Gender nchar(1) false false false
10 HireDate date false false false
11 SalariedFlag Flag false false false
12 VacationHours smallint false false false
13 SickLeaveHours smallint false false false
14 CurrentFlag Flag false false false
15 rowguid uniqueidentifier false false false
16 ModifiedDate datetime false false false

Identity Columns

No identity columns defined.

Primary Key Constraints

Name Is System Named Extended Property Name Extended Property Value
PK_Employee_BusinessEntityID false MS_Description Primary key (clustered) constraint

Primary Key Columns

Name
BusinessEntityID

Foreign Keys

Name Referenced Object Update Action Delete Action
FK_Employee_Person_BusinessEntityID Person.Person No action No action

Column Level Check Constraints

Name Column ID Column Definition Is Disabled Is Not For Replication Is Not Trusted Uses Database Collation Is System Named
CK_Employee_BirthDate 7 BirthDate ([BirthDate]>='1930-01-01' AND [BirthDate]<=dateadd(year,(-18),getdate())) false false false true false
CK_Employee_MaritalStatus 8 MaritalStatus (upper([MaritalStatus])='S' OR upper([MaritalStatus])='M') false false false true false
CK_Employee_HireDate 10 HireDate ([HireDate]>='1996-07-01' AND [HireDate]<=dateadd(day,(1),getdate())) false false false true false
CK_Employee_Gender 9 Gender (upper([Gender])='F' OR upper([Gender])='M') false false false true false
CK_Employee_VacationHours 12 VacationHours ([VacationHours]>=(-40) AND [VacationHours]<=(240)) false false false true false
CK_Employee_SickLeaveHours 13 SickLeaveHours ([SickLeaveHours]>=(0) AND [SickLeaveHours]<=(120)) false false false true false

Table Level Check Constraints

No table constraints defined.

Default Constraints

Name Column Definition Is System Named Extended Property Name Extended Property Value
DF_Employee_SalariedFlag SalariedFlag ((1)) false MS_Description Default constraint value of 1 (TRUE)
DF_Employee_VacationHours VacationHours ((0)) false MS_Description Default constraint value of 0
DF_Employee_SickLeaveHours SickLeaveHours ((0)) false MS_Description Default constraint value of 0
DF_Employee_CurrentFlag CurrentFlag ((1)) false MS_Description Default constraint value of 1
DF_Employee_rowguid rowguid (newid()) false MS_Description Default constraint value of NEWID()
DF_Employee_ModifiedDate ModifiedDate (getdate()) false MS_Description Default constraint value of GETDATE()

Indexes

Name Index Type Primary Key Unique Unique Constraint Ignore Duplicate Key Disabled
PK_Employee_BusinessEntityID CLUSTERED true true false false false
IX_Employee_OrganizationNode NONCLUSTERED false false false false false
IX_Employee_OrganizationLevel_OrganizationNode NONCLUSTERED false false false false false
AK_Employee_LoginID NONCLUSTERED false true false false false
AK_Employee_NationalIDNumber NONCLUSTERED false true false false false
AK_Employee_rowguid NONCLUSTERED false true false false false

FullText Indexes

No fulltext indexes defined.

Referencing Tables

Name Key Index ID Is Disabled Is Not For Replication Is Not Trusted Delete Action Update Action Is System Named Referencing Object
FK_Document_Employee_Owner 1 false false false No action No action false Production.Document
FK_EmployeeDepartmentHistory_Employee_BusinessEntityID 1 false false false No action No action false HumanResources.EmployeeDepartmentHistory
FK_EmployeePayHistory_Employee_BusinessEntityID 1 false false false No action No action false HumanResources.EmployeePayHistory
FK_JobCandidate_Employee_BusinessEntityID 1 false false false No action No action false HumanResources.JobCandidate
FK_PurchaseOrderHeader_Employee_EmployeeID 1 false false false No action No action false Purchasing.PurchaseOrderHeader
FK_SalesPerson_Employee_BusinessEntityID 1 false false false No action No action false Sales.SalesPerson

Object Level Permissions

Permissions for: weekly_receipts

Permission Grantor Grant With Grant Option Deny
Alter
Control
Delete
Insert
References
Select dbo true
Take Ownership
Update dbo true
View Change Tracking
View Definition

Column Level Permissions

Permissions for: KrystianRole

JobTitle
Permission Grantor Grant With Grant Deny
SELECT dbo true
REFERENCES dbo true
UPDATE
MaritalStatus
Permission Grantor Grant With Grant Deny
SELECT
REFERENCES
UPDATE dbo true

Statistics

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
PK_Employee_BusinessEntityID Aug 8 2010 5:22PM 290 290 146 1 4 false 290

Detailed Statistics Density

All Density Average Length Columns
0.003448276 4 BusinessEntityID

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
1 0 1 0 1
3 1 1 1 1
4 0 1 0 1
6 1 1 1 1
8 1 1 1 1
10 1 1 1 1
12 1 1 1 1
14 1 1 1 1
16 1 1 1 1
18 1 1 1 1
20 1 1 1 1
22 1 1 1 1
24 1 1 1 1
26 1 1 1 1
28 1 1 1 1
30 1 1 1 1
32 1 1 1 1
34 1 1 1 1
36 1 1 1 1
38 1 1 1 1
40 1 1 1 1
42 1 1 1 1
44 1 1 1 1
46 1 1 1 1
48 1 1 1 1
50 1 1 1 1
52 1 1 1 1
54 1 1 1 1
56 1 1 1 1
58 1 1 1 1
60 1 1 1 1
62 1 1 1 1
64 1 1 1 1
66 1 1 1 1
68 1 1 1 1
70 1 1 1 1
72 1 1 1 1
74 1 1 1 1
76 1 1 1 1
78 1 1 1 1
80 1 1 1 1
82 1 1 1 1
84 1 1 1 1
86 1 1 1 1
88 1 1 1 1
90 1 1 1 1
92 1 1 1 1
94 1 1 1 1
96 1 1 1 1
98 1 1 1 1
100 1 1 1 1
102 1 1 1 1
104 1 1 1 1
106 1 1 1 1
108 1 1 1 1
110 1 1 1 1
112 1 1 1 1
114 1 1 1 1
116 1 1 1 1
118 1 1 1 1
120 1 1 1 1
122 1 1 1 1
124 1 1 1 1
126 1 1 1 1
128 1 1 1 1
130 1 1 1 1
132 1 1 1 1
134 1 1 1 1
136 1 1 1 1
138 1 1 1 1
140 1 1 1 1
142 1 1 1 1
144 1 1 1 1
146 1 1 1 1
148 1 1 1 1
150 1 1 1 1
152 1 1 1 1
154 1 1 1 1
156 1 1 1 1
158 1 1 1 1
160 1 1 1 1
162 1 1 1 1
164 1 1 1 1
166 1 1 1 1
168 1 1 1 1
170 1 1 1 1
172 1 1 1 1
174 1 1 1 1
176 1 1 1 1
178 1 1 1 1
180 1 1 1 1
182 1 1 1 1
184 1 1 1 1
186 1 1 1 1
188 1 1 1 1
190 1 1 1 1
192 1 1 1 1
194 1 1 1 1
196 1 1 1 1
198 1 1 1 1
200 1 1 1 1
202 1 1 1 1
204 1 1 1 1
206 1 1 1 1
208 1 1 1 1
210 1 1 1 1
212 1 1 1 1
214 1 1 1 1
216 1 1 1 1
218 1 1 1 1
220 1 1 1 1
222 1 1 1 1
224 1 1 1 1
226 1 1 1 1
228 1 1 1 1
230 1 1 1 1
232 1 1 1 1
234 1 1 1 1
236 1 1 1 1
238 1 1 1 1
240 1 1 1 1
242 1 1 1 1
244 1 1 1 1
246 1 1 1 1
248 1 1 1 1
250 1 1 1 1
252 1 1 1 1
254 1 1 1 1
256 1 1 1 1
258 1 1 1 1
260 1 1 1 1
262 1 1 1 1
264 1 1 1 1
266 1 1 1 1
268 1 1 1 1
270 1 1 1 1
272 1 1 1 1
274 1 1 1 1
276 1 1 1 1
278 1 1 1 1
280 1 1 1 1
282 1 1 1 1
284 1 1 1 1
286 1 1 1 1
288 1 1 1 1
290 1 1 1 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
IX_Employee_OrganizationNode Aug 8 2010 5:23PM 290 290 145 1 6.903448 false 290

Detailed Statistics Density

All Density Average Length Columns
0.003448276 2.903448 OrganizationNode
0.003448276 6.903448 OrganizationNode, BusinessEntityID

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
/ 0 1 0 1
/1/1/ 1 1 1 1
/1/1/3/ 2 1 2 1
/1/1/4/1/ 1 1 1 1
/1/1/4/3/ 1 1 1 1
/1/1/5/1/ 1 1 1 1
/1/1/6/ 1 1 1 1
/2/ 1 1 1 1
/2/2/ 1 1 1 1
/2/4/ 1 1 1 1
/2/6/ 1 1 1 1
/2/8/ 1 1 1 1
/3/1/ 1 1 1 1
/3/1/1/1/ 1 1 1 1
/3/1/1/3/ 1 1 1 1
/3/1/1/5/ 1 1 1 1
/3/1/1/7/ 1 1 1 1
/3/1/1/9/ 1 1 1 1
/3/1/1/11/ 1 1 1 1
/3/1/2/ 1 1 1 1
/3/1/2/2/ 1 1 1 1
/3/1/2/4/ 1 1 1 1
/3/1/2/6/ 1 1 1 1
/3/1/3/1/ 1 1 1 1
/3/1/3/3/ 1 1 1 1
/3/1/3/5/ 1 1 1 1
/3/1/3/7/ 1 1 1 1
/3/1/4/1/ 1 1 1 1
/3/1/4/3/ 1 1 1 1
/3/1/4/5/ 1 1 1 1
/3/1/5/ 1 1 1 1
/3/1/5/2/ 1 1 1 1
/3/1/5/4/ 1 1 1 1
/3/1/5/6/ 1 1 1 1
/3/1/5/8/ 1 1 1 1
/3/1/6/1/ 1 1 1 1
/3/1/6/3/ 1 1 1 1
/3/1/6/5/ 1 1 1 1
/3/1/7/ 1 1 1 1
/3/1/7/2/ 1 1 1 1
/3/1/7/4/ 1 1 1 1
/3/1/7/6/ 1 1 1 1
/3/1/7/8/ 1 1 1 1
/3/1/8/1/ 1 1 1 1
/3/1/8/3/ 1 1 1 1
/3/1/8/5/ 1 1 1 1
/3/1/9/1/ 1 1 1 1
/3/1/9/3/ 1 1 1 1
/3/1/9/5/ 1 1 1 1
/3/1/9/7/ 1 1 1 1
/3/1/10/ 1 1 1 1
/3/1/10/2/ 1 1 1 1
/3/1/10/4/ 1 1 1 1
/3/1/11/ 1 1 1 1
/3/1/11/2/ 1 1 1 1
/3/1/11/4/ 1 1 1 1
/3/1/11/6/ 1 1 1 1
/3/1/11/8/ 1 1 1 1
/3/1/11/10/ 1 1 1 1
/3/1/11/12/ 1 1 1 1
/3/1/12/1/ 1 1 1 1
/3/1/12/3/ 1 1 1 1
/3/1/12/5/ 1 1 1 1
/3/1/13/1/ 1 1 1 1
/3/1/13/3/ 1 1 1 1
/3/1/13/5/ 1 1 1 1
/3/1/14/ 1 1 1 1
/3/1/14/2/ 1 1 1 1
/3/1/14/4/ 1 1 1 1
/3/1/14/6/ 1 1 1 1
/3/1/14/8/ 1 1 1 1
/3/1/14/10/ 1 1 1 1
/3/1/15/1/ 1 1 1 1
/3/1/15/3/ 1 1 1 1
/3/1/15/5/ 1 1 1 1
/3/1/16/ 1 1 1 1
/3/1/16/2/ 1 1 1 1
/3/1/16/4/ 1 1 1 1
/3/1/16/6/ 1 1 1 1
/3/1/17/ 1 1 1 1
/3/1/17/2/ 1 1 1 1
/3/1/17/4/ 1 1 1 1
/3/1/18/ 1 1 1 1
/3/1/18/2/ 1 1 1 1
/3/1/18/4/ 1 1 1 1
/3/1/18/6/ 1 1 1 1
/3/1/18/8/ 1 1 1 1
/3/1/18/10/ 1 1 1 1
/3/1/18/12/ 1 1 1 1
/3/1/19/ 1 1 1 1
/3/1/19/2/ 1 1 1 1
/3/1/19/4/ 1 1 1 1
/3/1/20/ 1 1 1 1
/3/1/20/2/ 1 1 1 1
/3/1/20/4/ 1 1 1 1
/3/1/21/ 1 1 1 1
/3/1/21/2/ 1 1 1 1
/3/1/21/4/ 1 1 1 1
/3/1/21/6/ 1 1 1 1
/3/1/21/8/ 1 1 1 1
/3/1/21/10/ 1 1 1 1
/3/1/21/12/ 1 1 1 1
/3/1/22/1/ 1 1 1 1
/3/1/22/3/ 1 1 1 1
/3/1/22/5/ 1 1 1 1
/3/2/1/ 1 1 1 1
/3/2/1/2/ 1 1 1 1
/3/2/1/4/ 1 1 1 1
/3/2/2/1/ 1 1 1 1
/3/2/2/3/ 1 1 1 1
/3/3/ 1 1 1 1
/3/3/2/ 1 1 1 1
/3/3/4/ 1 1 1 1
/3/4/1/ 1 1 1 1
/3/4/1/2/ 1 1 1 1
/3/4/1/4/ 1 1 1 1
/4/ 1 1 1 1
/4/1/1/ 1 1 1 1
/4/1/3/ 1 1 1 1
/4/1/5/ 1 1 1 1
/4/2/1/ 1 1 1 1
/4/2/3/ 1 1 1 1
/4/2/5/ 1 1 1 1
/4/2/7/ 1 1 1 1
/4/3/1/ 1 1 1 1
/4/3/1/2/ 1 1 1 1
/4/3/1/4/ 1 1 1 1
/4/3/1/6/ 1 1 1 1
/4/3/1/8/ 1 1 1 1
/4/3/1/10/ 1 1 1 1
/4/4/ 1 1 1 1
/5/1/ 1 1 1 1
/5/1/2/ 1 1 1 1
/5/3/ 1 1 1 1
/5/5/ 1 1 1 1
/5/7/ 1 1 1 1
/6/1/ 1 1 1 1
/6/1/2/ 1 1 1 1
/6/1/4/ 1 1 1 1
/6/1/6/ 1 1 1 1
/6/1/8/ 1 1 1 1
/6/1/10/ 1 1 1 1
/6/2/1/ 1 1 1 1
/6/3/1/ 1 1 1 1
/6/3/3/ 1 1 1 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
IX_Employee_OrganizationLevel_OrganizationNode Aug 8 2010 5:23PM 290 290 5 0 8.903448 false 290

Detailed Statistics Density

All Density Average Length Columns
0.2 2 OrganizationLevel
0.003448276 4.903448 OrganizationLevel, OrganizationNode
0.003448276 8.903448 OrganizationLevel, OrganizationNode, BusinessEntityID

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
0 0 1 0 1
1 0 6 0 1
2 0 27 0 1
3 0 66 0 1
4 0 190 0 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
_WA_Sys_00000005_3A81B327 Aug 8 2010 5:23PM 290 290 5 0 2 false 290

Detailed Statistics Density

All Density Average Length Columns
0.2 2 OrganizationLevel

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
0 0 1 0 1
1 0 6 0 1
2 0 27 0 1
3 0 66 0 1
4 0 190 0 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
AK_Employee_LoginID Aug 8 2010 5:23PM 290 290 188 1 48.77242 true 290

Detailed Statistics Density

All Density Average Length Columns
0.003448276 44.77242 LoginID
0.003448276 48.77242 LoginID, BusinessEntityID

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
adventure-works\alan0 0 1 0 1
adventure-works\alex0 1 1 1 1
adventure-works\alice0 0 1 0 1
adventure-works\andrew1 3 1 3 1
adventure-works\angela0 1 1 1 1
adventure-works\annik0 2 1 2 1
adventure-works\arvind0 0 1 0 1
adventure-works\ascott0 0 1 0 1
adventure-works\ashvini0 0 1 0 1
adventure-works\barbara1 1 1 1 1
adventure-works\barry0 1 1 1 1
adventure-works\betsy0 3 1 3 1
adventure-works\bjorn0 0 1 0 1
adventure-works\bob0 0 1 0 1
adventure-works\bonnie0 0 1 0 1
adventure-works\brandon0 0 1 0 1
adventure-works\brenda0 0 1 0 1
adventure-works\brian0 0 1 0 1
adventure-works\brian1 0 1 0 1
adventure-works\brian2 0 1 0 1
adventure-works\britta0 1 1 1 1
adventure-works\bryan1 1 1 1 1
adventure-works\carol0 1 1 1 1
adventure-works\chad0 1 1 1 1
adventure-works\chris0 1 1 1 1
adventure-works\chris2 1 1 1 1
adventure-works\christian0 0 1 0 1
adventure-works\christopher0 0 1 0 1
adventure-works\cristian0 0 1 0 1
adventure-works\cynthia0 0 1 0 1
adventure-works\dan0 0 1 0 1
adventure-works\dan1 0 1 0 1
adventure-works\danielle0 0 1 0 1
adventure-works\david0 0 1 0 1
adventure-works\david1 0 1 0 1
adventure-works\david3 1 1 1 1
adventure-works\david5 1 1 1 1
adventure-works\david7 1 1 1 1
adventure-works\david8 0 1 0 1
adventure-works\deborah0 0 1 0 1
adventure-works\denise0 0 1 0 1
adventure-works\diane0 0 1 0 1
adventure-works\diane1 0 1 0 1
adventure-works\don0 1 1 1 1
adventure-works\douglas0 1 1 1 1
adventure-works\dylan0 1 1 1 1
adventure-works\ed0 1 1 1 1
adventure-works\eric0 1 1 1 1
adventure-works\eric2 1 1 1 1
adventure-works\eugene0 1 1 1 1
adventure-works\fadi0 1 1 1 1
adventure-works\frank0 1 1 1 1
adventure-works\frank2 1 1 1 1
adventure-works\fred0 1 1 1 1
adventure-works\fukiko0 0 1 0 1
adventure-works\gabe0 0 1 0 1
adventure-works\gail0 0 1 0 1
adventure-works\garrett0 0 1 0 1
adventure-works\garrett1 0 1 0 1
adventure-works\gary0 0 1 0 1
adventure-works\gary1 0 1 0 1
adventure-works\george0 0 1 0 1
adventure-works\gigi0 0 1 0 1
adventure-works\gordon0 0 1 0 1
adventure-works\grant0 0 1 0 1
adventure-works\greg0 0 1 0 1
adventure-works\guy1 0 1 0 1
adventure-works\hanying0 0 1 0 1
adventure-works\hao0 0 1 0 1
adventure-works\hazem0 0 1 0 1
adventure-works\houman0 0 1 0 1
adventure-works\hung-fu0 0 1 0 1
adventure-works\ivo0 0 1 0 1
adventure-works\jack0 0 1 0 1
adventure-works\jack1 0 1 0 1
adventure-works\jae0 0 1 0 1
adventure-works\james0 0 1 0 1
adventure-works\james1 0 1 0 1
adventure-works\jan0 0 1 0 1
adventure-works\janaina0 0 1 0 1
adventure-works\janet0 0 1 0 1
adventure-works\janeth0 0 1 0 1
adventure-works\janice0 0 1 0 1
adventure-works\jason0 0 1 0 1
adventure-works\jay0 0 1 0 1
adventure-works\jean0 0 1 0 1
adventure-works\jeff0 0 1 0 1
adventure-works\jeffrey0 0 1 0 1
adventure-works\jianshuo0 0 1 0 1
adventure-works\jill0 0 1 0 1
adventure-works\jillian0 0 1 0 1
adventure-works\jim0 0 1 0 1
adventure-works\jimmy0 0 1 0 1
adventure-works\jinghao0 0 1 0 1
adventure-works\jo0 0 1 0 1
adventure-works\jo1 0 1 0 1
adventure-works\john1 1 1 1 1
adventure-works\john3 1 1 1 1
adventure-works\john5 1 1 1 1
adventure-works\jose0 1 1 1 1
adventure-works\jossef0 1 1 1 1
adventure-works\karan0 1 1 1 1
adventure-works\karen1 1 1 1 1
adventure-works\katie0 1 1 1 1
adventure-works\ken1 1 1 1 1
adventure-works\kevin0 1 1 1 1
adventure-works\kevin2 1 1 1 1
adventure-works\kim1 1 1 1 1
adventure-works\kirk0 1 1 1 1
adventure-works\kok-ho0 1 1 1 1
adventure-works\lane0 1 1 1 1
adventure-works\laura1 1 1 1 1
adventure-works\linda1 1 1 1 1
adventure-works\linda3 1 1 1 1
adventure-works\lolan0 1 1 1 1
adventure-works\lori1 1 1 1 1
adventure-works\lynn0 1 1 1 1
adventure-works\maciej0 0 1 0 1
adventure-works\magnus0 0 1 0 1
adventure-works\mandar0 0 1 0 1
adventure-works\marc0 0 1 0 1
adventure-works\margie0 0 1 0 1
adventure-works\mark0 0 1 0 1
adventure-works\mark1 0 1 0 1
adventure-works\mary0 0 1 0 1
adventure-works\mary1 0 1 0 1
adventure-works\mary2 0 1 0 1
adventure-works\matthias0 0 1 0 1
adventure-works\merav0 0 1 0 1
adventure-works\michael0 0 1 0 1
adventure-works\michael1 0 1 0 1
adventure-works\michael3 1 1 1 1
adventure-works\michael5 1 1 1 1
adventure-works\michael7 1 1 1 1
adventure-works\michael9 1 1 1 1
adventure-works\michiko0 0 1 0 1
adventure-works\mihail0 0 1 0 1
adventure-works\mikael0 0 1 0 1
adventure-works\mike0 0 1 0 1
adventure-works\min0 0 1 0 1
adventure-works\mindaugas0 0 1 0 1
adventure-works\nancy0 1 1 1 1
adventure-works\nitin0 1 1 1 1
adventure-works\olinda0 1 1 1 1
adventure-works\pamela0 1 1 1 1
adventure-works\patrick0 1 1 1 1
adventure-works\paul0 1 1 1 1
adventure-works\paula0 1 1 1 1
adventure-works\peng0 1 1 1 1
adventure-works\peter0 1 1 1 1
adventure-works\pilar0 1 1 1 1
adventure-works\rachel0 1 1 1 1
adventure-works\ramesh0 1 1 1 1
adventure-works\ranjit0 1 1 1 1
adventure-works\rebecca0 1 1 1 1
adventure-works\reinout0 1 1 1 1
adventure-works\rob0 1 1 1 1
adventure-works\robert0 1 1 1 1
adventure-works\rostislav0 1 1 1 1
adventure-works\russell1 1 1 1 1
adventure-works\ryan0 1 1 1 1
adventure-works\samantha0 1 1 1 1
adventure-works\sandeep0 1 1 1 1
adventure-works\sariya0 1 1 1 1
adventure-works\sean0 1 1 1 1
adventure-works\shammi0 1 1 1 1
adventure-works\sharon0 1 1 1 1
adventure-works\shelley0 1 1 1 1
adventure-works\sidney0 1 1 1 1
adventure-works\sootha0 1 1 1 1
adventure-works\stephanie0 1 1 1 1
adventure-works\steve0 1 1 1 1
adventure-works\stuart0 1 1 1 1
adventure-works\suchitra0 1 1 1 1
adventure-works\susan0 1 1 1 1
adventure-works\syed0 1 1 1 1
adventure-works\tawana0 1 1 1 1
adventure-works\tengiz0 1 1 1 1
adventure-works\terri0 1 1 1 1
adventure-works\tete0 1 1 1 1
adventure-works\thomas0 1 1 1 1
adventure-works\tsvi0 1 1 1 1
adventure-works\vidur0 1 1 1 1
adventure-works\wendy0 1 1 1 1
adventure-works\willis0 1 1 1 1
adventure-works\yvonne0 1 1 1 1
adventure-works\zainal0 0 1 0 1
adventure-works\zheng0 0 1 0 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
AK_Employee_NationalIDNumber Aug 8 2010 5:23PM 290 290 177 1 21.66207 true 290

Detailed Statistics Density

All Density Average Length Columns
0.003448276 17.66207 NationalIDNumber
0.003448276 21.66207 NationalIDNumber, BusinessEntityID

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
10708100 0 1 0 1
112457891 2 1 2 1
113695504 1 1 1 1
1300049 1 1 1 1
132674823 1 1 1 1
134969118 1 1 1 1
138280935 0 1 0 1
139397894 0 1 0 1
141165819 0 1 0 1
14417807 0 1 0 1
153288994 1 1 1 1
160739235 1 1 1 1
1662732 1 1 1 1
167554340 0 1 0 1
184188301 0 1 0 1
187369436 0 1 0 1
191644724 0 1 0 1
19312190 0 1 0 1
199546871 0 1 0 1
20244403 0 1 0 1
20269531 0 1 0 1
204035155 0 1 0 1
211789056 0 1 0 1
222400012 1 1 1 1
227319668 1 1 1 1
233069302 1 1 1 1
242381745 1 1 1 1
245797967 1 1 1 1
259388196 3 1 3 1
260770918 0 1 0 1
260805477 0 1 0 1
264306399 0 1 0 1
271438431 0 1 0 1
277173473 3 1 3 1
280633567 0 1 0 1
28414965 0 1 0 1
294148271 0 1 0 1
295847284 0 1 0 1
295971920 0 1 0 1
300946911 0 1 0 1
301435199 0 1 0 1
305522471 0 1 0 1
30845 0 1 0 1
309738752 0 1 0 1
319472946 1 1 1 1
323403273 1 1 1 1
332040978 1 1 1 1
33237992 1 1 1 1
337752649 1 1 1 1
339712426 1 1 1 1
343861179 1 1 1 1
351069889 1 1 1 1
36151748 1 1 1 1
364818297 3 1 3 1
367453993 0 1 0 1
368691270 0 1 0 1
368920189 0 1 0 1
370487086 0 1 0 1
370581729 0 1 0 1
370989364 0 1 0 1
377784364 0 1 0 1
381073001 0 1 0 1
381772114 0 1 0 1
384162788 0 1 0 1
386315192 0 1 0 1
390124815 0 1 0 1
393421437 0 1 0 1
398223854 0 1 0 1
398737566 0 1 0 1
399658727 0 1 0 1
399771412 0 1 0 1
403414852 0 1 0 1
404159499 0 1 0 1
407505660 0 1 0 1
410742000 0 1 0 1
413787783 0 1 0 1
415823523 1 1 1 1
416679555 0 1 0 1
420023788 0 1 0 1
420776180 0 1 0 1
42487730 0 1 0 1
431859843 0 1 0 1
435234965 0 1 0 1
437296311 1 1 1 1
440379437 0 1 0 1
441044382 0 1 0 1
443968955 1 1 1 1
446466105 0 1 0 1
455563743 0 1 0 1
45615666 0 1 0 1
456839592 0 1 0 1
458159238 0 1 0 1
470689086 2 1 2 1
476980013 1 1 1 1
480951955 1 1 1 1
482810518 1 1 1 1
494170342 1 1 1 1
500412746 1 1 1 1
502097814 1 1 1 1
514829225 1 1 1 1
519899904 1 1 1 1
52541318 1 1 1 1
535145551 1 1 1 1
539490372 1 1 1 1
545337468 1 1 1 1
551346974 1 1 1 1
552560652 1 1 1 1
561196580 1 1 1 1
565090917 1 1 1 1
568596888 1 1 1 1
56920285 1 1 1 1
578935259 1 1 1 1
58791499 7 1 7 1
599942664 0 1 0 1
60114406 0 1 0 1
60517918 2 1 2 1
61161660 0 1 0 1
619308550 1 1 1 1
621209647 0 1 0 1
621932914 0 1 0 1
6298838 0 1 0 1
630184120 0 1 0 1
63179277 0 1 0 1
632092621 0 1 0 1
634335025 0 1 0 1
63761469 0 1 0 1
643805155 0 1 0 1
646304055 0 1 0 1
652535724 0 1 0 1
652779496 0 1 0 1
65848458 0 1 0 1
658797903 0 1 0 1
663843431 1 1 1 1
671089628 1 1 1 1
674171828 1 1 1 1
687685941 1 1 1 1
693168613 1 1 1 1
695256908 1 1 1 1
701156975 1 1 1 1
713403643 1 1 1 1
717889520 1 1 1 1
7201901 1 1 1 1
733022683 1 1 1 1
746373306 1 1 1 1
749389530 1 1 1 1
750905084 1 1 1 1
754372876 1 1 1 1
761597760 1 1 1 1
767955365 1 1 1 1
778552911 1 1 1 1
788456780 1 1 1 1
801365500 1 1 1 1
8066363 1 1 1 1
812797414 1 1 1 1
826454897 1 1 1 1
830150469 1 1 1 1
835460180 1 1 1 1
843479922 1 1 1 1
857651804 1 1 1 1
860123571 1 1 1 1
87268837 1 1 1 1
878395493 1 1 1 1
879342154 1 1 1 1
886023130 1 1 1 1
90836195 1 1 1 1
912141525 1 1 1 1
918737118 1 1 1 1
929666391 1 1 1 1
943170460 1 1 1 1
948320468 1 1 1 1
95958330 1 1 1 1
9659517 1 1 1 1
974026903 1 1 1 1
981495526 1 1 1 1
982310417 1 1 1 1
988315686 1 1 1 1
999440576 3 1 3 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
AK_Employee_rowguid Aug 8 2010 5:23PM 290 290 186 1 20 false 290

Detailed Statistics Density

All Density Average Length Columns
0.003448276 16 rowguid
0.003448276 20 rowguid, BusinessEntityID

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
794a0b1f-c46a-401c-984d-008996fc7092 0 1 0 1
09f75454-028c-46ca-bc08-0147bd0220d7 1 1 1 1
54ed63dc-c62c-4cc7-89c2-015df49c49a5 0 1 0 1
834d7ab6-06e6-4944-b42f-028cd4bd388e 1 1 1 1
bab69951-28ad-4bca-b5ac-032746d0cc6f 0 1 0 1
5be16416-8570-417d-9e54-047db468b5e9 0 1 0 1
0c67ce00-de78-4712-908f-06939a2c58d5 1 1 1 1
4958e1c3-c872-4222-954e-09d2060ea7ef 1 1 1 1
2dc9d534-f5d1-4a14-8282-0a2a0eb6fd4d 0 1 0 1
4f46deca-ef01-41fd-9829-0adab368e431 0 1 0 1
13909262-4136-492f-bca3-0b0e3773b03e 0 1 0 1
49238447-30ee-4009-993f-0b6c756ab436 0 1 0 1
f01251e5-96a3-448d-981e-0f99d789110d 3 1 3 1
86601e6a-6955-40fc-bb4a-1053a843ce99 1 1 1 1
51fde6ac-bd50-467c-90e5-10ca7310455c 0 1 0 1
723a5921-d8a1-4659-9bc4-13c4cf7c9c91 1 1 1 1
721a2921-c415-46de-9111-13f25f428b8b 0 1 0 1
e39056f1-9cd5-478d-8945-14aca7fbdcdd 0 1 0 1
f359f5b6-5e18-4c62-8531-14d951911ce5 0 1 0 1
83ffaac6-b895-481f-b897-14f965d4da47 0 1 0 1
4fd6fe82-535a-4dd1-beb1-154a8b5e42f0 0 1 0 1
1f151abc-db4a-431a-8a5d-15f46c5b8ffc 0 1 0 1
4da76442-5eef-41fb-ae19-16c55714f9ad 0 1 0 1
62a9f73f-6443-4f2f-b864-18186614bfb6 1 1 1 1
f9e1dc46-0d03-4a8a-b693-1a964bc13e6c 1 1 1 1
756a60ae-378f-43d8-9f93-1e821d1eaf52 1 1 1 1
86d5fa9e-4bc0-48c8-91dc-1ec467418d11 1 1 1 1
692b8826-03b4-4c3b-82fc-1fc6f1409689 1 1 1 1
d4cf23d9-21b6-45e4-827c-22890df0373b 1 1 1 1
615a6bfe-3046-4037-9764-238535f725be 0 1 0 1
5be8b211-cbe5-45d8-84fd-23f36a881473 0 1 0 1
231b1798-f67b-45c1-9688-265180f93d28 1 1 1 1
c76a41f1-a390-4ae4-a82a-2a87764c6391 0 1 0 1
03a9ba14-0d5b-4671-b851-2c1721efbf01 0 1 0 1
f714b5ec-ca7c-4e6e-a812-2c5a119f4c30 0 1 0 1
1a68cd62-6fe9-4613-90d4-2cd178e4e54a 0 1 0 1
bc18a829-f0ce-4eaf-9785-2d84c86f925a 0 1 0 1
62f6ec59-5635-44f3-9cc1-2d8eeaf90a05 0 1 0 1
d54c7989-2675-4ef3-b392-370a8d264b2b 1 1 1 1
7d6b0155-0191-4599-8394-378ebde63c9a 0 1 0 1
699c00d8-c4ab-4cd2-a48f-37cbcb5bfcca 0 1 0 1
96442787-9520-4955-a457-38afddb6ff13 0 1 0 1
1629eddd-d0ae-4cb9-a59c-3a175f7027e5 0 1 0 1
eaa43680-5571-40cb-ab1a-3bf68f04459e 0 1 0 1
f78657a9-83ef-4b4d-9809-3c4c6d1a7bb4 0 1 0 1
77878c43-f16e-437d-892f-3cfcc0715a0a 0 1 0 1
1d784088-dacb-4185-9f60-3d2db4925ba5 0 1 0 1
6b10192f-d570-47c4-82c9-3d979b1efdc1 1 1 1 1
416bf905-7d6c-4692-8fd6-40f6c4f9ecc4 1 1 1 1
0217049e-1566-42b6-8027-41b751e2b00b 1 1 1 1
cdb2c6df-93e5-4558-91c8-424d5e7c658b 1 1 1 1
1f1d813d-3edc-4274-8e9b-4519d71685b6 1 1 1 1
49a05524-fa34-45b1-95bc-489901dc5b50 3 1 3 1
be81fd77-428c-449f-ab79-48b1cdf53d6a 1 1 1 1
1ad772d7-7b4a-4a7b-8676-49dd7608cb94 1 1 1 1
dc60eeed-9f9f-4435-8666-4de4fafde9c3 1 1 1 1
6b7eb306-9a00-496a-98a9-4e94fe72f77c 1 1 1 1
4a9a8407-a680-4a6b-8d03-511cb58f9a8a 0 1 0 1
8f410408-4aa8-4d67-886d-530bfe4ebe3b 0 1 0 1
e950a52a-df61-4fec-9063-545664d65b89 1 1 1 1
9a08108d-e039-4862-8f93-55f18017ad72 0 1 0 1
1f0e068a-48c5-40bf-8190-565150efdadd 0 1 0 1
a28ab377-06f5-417a-a5e2-59f459088699 0 1 0 1
1ab0edeb-7558-4734-8423-5a11b44dca35 0 1 0 1
cdc11292-df74-4fb0-8676-5b2aa4687142 1 1 1 1
c6eb2566-cf28-4602-9a25-5b91c8728838 0 1 0 1
a36b5d6b-72a5-47f8-9f6b-5d922130e760 0 1 0 1
69d5d162-e817-45e7-9dec-5d9b8310e7b1 0 1 0 1
5dd2be46-204f-4af3-91f5-5ef082f6d6a6 1 1 1 1
dc5ba622-b860-41ee-af92-5feb4779b589 0 1 0 1
18d594a8-b4ed-43c0-9c43-6033feaadf4e 0 1 0 1
c609b3b2-7969-410c-934c-62c34b63c4ee 0 1 0 1
25fc84d7-e013-44b8-82cd-63cd4723af81 0 1 0 1
54fda597-6822-42b4-b128-63eca03071f2 0 1 0 1
bb510fce-0105-4306-b591-6450d9ebf401 0 1 0 1
ac35337d-7c75-4dee-bb11-6564f257fe18 0 1 0 1
fc12677f-42f8-4790-ad69-685088ed7e5f 0 1 0 1
dc7e95ff-275e-41c2-8ed3-686864f0540a 0 1 0 1
b60712a9-50a5-4296-b892-69c4701834b0 0 1 0 1
10e5bd6f-2b9c-4192-a94d-6a2d50ea1adb 0 1 0 1
47e76b59-b137-4572-ad55-6b3e68c13bd3 0 1 0 1
08365b05-c143-4260-a93c-6b69418b1946 0 1 0 1
606c21e2-3ec0-48a6-a9fe-6bc8123ac786 0 1 0 1
045c9cbb-3448-4599-9fa9-6c7a9f82f832 0 1 0 1
e249d613-36c9-4544-9b6f-6ce50e5e0da5 2 1 2 1
f1a684f4-02db-4b22-8977-6d8d3a21100e 0 1 0 1
2474e1a9-902d-466c-b0b2-6dcac927f753 0 1 0 1
9825eb00-8e36-4506-93a2-6ddcdc0b13c3 0 1 0 1
954b91b6-5aa7-48c2-8685-6e11c6e5c49a 0 1 0 1
8b21e53d-e705-479a-b32e-6e63ac2f4bcd 0 1 0 1
1ba1d374-18ae-48ed-938f-6f5d2eec4d4d 0 1 0 1
2e680c1c-7c02-4343-9626-6f97273414c0 0 1 0 1
68616aea-81e5-4940-a7e4-6fba882bccf6 0 1 0 1
042427b8-3883-4a87-a6a3-724ee1690f49 0 1 0 1
6456cec3-9b1e-4ebc-9fd8-732b93363f65 1 1 1 1
fd53c4c8-b34e-460f-9ee5-747b07fe98b3 1 1 1 1
b3bf7fc5-2014-48ce-b7bb-76124fa8446c 1 1 1 1
51c54d34-064b-44f7-a6b1-7702bd491980 1 1 1 1
c75f2740-ace3-4ebf-91c5-7ab352e1095f 1 1 1 1
be190269-4003-4d7f-809e-7b3fdc235da8 1 1 1 1
ce256b6c-1eee-43ed-9969-7cac480ff4d7 1 1 1 1
90899830-127e-4876-85ca-7f6e03025281 1 1 1 1
ca5d1935-44e2-4c45-93bb-809e59f56796 1 1 1 1
d5e315a6-bd65-4d67-9d5f-81ef5c4ef8a6 1 1 1 1
bdadeb5c-a596-4da1-88ba-842c7a0cc10f 1 1 1 1
46286ca4-46dd-4ddb-9128-85b67e98d1a9 1 1 1 1
8261b8cb-bc3f-4bce-b364-86035d870263 1 1 1 1
43cca446-da1c-454c-8530-873ad2923e1b 1 1 1 1
51de26f0-6ed9-4a70-b689-88eb882674b6 1 1 1 1
00027a8c-c2f8-4a31-aba8-8a203638b8f1 1 1 1 1
f71c6055-557b-4660-86ff-8c0fa14b24e6 1 1 1 1
7e632b21-0d11-4bba-8a68-8cae14c20ae6 1 1 1 1
fc617bb8-d2a3-4374-873c-8ef38d80127d 1 1 1 1
72ed240a-0fd8-4423-8a49-9078ba6bcf6c 1 1 1 1
83a32d4c-4725-478f-9997-91739bb957ba 1 1 1 1
08b1ba74-dd80-4fda-8327-93268b84977b 1 1 1 1
aae1d04a-c237-4974-b4d5-935247737718 0 1 0 1
6150f197-7923-40d4-84f2-936207d468ab 0 1 0 1
4611c7c5-90a0-407f-b054-93bd51533609 0 1 0 1
85afb689-7eab-41a8-b154-9446195d5bde 0 1 0 1
8a41ed23-7ae2-4c15-aa5d-9496e721f848 1 1 1 1
53575c58-fba1-4c1a-b8ff-95e050b44393 0 1 0 1
3e3b6905-209e-442e-b8a8-9a0980241c6a 0 1 0 1
54f2fdc0-87c4-4065-a7a8-9ac8ea624235 0 1 0 1
b9eebf9f-f694-4bc2-98ec-9b4fb0379edf 0 1 0 1
ad0d7626-4506-45c4-898f-9d7a0e13aabd 0 1 0 1
65028f15-4149-4de5-b203-9d7ec86baf87 0 1 0 1
34e128cf-d904-4327-8014-9df0d5de7d08 0 1 0 1
12f678d7-ead3-4cf4-8518-a19aacf2a6d4 0 1 0 1
e720053d-922e-4c91-b81a-a1ca4ef8bb0e 0 1 0 1
bb886159-1400-4264-b7c9-a3769beb1274 0 1 0 1
8ff3af67-32f2-4a08-98c3-a40f842d41a3 0 1 0 1
b9bf7741-e0ca-4f37-acde-a4f78c6d03e9 0 1 0 1
4511abba-7f34-400e-907b-a663c20e1a41 0 1 0 1
221cbb7b-8bae-452b-a16f-a67ebb3873c8 0 1 0 1
f734d38a-56b5-471e-8ded-a682e958a9b3 0 1 0 1
31112635-663b-4018-b4a2-a685c0bf48a4 0 1 0 1
d4ed1f78-7c28-479b-bfef-a73228ba2aaa 0 1 0 1
a63966b6-9ad6-40bc-afd4-a83745879f4d 0 1 0 1
241535c7-7a31-4a6a-9e0d-a83c30c2edda 0 1 0 1
3229d93f-6a14-4bac-abc5-a91b9ecfb4d3 0 1 0 1
9f01e1fb-b893-40cc-9f5c-aaf89f9b7af5 1 1 1 1
f68c7c19-fac1-438c-9bb7-ac33fcc341c3 1 1 1 1
a6f5f72f-aa03-41b7-8b6e-b123bd360753 1 1 1 1
b3967c00-7014-4960-af15-b1a6d3094f6f 1 1 1 1
84c358d4-2493-452c-b7d6-b212c893a009 1 1 1 1
0a8937c9-68aa-4d48-ba4e-b40493d764aa 1 1 1 1
4103c891-37e8-4dfc-aeac-b55e2bc1be1c 1 1 1 1
2625c358-672a-4000-ad67-b8cd3f318285 1 1 1 1
618b71bc-6e8c-492d-8862-b9efb7a4e06a 1 1 1 1
42a506a5-0ac0-4148-b702-bb7b804ef98c 1 1 1 1
2b0876d4-8996-4e71-a613-be2e98e7accf 1 1 1 1
4652d4e4-6a27-47ed-9f51-c377e293da28 3 1 3 1
82e52d5a-165b-4c6d-9773-c3a6b6332ecd 1 1 1 1
714d519b-375e-4c5a-8491-c758d00cf95f 1 1 1 1
8d0182a3-5b59-4eea-9b3c-c7f05da9a2ce 1 1 1 1
9e912556-88ba-41ee-b946-cb84ab4c1102 1 1 1 1
9923376f-26d0-4845-9d99-cc3d696caeb8 1 1 1 1
9bef0c94-7969-4905-9a42-ce469c754800 1 1 1 1
01bcce22-d63a-4c3f-9ba8-d3d5a4c3bd52 3 1 3 1
8ef22fb3-af37-4b44-8862-d60a7cb09d82 1 1 1 1
a703169f-1563-488e-914d-d784fd07f29a 1 1 1 1
a8838ab2-99de-415c-8675-d82ebf1c4752 1 1 1 1
e87029aa-2cba-4c03-b948-d83af0313e28 1 1 1 1
300223f3-5587-4230-909b-d9c4afd6d683 1 1 1 1
891c27f4-28cc-44bb-bea3-da5ea7fbe957 1 1 1 1
e19f8de2-0f40-418c-84a2-db48b98dc6a2 1 1 1 1
9e9f713b-707c-4f7e-9504-de188052a045 1 1 1 1
2bca07d3-f2ac-4406-904f-e09156f3eb3e 1 1 1 1
f3ec557c-8b41-4ee6-bb0c-e3b93aff81e5 1 1 1 1
55f62e38-9457-46c8-a824-e46a3117a935 1 1 1 1
bb4a3e50-232e-4212-9faf-e67429febc7d 1 1 1 1
516538e8-115b-44f4-aa7b-e6c1d9f8adfc 1 1 1 1
1b480240-95c0-410f-a717-eb29943c8886 1 1 1 1
c16c501d-942d-4eb0-b5c4-ef8119fbeba2 1 1 1 1
0c7f025d-8d56-48ef-86c0-f09db63d0182 1 1 1 1
a1d86ecc-ea17-4b1b-8369-f1d07ab0a469 1 1 1 1
d9c43d08-3882-4e5c-bdf0-f6bd7004cd04 1 1 1 1
6c25a32b-88b5-4f84-a129-f7f688dfa588 1 1 1 1
9c5f84d1-fb96-4d82-92a1-f932903deaad 1 1 1 1
929fe187-ee24-4f5f-af2a-f96324f09423 1 1 1 1
2cb2d5c3-c437-49b1-9ffd-faa096f6126f 1 1 1 1
d308d387-f7f3-4b5f-abda-faf5574245cd 1 1 1 1
6175876e-8fcc-4917-be06-fc358515e6df 1 1 1 1
6b63ef27-2c55-4f4c-be29-fce8b694dc4a 0 1 0 1
b6998410-ee0f-4307-9e6e-fe348f11012d 0 1 0 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
_WA_Sys_00000006_3A81B327 Jul 18 2011 1:51AM 290 290 63 0.07017544 49.82069 true 290

Detailed Statistics Density

All Density Average Length Columns
0.01492537 49.82069 JobTitle

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
Accountant 0 2 0 1
Accounts Manager 0 1 0 1
Accounts Payable Specialist 0 2 0 1
Accounts Receivable Specialist 0 3 0 1
Application Specialist 0 4 0 1
Assistant to the Chief Financial Officer 0 1 0 1
Benefits Specialist 0 1 0 1
Buyer 0 9 0 1
Chief Executive Officer 0 1 0 1
Chief Financial Officer 0 1 0 1
Control Specialist 0 2 0 1
Database Administrator 0 2 0 1
Design Engineer 0 3 0 1
Document Control Assistant 0 2 0 1
Document Control Manager 0 1 0 1
Engineering Manager 0 1 0 1
European Sales Manager 0 1 0 1
Facilities Administrative Assistant 0 1 0 1
Facilities Manager 0 1 0 1
Finance Manager 0 1 0 1
Human Resources Administrative Assistant 0 2 0 1
Human Resources Manager 0 1 0 1
Information Services Manager 0 1 0 1
Janitor 0 4 0 1
Maintenance Supervisor 0 1 0 1
Marketing Assistant 0 3 0 1
Marketing Manager 0 1 0 1
Marketing Specialist 0 5 0 1
Master Scheduler 0 1 0 1
Network Administrator 0 2 0 1
Network Manager 0 1 0 1
North American Sales Manager 0 1 0 1
Pacific Sales Manager 0 1 0 1
Production Control Manager 0 1 0 1
Production Supervisor - WC10 0 3 0 1
Production Supervisor - WC30 3 3 1 3
Production Supervisor - WC40 0 3 0 1
Production Supervisor - WC45 0 3 0 1
Production Supervisor - WC60 3 3 1 3
Production Technician - WC10 0 17 0 1
Production Technician - WC20 0 22 0 1
Production Technician - WC40 25 26 1 25
Production Technician - WC45 0 15 0 1
Production Technician - WC60 26 26 1 26
Purchasing Assistant 0 2 0 1
Purchasing Manager 0 1 0 1
Quality Assurance Manager 0 1 0 1
Quality Assurance Supervisor 0 1 0 1
Quality Assurance Technician 0 4 0 1
Recruiter 0 2 0 1
Research and Development Engineer 0 2 0 1
Research and Development Manager 0 2 0 1
Sales Representative 0 14 0 1
Scheduling Assistant 0 4 0 1
Senior Design Engineer 0 1 0 1
Senior Tool Designer 0 2 0 1
Shipping and Receiving Clerk 0 2 0 1
Shipping and Receiving Supervisor 0 1 0 1
Stocker 0 3 0 1
Tool Designer 0 2 0 1
Vice President of Engineering 0 1 0 1
Vice President of Production 0 1 0 1
Vice President of Sales 0 1 0 1

Objects that depend on [Employee]

Objects on which [Employee] depends

SQL

Script
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
CREATE TABLE [HumanResources].[Employee]( [BusinessEntityID] [int] NOT NULL, [NationalIDNumber] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [LoginID] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [OrganizationNode] [hierarchyid] NULL, [OrganizationLevel] AS ([OrganizationNode].[GetLevel]()), [JobTitle] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [BirthDate] [date] NOT NULL, [MaritalStatus] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Gender] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [HireDate] [date] NOT NULL, [SalariedFlag] [dbo].[Flag] NOT NULL, [VacationHours] [smallint] NOT NULL, [SickLeaveHours] [smallint] NOT NULL, [CurrentFlag] [dbo].[Flag] NOT NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for Employee records. Foreign key to BusinessEntity.BusinessEntityID.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'BusinessEntityID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique national identification number such as a social security number.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'NationalIDNumber'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Network login.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'LoginID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Where the employee is located in corporate hierarchy.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'OrganizationNode'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The depth of the employee in the corporate hierarchy.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'OrganizationLevel'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Work title such as Buyer or Sales Representative.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'JobTitle'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date of birth.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'BirthDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'M = Married, S = Single' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'MaritalStatus'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'M = Male, F = Female' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'Gender'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Employee hired on this date.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'HireDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'SalariedFlag'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Number of available vacation hours.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'VacationHours'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Number of available sick leave hours.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'SickLeaveHours'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0 = Inactive, 1 = Active' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'CurrentFlag'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'rowguid'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Employee information such as salary, department, and title.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee'

See also

List of Tables