HumanResources.Employee (table)

wikibot

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	dbo.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	dbo.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

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

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

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

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

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