Northwind Database (Document! X Sample)
AdventureWorks Database / HumanResources Schema
In This Topic
    HumanResources Schema
    In This Topic
    Description
    Contains objects related to employees and departments.
    Tables
    TableDescription
    Lookup table containing the departments within the Adventure Works Cycles company.
    Employee information such as salary, department, and title.
    Employee department transfers.
    Employee pay history.
    Résumés submitted to Human Resources by job applicants.
    Work shift lookup table.
    Views
    ViewDescription
    Employee names and addresses.
    Returns employee name, title, and current department.
    Returns employee name and current and previous departments.
    Job candidate names and resumes.
    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.
    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 Procedures
    Stored ProcedureDescription
    Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.
    Updates the Employee table with the values specified in the input parameters for the given BusinessEntityID.
    Updates the Employee table with the values specified in the input parameters for the given EmployeeID.
    See Also

    Related Objects

    AdventureWorks Database