| Database Object | Object Type | Description | Dep Level |
 | dEmployee | Trigger | INSTEAD OF DELETE trigger which keeps Employees from being deleted. | 1 |
 | HumanResources.EmployeeAddress | Table | Cross-reference table mapping employees to their address(es). | 1 |
 | HumanResources.EmployeeDepartmentHistory | Table | Employee department transfers. | 1 |
 | HumanResources.EmployeePayHistory | Table | Employee pay history. | 1 |
 | iduSalesOrderDetail | Trigger | AFTER INSERT, DELETE, UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in SalesOrderDetail and updates the SalesOrderHeader.SubTotal column. | 4 |
 | Sales.Individual | Table | Demographic data about customers that purchase Adventure Works products online. | 3 |
 | iPurchaseOrderDetail | Trigger | AFTER INSERT trigger that inserts a row in the TransactionHistory table and updates the PurchaseOrderHeader.SubTotal column. | 3 |
 | iStore | Trigger | AFTER INSERT trigger inserting Store only if the Customer does not exist in the Individual table. | 3 |
 | iuIndividual | Trigger | AFTER INSERT, UPDATE trigger inserting Individual only if the Customer does not exist in the Store table and setting the ModifiedDate column in the Individual table to the current date. | 4 |
 | HumanResources.JobCandidate | Table | Résumés submitted to Human Resources by job applicants. | 1 |
 | Purchasing.PurchaseOrderDetail | Table | Individual products associated with a specific purchase order. See PurchaseOrderHeader. | 2 |
 | Purchasing.PurchaseOrderHeader | Table | General purchase order information. See PurchaseOrderDetail. | 1 |
 | Sales.SalesOrderDetail | Table | Individual products associated with a specific sales order. See SalesOrderHeader. | 3 |
 | Sales.SalesOrderHeader | Table | General sales order information. | 2 |
 | Sales.SalesOrderHeaderSalesReason | Table | Cross-reference table mapping sales orders to sales reason codes. | 3 |
 | Sales.SalesPerson | Table | Sales representative current information. | 1 |
 | Sales.SalesPersonQuotaHistory | Table | Sales performance tracking. | 2 |
 | Sales.SalesTerritoryHistory | Table | Sales representative transfers to other sales territories. | 2 |
 | Sales.Store | Table | Customers (resellers) of Adventure Works products. | 2 |
 | Sales.StoreContact | Table | Cross-reference table mapping stores and their employees. | 3 |
 | dbo.ufnGetContactInformation | User Defined Function | Table value function returning the first name, last name, job title and contact type for a given contact. | 1 |
 | uPurchaseOrderDetail | Trigger | AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in PurchaseOrderDetail and updates the PurchaseOrderHeader.SubTotal column. | 3 |
 | uPurchaseOrderHeader | Trigger | AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the PurchaseOrderHeader table. | 2 |
 | uSalesOrderHeader | Trigger | AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the SalesOrderHeader table.Updates the SalesYTD column in the SalesPerson and SalesTerritory tables. | 3 |
 | dbo.uspGetEmployeeManagers | Stored Procedure | Stored procedure using a recursive query to return the direct and indirect managers of the specified employee. | 1 |
 | dbo.uspGetManagerEmployees | Stored Procedure | Stored procedure using a recursive query to return the direct and indirect employees of the specified manager. | 1 |
 | HumanResources.uspUpdateEmployeeHireInfo | Stored Procedure | Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters. | 1 |
 | HumanResources.uspUpdateEmployeeLogin | Stored Procedure | Updates the Employee table with the values specified in the input parameters for the given EmployeeID. | 1 |
 | HumanResources.uspUpdateEmployeePersonalInfo | Stored Procedure | Updates the Employee table with the values specified in the input parameters for the given EmployeeID. | 1 |
 | HumanResources.vEmployee | View | Employee names and addresses. | 1 |
 | HumanResources.vEmployeeDepartment | View | Returns employee name, title, and current department. | 1 |
 | HumanResources.vEmployeeDepartmentHistory | View | Returns employee name and current and previous departments. | 1 |
 | Sales.vIndividualCustomer | View | Individual customers (names and addresses) that purchase Adventure Works Cycles products online. | 4 |
 | Sales.vIndividualDemographics | View | Displays the content from each element in the xml column Demographics for each customer in the Sales.Individual table. | 4 |
 | HumanResources.vJobCandidate | View | Job candidate names and resumes. | 2 |
 | HumanResources.vJobCandidateEducation | View | 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. | 2 |
 | HumanResources.vJobCandidateEmployment | View | 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. | 2 |
 | Sales.vSalesPerson | View | Sales representiatives (names and addresses) and their sales-related information. | 1 |
 | Sales.vSalesPersonSalesByFiscalYears | View | Uses PIVOT to return aggregated sales information for each sales representative. | 1 |
 | Sales.vStoreWithDemographics | View | Stores (names and addresses) that sell Adventure Works Cycles products to consumers. | 3 |