HumanResources.Employee (table)

wikibot

Table

HumanResources.Employee

Column	Data Type	Nullable	Default	PK	Index
EmployeeID	int	not null		PK_Employee_EmployeeID
NationalIDNumber	nvarchar(15)	not null			AK_Employee_NationalIDNumber
ContactID	int	not null
LoginID	nvarchar(256)	not null			AK_Employee_LoginID
ManagerID	int	null			IX_Employee_ManagerID
Title	nvarchar(50)	not null
BirthDate	datetime	not null
MaritalStatus	nchar(1)	not null
Gender	nchar(1)	not null
HireDate	datetime	not null
SalariedFlag	dbo.Flag	not null	((1))
VacationHours	smallint	not null	((0))
SickLeaveHours	smallint	not null	((0))
CurrentFlag	dbo.Flag	not null	((1))
rowguid	uniqueidentifier	not null	(newid())		AK_Employee_rowguid
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Person.Contact	ContactID	ContactID
HumanResources.Employee	ManagerID	EmployeeID

Detail Table	Column	Referencing Column
HumanResources.Employee	EmployeeID	ManagerID
HumanResources.EmployeeAddress	EmployeeID	EmployeeID
HumanResources.EmployeeDepartmentHistory	EmployeeID	EmployeeID
HumanResources.EmployeePayHistory	EmployeeID	EmployeeID
HumanResources.JobCandidate	EmployeeID	EmployeeID
Purchasing.PurchaseOrderHeader	EmployeeID	EmployeeID
Sales.SalesPerson	EmployeeID	SalesPersonID

Triggers	Type
dEmployee	INSTEAD OF DELETE

automatically generated

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

Column	Data Type	Nullable	Default	Description / PK / Index
EmployeeID	int	not null		Primary key for Employee records. PK_Employee_EmployeeID
NationalIDNumber	nvarchar(15)	not null		Unique national identification number such as a social security number. AK_Employee_NationalIDNumber
ContactID	int	not null		Identifies the employee in the Contact table. Foreign key to Contact.ContactID.
LoginID	nvarchar(256)	not null		Network login. AK_Employee_LoginID
ManagerID	int	null		Manager to whom the employee is assigned. Foreign Key to Employee.M IX_Employee_ManagerID
Title	nvarchar(50)	not null		Work title such as Buyer or Sales Representative.
BirthDate	datetime	not null		Date of birth.
MaritalStatus	nchar(1)	not null		M = Married, S = Single
Gender	nchar(1)	not null		M = Male, F = Female
HireDate	datetime	not null		Employee hired on this date.
SalariedFlag	Flag	not null	(1)	Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining.
VacationHours	smallint	not null	(0)	Number of available vacation hours.
SickLeaveHours	smallint	not null	(0)	Number of available sick leave hours.
CurrentFlag	Flag	not null	(1)	0 = Inactive, 1 = Active
rowguid	uniqueidentifier	not null	(NEWID())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. AK_Employee_rowguid
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Relation	Column	Referenced Column
Person.Contact	ContactID	ContactID
HumanResources.Employee	ManagerID	EmployeeID

Detail Table	Column	Referencing Column
HumanResources.Employee	EmployeeID	ManagerID
HumanResources.EmployeeAddress	EmployeeID	EmployeeID
HumanResources.EmployeeDepartmentHistory	EmployeeID	EmployeeID
HumanResources.EmployeePayHistory	EmployeeID	EmployeeID
HumanResources.JobCandidate	EmployeeID	EmployeeID
Purchasing.PurchaseOrderHeader	EmployeeID	EmployeeID
Sales.SalesPerson	EmployeeID	SalesPersonID

Triggers	Type
dEmployee	INSTEAD OF DELETE

Referenced Object	Object Type	Dependency Type
dbo.Flag	Type	Data Type

Referencing Object	Object Type	Reference Type
HumanResources.vEmployee	View	Select
HumanResources.vEmployeeDepartment	View	Select
HumanResources.vEmployeeDepartmentHistory	View	Select
Sales.vSalesPerson	View	Select
Sales.vSalesPersonSalesByFiscalYears	View	Select
dbo.uspGetEmployeeManagers	Procedure	Select
dbo.uspGetManagerEmployees	Procedure	Select
HumanResources.uspUpdateEmployeeHireInfo	Procedure	Update
HumanResources.uspUpdateEmployeeLogin	Procedure	Update
HumanResources.uspUpdateEmployeePersonalInfo	Procedure	Update
dbo.ufnGetContactInformation	SQL table-valued-function	Select