HumanResources.Employee - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	HumanResources
Name	Employee
Module	Human Resources

Employee information such as salary, department, and title.

Columns

		Name	Data type	Attributes	References	Description
	1	BusinessEntityID	int		Person.Person	Primary key for Employee records. Foreign key to BusinessEntity.BusinessEntityID.
Primary key for Employee records. Foreign key to BusinessEntity.BusinessEntityID. References: Person.Person
	2	NationalIDNumber	nvarchar(15)			Unique national identification number such as a social security number.
Unique national identification number such as a social security number.
	3	LoginID	nvarchar(256)			Network login. Test2
Network login. Test2
	4	OrganizationNode	hierarchyid			Where the employee is located in corporate hierarchy.
Where the employee is located in corporate hierarchy.
	5	OrganizationLevel	smallint	Computed: [OrganizationNode].[GetLevel]()		The depth of the employee in the corporate hierarchy.
The depth of the employee in the corporate hierarchy. Computed: [OrganizationNode].[GetLevel]()
	6	JobTitle	nvarchar(50)			Work title such as Buyer or Sales Representative.
Work title such as Buyer or Sales Representative.
	7	BirthDate	date			Date of birth.
Date of birth.
	8	MaritalStatus	nchar(1)			M = Married, S = Single
M = Married, S = Single
	9	Gender	nchar(1)			M = Male, F = Female
M = Male, F = Female
	10	HireDate	date			Employee hired on this date.
Employee hired on this date.
	11	SalariedFlag	bit	Default: 1		Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining.
Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining. Default: 1
	12	VacationHours	smallint	Default: 0		Number of available vacation hours.
Number of available vacation hours. Default: 0
	13	SickLeaveHours	smallint	Default: 0		Number of available sick leave hours.
Number of available sick leave hours. Default: 0
	14	CurrentFlag	bit	Default: 1		0 = Inactive, 1 = Active
0 = Inactive, 1 = Active Default: 1
	15	rowguid	uniqueidentifier	Default: newid()		ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. Default: newid()
	16	ModifiedDate	datetime	Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table	Primary table	Join	Title / Name / Description
HumanResources.Employee	HumanResources.EmployeeDepartmentHistory		sdsdsd fk_EmployeeDepartmentHistory_Employee
Title: sdsdsd Name: fk_EmployeeDepartmentHistory_Employee
HumanResources.Employee	Person.Person	HumanResources.Employee.BusinessEntityID = Person.Person.BusinessEntityID	FK_Employee_Person_BusinessEntityID Foreign key constraint referencing Person.BusinessEntityID.
HumanResources.Employee.BusinessEntityID = Person.Person.BusinessEntityID Name: FK_Employee_Person_BusinessEntityID Foreign key constraint referencing Person.BusinessEntityID.
HumanResources.Employee	HumanResources.Shift		zzz zxczxc
Name: zzz zxczxc
HumanResources.Employee	HumanResources.vEmployeeDepartment		qqq asdasda
Name: qqq asdasda
HumanResources.EmployeeDepartmentHistory	HumanResources.Employee	HumanResources.EmployeeDepartmentHistory.BusinessEntityID = HumanResources.Employee.BusinessEntityID	FK_EmployeeDepartmentHistory_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.
HumanResources.EmployeeDepartmentHistory.BusinessEntityID = HumanResources.Employee.BusinessEntityID Name: FK_EmployeeDepartmentHistory_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.
HumanResources.EmployeePayHistory	HumanResources.Employee	HumanResources.EmployeePayHistory.BusinessEntityID = HumanResources.Employee.BusinessEntityID	FK_EmployeePayHistory_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.
HumanResources.EmployeePayHistory.BusinessEntityID = HumanResources.Employee.BusinessEntityID Name: FK_EmployeePayHistory_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.
HumanResources.JobCandidate	HumanResources.Employee	HumanResources.JobCandidate.BusinessEntityID = HumanResources.Employee.BusinessEntityID	FK_JobCandidate_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.
HumanResources.JobCandidate.BusinessEntityID = HumanResources.Employee.BusinessEntityID Name: FK_JobCandidate_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.
Purchasing.PurchaseOrderHeader	HumanResources.Employee	Purchasing.PurchaseOrderHeader.EmployeeID = HumanResources.Employee.BusinessEntityID	FK_PurchaseOrderHeader_Employee_EmployeeID Foreign key constraint referencing Employee.EmployeeID.
Purchasing.PurchaseOrderHeader.EmployeeID = HumanResources.Employee.BusinessEntityID Name: FK_PurchaseOrderHeader_Employee_EmployeeID Foreign key constraint referencing Employee.EmployeeID.
Sales.SalesPerson	HumanResources.Employee	Sales.SalesPerson.BusinessEntityID = HumanResources.Employee.BusinessEntityID	FK_SalesPerson_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.
Sales.SalesPerson.BusinessEntityID = HumanResources.Employee.BusinessEntityID Name: FK_SalesPerson_Employee_BusinessEntityID Foreign key constraint referencing Employee.EmployeeID.

