Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.
wikibot
Schema HumanResources Description Contains objects related to employees and departments. Source
CREATE SCHEMA HumanResources AUTHORIZATION dbo
Dependencies Reference Type Object Type Referencing Object Schema Table HumanResources.Department Schema Table HumanResources.Employee Schema Table HumanResources.EmployeeAddress Schema Table HumanResources.EmployeeDepartmentHistory Schema Table [...]
wikibot
Table HumanResources.Employee Description Employee information such as salary, department, and title. Columns Column Data Type Nullable Default Description EmployeeID int not null Primary key for Employee records. NationalIDNumber nvarchar(15) not null Unique national identification number such as a social security number. ContactID int not null Identifies the employee in the Contact table. Foreign key to Contact.ContactID. LoginID nvarchar(256) not null Network login. ManagerID int null Manager to whom the employee is assigned. [...]
[...] (Sales)
Customer (Sales)
CustomerAddress (Sales)
DatabaseLog (dbo)
Department (HumanResources)
Document (Production)
Employee (HumanResources)
EmployeeAddress (HumanResources)
EmployeeDepartmentHistory (HumanResources)
EmployeePayHistory (HumanResources)
ErrorLog (dbo)
Illustration (Production)
Individual (Sales)
JobCandidate (HumanResources)
Location (Production) [...]
wikibot
View HumanResources.vEmployeeDepartmentHistory Description Returns employee name and current and previous departments. Source
CREATE VIEW [HumanResources].[vEmployeeDepartmentHistory]
AS
SELECT
e.[EmployeeID]
,c.[Title]
,c.[FirstName]
,c.[MiddleName]
,c.[LastName]
,c.[Suffix]
,s.[Name] AS [Shift]
,d.[Name] AS [Department]
,d.[GroupName]
,edh.[StartDate]
,edh.[EndDate]
FROM [HumanResources].[Employee] e
INNER JOIN [Person].[Contact] c
[...]
wikibot
View HumanResources.vEmployeeDepartment Description Returns employee name, title, and current department. Source
CREATE VIEW [HumanResources].[vEmployeeDepartment]
AS
SELECT
e.[EmployeeID]
,c.[Title]
,c.[FirstName]
,c.[MiddleName]
,c.[LastName]
,c.[Suffix]
,e.[Title] AS [JobTitle]
,d.[Name] AS [Department]
,d.[GroupName]
,edh.[StartDate]
FROM [HumanResources].[Employee] e
INNER JOIN [Person].[Contact] c
ON c.[ContactID] = e.[ContactID]
[...]
wikibot
Table HumanResources.EmployeeDepartmentHistory Description Employee department transfers. Columns Column Data Type Nullable Default Description EmployeeID int not null Employee identification number. Foreign key to Employee.EmployeeID. DepartmentID smallint not null Department in which the employee worked including currently. Foreign key to Department.DepartmentID. ShiftID tinyint not null Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID. StartDate datetime not null Date the employee started work in [...]
wikibot
View HumanResources.vEmployee Description Employee names and addresses. Source
CREATE VIEW [HumanResources].[vEmployee]
AS
SELECT
e.[EmployeeID]
,c.[Title]
,c.[FirstName]
,c.[MiddleName]
,c.[LastName]
,c.[Suffix]
,e.[Title] AS [JobTitle]
,c.[Phone]
,c.[EmailAddress]
,c.[EmailPromotion]
,a.[AddressLine1]
,a.[AddressLine2]
,a.[City]
,sp.[Name] AS [StateProvinceName]
,a.[PostalCode]
,cr.[Name] AS [CountryRegionName]
,c.[AdditionalContactInfo]
FROM [HumanResources].[Employee] [...]
wikibot
Procedure HumanResources.uspUpdateEmployeeHireInfo Description Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters. Source
CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeHireInfo]
@EmployeeID [int],
@Title [nvarchar](50),
@HireDate [datetime],
@RateChangeDate [datetime],
@Rate [money],
@PayFrequency [tinyint],
@CurrentFlag [dbo].[Flag]
WITH EXECUTE AS CALLER
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
[...]
wikibot
Table HumanResources.JobCandidate Description Résumés submitted to Human Resources by job applicants. Columns Column Data Type Nullable Default Description JobCandidateID int not null Primary key for JobCandidate records. EmployeeID int null Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID. Resume xml null Résumé in XML format. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_JobCandidate_JobCandidateID JobCandidateID [...]
wikibot
View HumanResources.vJobCandidateEducation Description 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. Source
CREATE VIEW [HumanResources].[vJobCandidateEducation]
AS
SELECT
jc.[JobCandidateID]
,[Education].ref.value(N'declare default element namespace [...]
wikibot
View HumanResources.vJobCandidateEmployment Description 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. Source
CREATE VIEW [HumanResources].[vJobCandidateEmployment]
AS
SELECT
jc.[JobCandidateID]
,CONVERT(datetime, REPLACE([Employment].ref.value(N'declare [...]
wikibot
Procedure HumanResources.uspUpdateEmployeeLogin Description Updates the Employee table with the values specified in the input parameters for the given EmployeeID. Source
CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeLogin]
@EmployeeID [int],
@ManagerID [int],
@LoginID [nvarchar](256),
@Title [nvarchar](50),
@HireDate [datetime],
@CurrentFlag [dbo].[Flag]
WITH EXECUTE AS CALLER
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
UPDATE [HumanResources].[Employee]
[...]
wikibot
Table HumanResources.Shift Description Work shift lookup table. Columns Column Data Type Nullable Default Description ShiftID tinyint not null Primary key for Shift records. Name dbo.Name not null Shift description. StartTime datetime not null Shift start time. EndTime datetime not null Shift end time. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_Shift_ShiftID ShiftID Indexes Index Type Columns AK_Shift_Name Unique Name AK_Shift_StartTime_EndTime [...]
wikibot
View HumanResources.vJobCandidate Description Job candidate names and resumes. Source
CREATE VIEW [HumanResources].[vJobCandidate]
AS
SELECT
jc.[JobCandidateID]
,jc.[EmployeeID]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
(/Resume/Name/Name.Prefix)[1]', 'nvarchar(30)') AS [Name.Prefix]
,[Resume].ref.value(N'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume";
[...]
wikibot
Procedure HumanResources.uspUpdateEmployeePersonalInfo Description Updates the Employee table with the values specified in the input parameters for the given EmployeeID. Source
CREATE PROCEDURE [HumanResources].[uspUpdateEmployeePersonalInfo]
@EmployeeID [int],
@NationalIDNumber [nvarchar](15),
@BirthDate [datetime],
@MaritalStatus [nchar](1),
@Gender [nchar](1)
WITH EXECUTE AS CALLER
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
UPDATE [HumanResources].[Employee] [...]
wikibot
Table HumanResources.Department Description Lookup table containing the departments within the Adventure Works Cycles company. Columns Column Data Type Nullable Default Description DepartmentID smallint not null Primary key for Department records. Name dbo.Name not null Name of the department. GroupName dbo.Name not null Name of the group to which the department belongs. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_Department_DepartmentID DepartmentID [...]
wikibot
Table HumanResources.EmployeePayHistory Description Employee pay history. Columns Column Data Type Nullable Default Description EmployeeID int not null Employee identification number. Foreign key to Employee.EmployeeID. RateChangeDate datetime not null Date the change in pay is effective Rate money not null Salary hourly rate. PayFrequency tinyint not null 1 = Salary received monthly, 2 = Salary received biweekly ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns [...]
wikibot
XML Schema Collection HumanResources.HRResumeSchemaCollection Description Collection of XML schemas for the Resume column in the HumanResources.JobCandidate table. Source
[...]
wikibot
Table HumanResources.EmployeeAddress Description Cross-reference table mapping employees to their address(es). Columns Column Data Type Nullable Default Description EmployeeID int not null Primary key. Foreign key to Employee.EmployeeID. AddressID int not null Primary key. Foreign key to Address.AddressID. rowguid uniqueidentifier not null (newid()) ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary [...]
[...] ,s.[SalesQuota]
,s.[SalesYTD]
,s.[SalesLastYear]
FROM [Sales].[SalesPerson] s
INNER JOIN [HumanResources].[Employee] e
ON e.[EmployeeID] = s.[SalesPersonID]
LEFT OUTER JOIN [Sales].[SalesTerritory] st
ON st.[TerritoryID] = s.[TerritoryID]
INNER JOIN [Person].[Contact] c
ON c.[ContactID] = e.[ContactID]
INNER JOIN [HumanResources].[EmployeeAddress] ea
ON e.[EmployeeID] = ea.[EmployeeID]
INNER JOIN [Person].[Address] a
ON ea.[AddressID] = a.[AddressID]
INNER JOIN [Person].[StateProvince] sp
[...]
[...] Tables Detail Table Column Referencing Column Sales.ContactCreditCard ContactID ContactID HumanResources.Employee ContactID ContactID Sales.Individual ContactID ContactID Sales.SalesOrderHeader ContactID ContactID Sales.StoreContact ContactID ContactID Purchasing.VendorContact ContactID ContactID References Dependency Type Object Type Referenced Object Data Type Type dbo.Name Data Type Type dbo.NameStyle Data Type Type dbo.Phone Schema Schema Person Data Type XML Schema Collection Person.AdditionalContactInfoSchemaCollection [...]
[...] e.[EmployeeID], e.[ManagerID], c.[FirstName], c.[LastName], e.[Title], 0 -- Get the initial Employee
FROM [HumanResources].[Employee] e
INNER JOIN [Person].[Contact] c
ON e.[ContactID] = c.[ContactID]
WHERE e.[EmployeeID] = @EmployeeID
UNION ALL
SELECT e.[EmployeeID], e.[ManagerID], c.[FirstName], c.[LastName], e.[Title], [RecursionLevel] + 1 -- Join recursive member to anchor
FROM [HumanResources].[Employee] e
INNER JOIN [EMP_cte]
ON e.[EmployeeID] = [EMP_cte].[ManagerID]
INNER JOIN [Person].[Contact] [...]
[...] e.[ManagerID], c.[FirstName], c.[LastName], 0 -- Get the initial list of Employees for Manager n
FROM [HumanResources].[Employee] e
INNER JOIN [Person].[Contact] c
ON e.[ContactID] = c.[ContactID]
WHERE [ManagerID] = @ManagerID
UNION ALL
SELECT e.[EmployeeID], e.[ManagerID], c.[FirstName], c.[LastName], [RecursionLevel] + 1 -- Join recursive member to anchor
FROM [HumanResources].[Employee] e
INNER JOIN [EMP_cte]
ON e.[ManagerID] = [EMP_cte].[EmployeeID]
INNER JOIN [Person].[Contact] [...]
[...] @ContactID;
SET @JobTitle =
CASE
-- Check for employee
WHEN EXISTS(SELECT * FROM [HumanResources].[Employee] e
WHERE e.[ContactID] = @ContactID)
THEN (SELECT [Title]
FROM [HumanResources].[Employee]
WHERE [ContactID] = @ContactID)
-- Check for vendor
WHEN EXISTS(SELECT * FROM [Purchasing].[VendorContact] vc
INNER JOIN [Person].[ContactType] ct
ON vc.[ContactTypeID] = ct.[ContactTypeID]
WHERE vc.[ContactID] = @ContactID)
[...]
[...] Dependencies Reference Type Object Type Referencing Object Child Type Child Object Execute Procedure HumanResources.uspUpdateEmployeeHireInfo Execute Procedure HumanResources.uspUpdateEmployeeLogin [...]
[...] INNER JOIN [Sales].[SalesTerritory] st
ON sp.[TerritoryID] = st.[TerritoryID]
INNER JOIN [HumanResources].[Employee] e
ON soh.[SalesPersonID] = e.[EmployeeID]
INNER JOIN [Person].[Contact] c
ON e.[ContactID] = c.ContactID
) AS soh
PIVOT
(
SUM([SubTotal])
FOR [FiscalYear]
IN ([2002], [2003], [2004])
) AS pvt;
References Dependency Type Object Type Referenced Object Select Table HumanResources.Employee [...]
[...] nvarchar(100) NULL
Dependencies Reference Type Object Type Referencing Object Data Type Table HumanResources.Department Data Type Table HumanResources.Shift [...]
[...] Detail Tables Detail Table Column Referencing Column Sales.CustomerAddress AddressID AddressID HumanResources.EmployeeAddress AddressID AddressID Sales.SalesOrderHeader AddressID BillToAddressID Sales.SalesOrderHeader AddressID ShipToAddressID Purchasing.VendorAddress AddressID AddressID References Dependency Type Object Type Referenced Object Schema Schema Person Dependencies Reference Type Object Type Referencing Object Select View HumanResources.vEmployee [...]
[...] FROM bit NOT NULL
Dependencies Reference Type Object Type Referencing Object Data Type Table HumanResources.Employee Data Type Table Person.StateProvince [...]
[...] >=(0.00)) Check constraint TaxAmt >= (0.00) Foreign Keys Relation Column Referenced Column HumanResources.Employee EmployeeID EmployeeID Purchasing.ShipMethod [...]