ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
HumanResources.vEmployeeDepartmentHistory_(view)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''View''' | HumanResources.vEmployeeDepartmentHistory |- valign="top" | '''Description''' | Returns employee name and current and previous departments. |} === Source === {{{{<nowiki> 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 ON c.[ContactID] = e.[ContactID] INNER JOIN [HumanResources].[EmployeeDepartmentHistory] edh ON e.[EmployeeID] = edh.[EmployeeID] INNER JOIN [HumanResources].[Department] d ON edh.[DepartmentID] = d.[DepartmentID] INNER JOIN [HumanResources].[Shift] s ON s.[ShiftID] = edh.[ShiftID]; </nowiki>}}}} === References === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- valign="top" | Select | Table | [[HumanResources.Department_(table)|HumanResources.Department]] |- valign="top" | Select | Table | [[HumanResources.Employee_(table)|HumanResources.Employee]] |- valign="top" | Select | Table | [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]] |- valign="top" | Select | Table | [[HumanResources.Shift_(table)|HumanResources.Shift]] |- valign="top" | Select | Table | [[Person.Contact_(table)|Person.Contact]] |- valign="top" | Schema | Schema | [[HumanResources_(schema)|HumanResources]] |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''view''' | HumanResources.vEmployeeDepartmentHistory |- valign="top" | '''Description''' | Returns employee name and current and previous departments. |- |} {{{{<nowiki> 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 ON c.[ContactID] = e.[ContactID] INNER JOIN [HumanResources].[EmployeeDepartmentHistory] edh ON e.[EmployeeID] = edh.[EmployeeID] INNER JOIN [HumanResources].[Department] d ON edh.[DepartmentID] = d.[DepartmentID] INNER JOIN [HumanResources].[Shift] s ON s.[ShiftID] = edh.[ShiftID]; </nowiki>}}}} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- | Select | Table | [[HumanResources.Department_(table)|HumanResources.Department]] |- | Select | Table | [[HumanResources.Employee_(table)|HumanResources.Employee]] |- | Select | Table | [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]] |- | Select | Table | [[HumanResources.Shift_(table)|HumanResources.Shift]] |- | Select | Table | [[Person.Contact_(table)|Person.Contact]] |- | Schema | Schema | [[HumanResources_(schema)|HumanResources]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.