| AdventureWorks Database : HumanResources Schema |
| Table | Description |
|---|---|
| HumanResources.Department | Lookup table containing the departments within the Adventure Works Cycles company. |
| HumanResources.Employee | Employee information such as salary, department, and title. |
| HumanResources.EmployeeAddress | Cross-reference table mapping employees to their address(es). |
| HumanResources.EmployeeDepartmentHistory | Employee department transfers. |
| HumanResources.EmployeePayHistory | Employee pay history. |
| HumanResources.JobCandidate | Résumés submitted to Human Resources by job applicants. |
| HumanResources.Shift | Work shift lookup table. |
| View | Description |
|---|---|
| HumanResources.vEmployee | Employee names and addresses. |
| HumanResources.vEmployeeDepartment | Returns employee name, title, and current department. |
| HumanResources.vEmployeeDepartmentHistory | Returns employee name and current and previous departments. |
| HumanResources.vJobCandidate | Job candidate names and resumes. |
| HumanResources.vJobCandidateEducation | Displays the content from each education related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed. |
| HumanResources.vJobCandidateEmployment | Displays the content from each employement history related element in the xml column Resume in the HumanResources.JobCandidate table. The content has been localized into French, Simplified Chinese and Thai. Some data may not display correctly unless supplemental language support is installed. |
| Stored Procedure | Description |
|---|---|
| HumanResources.uspUpdateEmployeeHireInfo | Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters. |
| HumanResources.uspUpdateEmployeeLogin | Updates the Employee table with the values specified in the input parameters for the given EmployeeID. |
| HumanResources.uspUpdateEmployeePersonalInfo | Updates the Employee table with the values specified in the input parameters for the given EmployeeID. |
| Default | Description |
|---|---|
| HumanResources.Default_Phone_Number |
| Rule | Description |
|---|---|
| HumanResources.Rule_Phone_Number |