Unique keys

	Key name	Columns	Description
	PK_Employee_BusinessEntityID	BusinessEntityID	Primary key (clustered) constraint
Primary key (clustered) constraint
	fvxzcvbxb	BirthDate	cxvbxcvbvbvcb
cxvbxcvbvbvcb
	AK_Employee_LoginID	LoginID	Unique nonclustered index.
Unique nonclustered index.
	AK_Employee_NationalIDNumber	NationalIDNumber	Unique nonclustered index.
Unique nonclustered index.
	AK_Employee_rowguid	rowguid	Unique nonclustered index. Used to support replication samples.
Unique nonclustered index. Used to support replication samples.

Triggers

	Key name	When	Description
	dEmployee	Instead Of Delete	INSTEAD OF DELETE trigger which keeps Employees from being deleted.
CREATE TRIGGER [HumanResources].[dEmployee] ON HumanResources.Employee INSTEAD OF DELETE NOT FOR REPLICATION AS BEGIN DECLARE @Count int; SET @Count = @@ROWCOUNT; IF @Count = 0 RETURN; SET NOCOUNT ON; BEGIN RAISERROR (N'Employees cannot be deleted. They can only be marked as not current.', -- Message 10, -- Severity. 1); -- State. -- Rollback any active or uncommittable transactions IF @@TRANCOUNT > 0 BEGIN ROLLBACK TRANSACTION; END END; END;
INSTEAD OF DELETE trigger which keeps Employees from being deleted.
CREATE TRIGGER [HumanResources].[dEmployee] ON HumanResources.Employee INSTEAD OF DELETE NOT FOR REPLICATION AS BEGIN DECLARE @Count int; SET @Count = @@ROWCOUNT; IF @Count = 0 RETURN; SET NOCOUNT ON; BEGIN RAISERROR (N'Employees cannot be deleted. They can only be marked as not current.', -- Message 10, -- Severity. 1); -- State. -- Rollback any active or uncommittable transactions IF @@TRANCOUNT > 0 BEGIN ROLLBACK TRANSACTION; END END; END;

Uses

Name
HumanResources.Employee
HumanResources.Employee
HumanResources.EmployeeDepartmentHistory (sdsdsd)
HumanResources.Shift
Person.Person
HumanResources.vEmployeeDepartment

Used by

Name
HumanResources.Employee
HumanResources.Employee
HumanResources.vEmployee
HumanResources.vEmployeeDepartment
HumanResources.vEmployeeDepartmentHistory
Sales.vSalesPerson
Sales.vSalesPersonSalesByFiscalYears
dbo.uspGetEmployeeManagers
dbo.uspGetManagerEmployees
HumanResources.uspUpdateEmployeeHireInfo
HumanResources.uspUpdateEmployeeLogin
HumanResources.uspUpdateEmployeePersonalInfo
dbo.ufnGetContactInformation
HumanResources.EmployeeDepartmentHistory
HumanResources.EmployeePayHistory
HumanResources.JobCandidate
Purchasing.PurchaseOrderHeader
Sales.SalesPerson

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56