Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Search Engine

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.



Filter by Category


This search, performed through 2.14 MB (338 documents, 3448 words), completed in 0.1 seconds and yielded 30 results.

HumanResources (schema) — 9.5%

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 [...]

HumanResources Employee (table) — 8.2%

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. [...]

Database Objects AdventureWorks — 8.2%

[...] (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) [...]

HumanResources vEmployeeDepartmentHistory (view) — 5.9%

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 [...]

HumanResources vEmployeeDepartment (view) — 5.0%

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] [...]

HumanResources EmployeeDepartmentHistory (table) — 4.1%

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 [...]

HumanResources vEmployee (view) — 4.1%

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] [...]

HumanResources uspUpdateEmployeeHireInfo (procedure) — 4.1%

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 [...]

HumanResources JobCandidate (table) — 4.1%

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 [...]

HumanResources vJobCandidateEducation (view) — 3.6%

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 [...]

HumanResources vJobCandidateEmployment (view) — 3.6%

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 [...]

HumanResources uspUpdateEmployeeLogin (procedure) — 3.2%

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] [...]

HumanResources Shift (table) — 3.2%

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 [...]

HumanResources vJobCandidate (view) — 3.2%

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"; [...]

HumanResources uspUpdateEmployeePersonalInfo (procedure) — 3.2%

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] [...]

HumanResources Department (table) — 3.2%

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 [...]

HumanResources EmployeePayHistory (table) — 2.7%

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 [...]

HumanResources HRResumeSchemaCollection (xml schema collection) — 2.7%

wikibot XML Schema Collection HumanResources.HRResumeSchemaCollection Description Collection of XML schemas for the Resume column in the HumanResources.JobCandidate table. Source [...]

HumanResources EmployeeAddress (table) — 2.7%

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 [...]

Sales vSalesPerson (view) — 1.8%

[...] ,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 [...]

Person Contact (table) — 1.8%

[...] 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 [...]

dbo uspGetEmployeeManagers (procedure) — 1.8%

[...] 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] [...]

dbo uspGetManagerEmployees (procedure) — 1.8%

[...] 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] [...]

dbo ufnGetContactInformation (function) — 1.8%

[...] @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) [...]

dbo uspLogError (procedure) — 1.4%

[...] Dependencies Reference Type Object Type Referencing Object Child Type Child Object Execute Procedure HumanResources.uspUpdateEmployeeHireInfo Execute Procedure HumanResources.uspUpdateEmployeeLogin [...]

Sales vSalesPersonSalesByFiscalYears (view) — 0.9%

[...] 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 [...]

dbo Name (type) — 0.9%

[...] nvarchar(100) NULL Dependencies Reference Type Object Type Referencing Object Data Type Table HumanResources.Department Data Type Table HumanResources.Shift [...]

Person Address (table) — 0.9%

[...] 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 [...]

dbo Flag (type) — 0.5%

[...] FROM bit NOT NULL Dependencies Reference Type Object Type Referencing Object Data Type Table HumanResources.Employee Data Type Table Person.StateProvince [...]

Purchasing PurchaseOrderHeader (table) — 0.5%

[...] >=(0.00)) Check constraint TaxAmt >= (0.00) Foreign Keys Relation Column Referenced Column HumanResources.Employee EmployeeID EmployeeID Purchasing.ShipMethod [...]

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.