HumanResources.Employee (table) - Revision history

Bot at 22:15, 23 June 2010

2010-06-23T22:15:50Z

Bot at 22:00, 23 June 2010

2010-06-23T22:00:02Z

Show changes

Bot at 22:06, 2 February 2010

2010-02-02T22:06:31Z

Show changes

Bot at 21:54, 28 December 2009

2009-12-28T21:54:29Z

Show changes

Bot at 05:59, 30 November 2009

2009-11-30T05:59:14Z

Bot at 05:34, 30 November 2009

2009-11-30T05:34:36Z

Bot at 05:33, 30 November 2009

2009-11-30T05:33:28Z

Bot at 05:31, 30 November 2009

2009-11-30T05:31:55Z

Bot at 05:23, 30 November 2009

2009-11-30T05:23:52Z

Bot at 23:12, 26 November 2009

2009-11-26T23:12:45Z

@@ Line 288: / Line 288: @@
 | Data Type
 | Type
-| [[dbo.Flag_(_(type))|dbo.Flag]]
+| [[dbo.Flag_(type)|dbo.Flag]]
 |- valign="top"
 | Schema
 | Schema
-| [[HumanResources_(_(schema))|HumanResources]]
+| [[HumanResources_(schema)|HumanResources]]
 |}
@@ Line 307: / Line 307: @@
 | Select
 | View
-| [[HumanResources.vEmployee_(_(view))|HumanResources.vEmployee]]
+| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
 |- valign="top"
 | Select
 | View
-| [[HumanResources.vEmployeeDepartment_(_(view))|HumanResources.vEmployeeDepartment]]
+| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
 |- valign="top"
 | Select
 | View
-| [[HumanResources.vEmployeeDepartmentHistory_(_(view))|HumanResources.vEmployeeDepartmentHistory]]
+| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
 |- valign="top"
 | Select
 | View
-| [[Sales.vSalesPerson_(_(view))|Sales.vSalesPerson]]
+| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
 |- valign="top"
 | Select
 | View
-| [[Sales.vSalesPersonSalesByFiscalYears_(_(view))|Sales.vSalesPersonSalesByFiscalYears]]
+| [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]]
 |- valign="top"
 | Select
 | Procedure
-| [[dbo.uspGetEmployeeManagers_(_(procedure))|dbo.uspGetEmployeeManagers]]
+| [[dbo.uspGetEmployeeManagers_(procedure)|dbo.uspGetEmployeeManagers]]
 |- valign="top"
 | Select
 | Procedure
-| [[dbo.uspGetManagerEmployees_(_(procedure))|dbo.uspGetManagerEmployees]]
+| [[dbo.uspGetManagerEmployees_(procedure)|dbo.uspGetManagerEmployees]]
 |- valign="top"
 | Update
 | Procedure
-| [[HumanResources.uspUpdateEmployeeHireInfo_(_(procedure))|HumanResources.uspUpdateEmployeeHireInfo]]
+| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]]
 |- valign="top"
 | Update
 | Procedure
-| [[HumanResources.uspUpdateEmployeeLogin_(_(procedure))|HumanResources.uspUpdateEmployeeLogin]]
+| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]]
 |- valign="top"
 | Update
 | Procedure
-| [[HumanResources.uspUpdateEmployeePersonalInfo_(_(procedure))|HumanResources.uspUpdateEmployeePersonalInfo]]
+| [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]]
 |- valign="top"
 | Select
 | SQL table-valued-function
-| [[dbo.ufnGetContactInformation_(_(function))|dbo.ufnGetContactInformation]]
+| [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]
 |}

