Generated using SQL Data Dictionary demo version.


Table HumanResources.Employee (290 rows)


Employee information such as salary, department, and title.


  Column Data Type Identity Nullable Default
PK, FK BusinessEntityID int
Primary key for Employee records. Foreign key to BusinessEntity.BusinessEntityID.
UK NationalIDNumber nvarchar(15)
Unique national identification number such as a social security number.
UK LoginID nvarchar(256)
Network login.
OrganizationNode hierarchyid X
Where the employee is located in corporate hierarchy.
OrganizationLevel smallint X
The depth of the employee in the corporate hierarchy.
JobTitle nvarchar(50)
Work title such as Buyer or Sales Representative.
BirthDate date
Date of birth.
MaritalStatus nchar(1)
M = Married, S = Single
Gender nchar(1)
M = Male, F = Female
HireDate date
Employee hired on this date.
SalariedFlag Flag(bit) 1
Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining.
VacationHours smallint 0
Number of available vacation hours.
SickLeaveHours smallint 0
Number of available sick leave hours.
CurrentFlag Flag(bit) 1
0 = Inactive, 1 = Active
UK rowguid uniqueidentifier newid()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate datetime getdate()
Date and time the record was last updated.

Indexes:


References:


Referenced by:


Triggers:


Used by: