HumanResources.Employee

Table: 'HumanResources.Employee'

16 fields. 728 bytes.

Employee information such as salary, department, and title.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
EmployeeID	int identity		int		Not null	Primary key for Employee records.
NationalIDNumber	nvarchar	15			Not null	Unique national identification number such as a social security number.
ContactID	int				Not null	Identifies the employee in the Contact table. Foreign key to Contact.ContactID.
LoginID	nvarchar	256			Not null	Network login.
ManagerID	int				Null	Manager to whom the employee is assigned. Foreign Key to Employee.M
Title	nvarchar	50			Not null	Work title such as Buyer or Sales Representative.
BirthDate	datetime				Not null	Date of birth.	([BirthDate]>='1930-01-01' AND [BirthDate]<=dateadd(year,(-18),getdate()))
MaritalStatus	nchar	1			Not null	M = Married, S = Single	(upper([MaritalStatus])='S' OR upper([MaritalStatus])='M')
Gender	nchar	1			Not null	M = Male, F = Female	(upper([Gender])='F' OR upper([Gender])='M')
HireDate	datetime				Not null	Employee hired on this date.	([HireDate]>='1996-07-01' AND [HireDate]<=dateadd(day,(1),getdate()))
SalariedFlag	Flag		bit	(1)	Not null	Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining.
VacationHours	smallint			(0)	Not null	Number of available vacation hours.	([VacationHours]>=(-40) AND [VacationHours]<=(240))
SickLeaveHours	smallint			(0)	Not null	Number of available sick leave hours.	([SickLeaveHours]>=(0) AND [SickLeaveHours]<=(120))
CurrentFlag	Flag		bit	(1)	Not null	0 = Inactive, 1 = Active
rowguid	uniqueidentifier			newid()	Not null	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'HumanResources.Employee'

Primary Key Name	Field Name
PK_Employee_EmployeeID	EmployeeID

Foreign keys for table 'HumanResources.Employee', 2 items

Foreign	Primary	Key Name
Employee.ManagerID	Employee.EmployeeID	FK_Employee_Employee_ManagerID
Employee.ContactID	Contact.ContactID	FK_Employee_Contact_ContactID

Indexes for table 'HumanResources.Employee', 5 items

Index Name	Description	Clustered	Unique	Fields
PK_Employee_EmployeeID	Clustered index created by a primary key constraint.	Yes	Yes	EmployeeID
AK_Employee_LoginID	Unique nonclustered index.	No	Yes	LoginID
AK_Employee_NationalIDNumber	Unique nonclustered index.	No	Yes	NationalIDNumber
AK_Employee_rowguid	Unique nonclustered index. Used to support replication samples.	No	Yes	rowguid
IX_Employee_ManagerID	Nonclustered index.	No	No	ManagerID

Triggers for table 'HumanResources.Employee', 2 items

Name	Description	Type	Enabled
dEmployee	INSTEAD OF DELETE trigger which keeps Employees from being deleted.	instead of Delete	Yes
uEmployee	AFTER UPDATE trigger setting the ModifiedDate column in the Employee table to the current date.	after Update	Yes

Dependencies for table 'HumanResources.Employee', 18 items

Object Name	Type	Field Name
dbo.ufnGetContactInformation	table function	N/A
dbo.uspGetEmployeeManagers	stored procedure	N/A
dbo.uspGetManagerEmployees	stored procedure	N/A
HumanResources.CK_Employee_BirthDate	check cns	N/A
HumanResources.CK_Employee_Gender	check cns	N/A
HumanResources.CK_Employee_HireDate	check cns	N/A
HumanResources.CK_Employee_MaritalStatus	check cns	N/A
HumanResources.CK_Employee_SickLeaveHours	check cns	N/A
HumanResources.CK_Employee_VacationHours	check cns	N/A
HumanResources.uEmployee	trigger	N/A
HumanResources.uspUpdateEmployeeHireInfo	stored procedure	N/A
HumanResources.uspUpdateEmployeeLogin	stored procedure	N/A
HumanResources.uspUpdateEmployeePersonalInfo	stored procedure	N/A
HumanResources.vEmployee	view	N/A
HumanResources.vEmployeeDepartment	view	N/A
HumanResources.vEmployeeDepartmentHistory	view	N/A
Sales.vSalesPerson	view	N/A
Sales.vSalesPersonSalesByFiscalYears	view	N/A