HumanResources.EmployeeDepartmentHistory (table) - Revision history

Bot at 22:15, 23 June 2010

2010-06-23T22:15:53Z

Bot at 22:00, 23 June 2010

2010-06-23T22:00:04Z

Bot at 22:05, 2 February 2010

2010-02-02T22:05:59Z

Bot at 21:54, 28 December 2009

2009-12-28T21:54:33Z

Bot at 05:59, 30 November 2009

2009-11-30T05:59:18Z

Bot at 05:34, 30 November 2009

2009-11-30T05:34:40Z

Bot at 05:33, 30 November 2009

2009-11-30T05:33:31Z

Bot at 05:31, 30 November 2009

2009-11-30T05:31:58Z

Bot at 05:23, 30 November 2009

2009-11-30T05:23:55Z

Bot at 23:12, 26 November 2009

2009-11-26T23:12:48Z

@@ Line 128: / Line 128: @@
 | Schema
 | Schema
-| [[HumanResources_(_(schema))|HumanResources]]
+| [[HumanResources_(schema)|HumanResources]]
 |}
@@ Line 142: / Line 142: @@
 | 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]]
 |}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | HumanResources.EmployeeDepartmentHistory
@@ Line 8: / Line 8: @@
 | '''Description
 | Employee department transfers.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | EmployeeID
@@ Line 64: / Line 62: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
 | EmployeeID, DepartmentID, ShiftID, StartDate
@@ Line 75: / Line 73: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | IX_EmployeeDepartmentHistory_DepartmentID
+|
 | DepartmentID
-|-
+|- valign="top"
 | IX_EmployeeDepartmentHistory_ShiftID
+|
@@ Line 92: / Line 90: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_EmployeeDepartmentHistory_EndDate
 | ([EndDate]>=[StartDate] OR [EndDate] IS NULL)
@@ Line 105: / Line 103: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[HumanResources.Department_(table)|HumanResources.Department]]
 | DepartmentID
 | DepartmentID
-|-
+|- valign="top"
 | [[HumanResources.Employee_(table)|HumanResources.Employee]]
 | EmployeeID
 | EmployeeID
-|-
+|- valign="top"
 | [[HumanResources.Shift_(table)|HumanResources.Shift]]
 | ShiftID
@@ Line 127: / Line 125: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema
-| [[HumanResources_(schema)|HumanResources]]
+| [[HumanResources_(_(schema))|HumanResources]]
 |}
@@ Line 141: / Line 139: @@
 | '''Referencing Object
-|-
+|- 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]]
 |}

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Employee identification number. Foreign key to Employee.EmployeeID.<br />PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
+| Employee identification number. Foreign key to Employee.EmployeeID.
 |- valign="top"
 | DepartmentID
@@ Line 31: / Line 32: @@
 | not null
+|
-| Department in which the employee worked including currently. Foreign key to Department.DepartmentID.<br />PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentIDIX_EmployeeDepartmentHistory_DepartmentID
+| Department in which the employee worked including currently. Foreign key to Department.DepartmentID.
 |- valign="top"
 | ShiftID
@@ Line 37: / Line 38: @@
 | not null
+|
-| Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.<br />PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentIDIX_EmployeeDepartmentHistory_ShiftID
+| Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.
 |- valign="top"
 | StartDate
@@ Line 43: / Line 44: @@
 | not null
+|
-| Date the employee started work in the department.<br />PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
+| Date the employee started work in the department.
 |- valign="top"
 | EndDate
@@ Line 49: / Line 50: @@
 | null
+|
-| Date the employee left the department. NULL = Current department.<br />
+| Date the employee left the department. NULL = Current department.
 |- valign="top"
 | ModifiedDate
@@ Line 55: / Line 56: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 80: / Line 120: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 98: / Line 152: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | HumanResources.EmployeeDepartmentHistory
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | EmployeeID
 | int
 | not null
+|
-| PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
+| Employee identification number. Foreign key to Employee.EmployeeID.<br />PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
+|- valign="top"
 | DepartmentID
 | smallint
 | not null
+|
-| PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
+| Department in which the employee worked including currently. Foreign key to Department.DepartmentID.<br />PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentIDIX_EmployeeDepartmentHistory_DepartmentID
-| IX_EmployeeDepartmentHistory_DepartmentID
+|- valign="top"
 | ShiftID
 | tinyint
 | not null
+|
-| PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
+| Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.<br />PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentIDIX_EmployeeDepartmentHistory_ShiftID
-| IX_EmployeeDepartmentHistory_ShiftID
+|- valign="top"
 | StartDate
 | datetime
 | not null
+|
-| PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
+| Date the employee started work in the department.<br />PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
+|- valign="top"
 | EndDate
 | datetime
 | null
+|
+| Date the employee left the department. NULL = Current department.<br />
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 83: / Line 79: @@
 | ShiftID
 |}
 == automatically generated ==

@@ Line 90: / Line 90: @@
 | HumanResources.EmployeeDepartmentHistory
 |- valign="top"
 | '''Description
 | Employee department transfers.
 |-
 |}

@@ Line 164: / Line 164: @@
 | ShiftID
 | ShiftID
 |}
@@ Line 172: / Line 185: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]