Human Resources - AdventureWorks

AdventureWorks

- AdventureWorks

Employees of Adventure Works Cycles.

Tables

		Name
1		HumanResources.Department
2		HumanResources.Employee
3		HumanResources.EmployeeDepartmentHistory
4		HumanResources.EmployeePayHistory
5		HumanResources.JobCandidate
6		HumanResources.Shift

Views

		Name
1		HumanResources.vEmployee
2		HumanResources.vEmployeeDepartment
3		HumanResources.vEmployeeDepartmentHistory
4		HumanResources.vJobCandidate
5		HumanResources.vJobCandidateEducation
6		HumanResources.vJobCandidateEmployment

Procedures

		Name
1		dbo.uspGetEmployeeManagers
2		dbo.uspGetManagerEmployees
3		dbo.uspSearchCandidateResumes
4		HumanResources.uspUpdateEmployeeHireInfo
5		HumanResources.uspUpdateEmployeeLogin
6		HumanResources.uspUpdateEmployeePersonalInfo

Functions

		Name
1		dbo.ufnGetContactInformation