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())

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

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.

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

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