@@ Line 204: / Line 204: @@
 | HumanResources.Employee
 |- valign="top"
 | '''Description
 | Employee information such as salary, department, and title.
 |-
 |}

@@ Line 394: / Line 394: @@
 | Data Type
 | Type
-| [[dbo.Flag_(type)|true.Flag]]
+| [[dbo.Flag_(type)|dbo.Flag]]
 |-
 | Schema
 | Schema
-| [[HumanResources_(schema)|false.HumanResources]]
+| [[HumanResources_(schema)|HumanResources]]
 |}
@@ Line 413: / Line 413: @@
 | Select
 | View
-| [[HumanResources.vEmployee_(view)|true.vEmployee]]
+| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
 |-
 | Select
 | View
-| [[HumanResources.vEmployeeDepartment_(view)|true.vEmployeeDepartment]]
+| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
 |-
 | Select
 | View
-| [[HumanResources.vEmployeeDepartmentHistory_(view)|true.vEmployeeDepartmentHistory]]
+| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
 |-
 | Select
 | View
-| [[Sales.vSalesPerson_(view)|true.vSalesPerson]]
+| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
 |-
 | Select
 | View
-| [[Sales.vSalesPersonSalesByFiscalYears_(view)|true.vSalesPersonSalesByFiscalYears]]
+| [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]]
 |-
 | Select
 | Procedure
-| [[dbo.uspGetEmployeeManagers_(procedure)|true.uspGetEmployeeManagers]]
+| [[dbo.uspGetEmployeeManagers_(procedure)|dbo.uspGetEmployeeManagers]]
 |-
 | Select
 | Procedure
-| [[dbo.uspGetManagerEmployees_(procedure)|true.uspGetManagerEmployees]]
+| [[dbo.uspGetManagerEmployees_(procedure)|dbo.uspGetManagerEmployees]]
 |-
 | Update
 | Procedure
-| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|true.uspUpdateEmployeeHireInfo]]
+| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]]
 |-
 | Update
 | Procedure
-| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|true.uspUpdateEmployeeLogin]]
+| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]]
 |-
 | Update
 | Procedure
-| [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|true.uspUpdateEmployeePersonalInfo]]
+| [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]]
 |-
 | Select
 | SQL table-valued-function
-| [[dbo.ufnGetContactInformation_(function)|true.ufnGetContactInformation]]
+| [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]
 |}

@@ Line 394: / Line 394: @@
 | Data Type
 | Type
-| [[dbo.Flag_(type)|dbo.Flag]]
+| [[dbo.Flag_(type)|true.Flag]]
 |-
 | Schema
 | Schema
-| [[HumanResources_(schema)|.HumanResources]]
+| [[HumanResources_(schema)|false.HumanResources]]
 |}
@@ Line 413: / Line 413: @@
 | Select
 | View
-| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
+| [[HumanResources.vEmployee_(view)|true.vEmployee]]
 |-
 | Select
 | View
-| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
+| [[HumanResources.vEmployeeDepartment_(view)|true.vEmployeeDepartment]]
 |-
 | Select
 | View
-| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
+| [[HumanResources.vEmployeeDepartmentHistory_(view)|true.vEmployeeDepartmentHistory]]
 |-
 | Select
 | View
-| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
+| [[Sales.vSalesPerson_(view)|true.vSalesPerson]]
 |-
 | Select
 | View
-| [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]]
+| [[Sales.vSalesPersonSalesByFiscalYears_(view)|true.vSalesPersonSalesByFiscalYears]]
 |-
 | Select
 | Procedure
-| [[dbo.uspGetEmployeeManagers_(procedure)|dbo.uspGetEmployeeManagers]]
+| [[dbo.uspGetEmployeeManagers_(procedure)|true.uspGetEmployeeManagers]]
 |-
 | Select
 | Procedure
-| [[dbo.uspGetManagerEmployees_(procedure)|dbo.uspGetManagerEmployees]]
+| [[dbo.uspGetManagerEmployees_(procedure)|true.uspGetManagerEmployees]]
 |-
 | Update
 | Procedure
-| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]]
+| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|true.uspUpdateEmployeeHireInfo]]
 |-
 | Update
 | Procedure
-| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]]
+| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|true.uspUpdateEmployeeLogin]]
 |-
 | Update
 | Procedure
-| [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]]
+| [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|true.uspUpdateEmployeePersonalInfo]]
 |-
 | Select
 | SQL table-valued-function
-| [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]
+| [[dbo.ufnGetContactInformation_(function)|true.ufnGetContactInformation]]
 |}

@@ Line 387: / Line 387: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | [[dbo.Flag_(type)|dbo.Flag]]
-| Type
 |-
 | Schema
 | Schema
 |}
@@ Line 404: / Line 406: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referencing Object
 |-
 | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
 | View
 | Select
 |-
-| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
+| Select
 | View
 | Select
 | View
-| Select
+| [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]]
 |-
 | Select
 |-
 | Select
 |-
-| [[dbo.uspGetEmployeeManagers_(procedure)|dbo.uspGetEmployeeManagers]]
+| Update
 | Procedure
-| Select
+| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]]
 |-
-| [[dbo.uspGetManagerEmployees_(procedure)|dbo.uspGetManagerEmployees]]
+| Update
 | Procedure
-| Select
+| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]]
 |-
 | Update
 | Procedure
 | [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]]
-| Procedure
 |-
 | [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]
-| SQL table-valued-function
 |}

@@ Line 390: / Line 390: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[dbo.Flag_(type)|dbo.Flag]]
 | Type
 | Data Type
 |}
@@ Line 403: / Line 407: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]