HumanResources.Shift (table) - Revision history

Bot at 08:54, 27 August 2011

2011-08-27T08:54:44Z

Bot at 22:18, 23 June 2010

2010-06-23T22:18:22Z

Bot at 22:15, 23 June 2010

2010-06-23T22:15:59Z

Bot at 22:00, 23 June 2010

2010-06-23T22:00:10Z

Bot at 22:07, 2 February 2010

2010-02-02T22:07:09Z

Bot at 22:28, 28 December 2009

2009-12-28T22:28:01Z

Bot at 22:25, 28 December 2009

2009-12-28T22:25:54Z

Bot at 22:13, 28 December 2009

2009-12-28T22:13:14Z

Show changes

Bot at 21:57, 28 December 2009

2009-12-28T21:57:54Z

Show changes

Bot at 21:55, 28 December 2009

2009-12-28T21:55:29Z

← Older revision		Revision as of 08:54, 27 August 2011
Line 123:		Line 123:

	\|}		\|}
		+
		+
	== wikivalues ==		== wikivalues ==

@@ Line 123: / Line 123: @@
 |}
 == wikivalues ==
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table Values
 | HumanResources.Shift
 |}
 | '''ShiftID
 | '''Name
 | '''StartTime
 | '''EndTime
-|-
+|- valign="top"
 |	1
-|	Day
+| 1
-|	1900-01-01 07:00:00.000
+| Day
-|	1900-01-01 15:00:00.000
+| 1900-01-01 07:00:00.000
-|-
+| 1900-01-01 15:00:00.000
-|	2
+|- valign="top"
 |	Evening
-|	1900-01-01 15:00:00.000
+| 2
-|	1900-01-01 23:00:00.000
+| Evening
-|-
+| 1900-01-01 15:00:00.000
-|	3
+| 1900-01-01 23:00:00.000
-|	Night
+|- valign="top"
 |	1900-01-01 23:00:00.000
-|	1900-01-01 07:00:00.000
+| 3
 |}

@@ Line 101: / Line 101: @@
 | Data Type
 | Type
-| [[dbo.Name_(_(type))|dbo.Name]]
+| [[dbo.Name_(type)|dbo.Name]]
 |- valign="top"
 | Schema
 | Schema
-| [[HumanResources_(_(schema))|HumanResources]]
+| [[HumanResources_(schema)|HumanResources]]
 |}
@@ Line 120: / Line 120: @@
 | 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.Shift
@@ Line 8: / Line 8: @@
 | '''Description
 | Work shift lookup table.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | ShiftID
@@ Line 58: / Line 56: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_Shift_ShiftID
 | ShiftID
@@ Line 69: / Line 67: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_Shift_Name
 | Unique
 | Name
-|-
+|- valign="top"
 | AK_Shift_StartTime_EndTime
 | Unique
@@ Line 86: / Line 84: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]]
 | ShiftID
@@ Line 100: / Line 98: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Data Type
 | Type
-| [[dbo.Name_(type)|dbo.Name]]
+| [[dbo.Name_(_(type))|dbo.Name]]
-|-
+|- valign="top"
 | Schema
 | Schema
-| [[HumanResources_(schema)|HumanResources]]
+| [[HumanResources_(_(schema))|HumanResources]]
 |}
@@ Line 119: / Line 117: @@
 | '''Referencing Object
-|-
+|- 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
+|
-| Primary key for Shift records.<br />PK_Shift_ShiftID
+| Primary key for Shift records.
 |- valign="top"
 | Name
@@ Line 31: / Line 32: @@
 | not null
+|
-| Shift description.<br />AK_Shift_Name
+| Shift description.
 |- valign="top"
 | StartTime
@@ Line 37: / Line 38: @@
 | not null
+|
-| Shift start time.<br />AK_Shift_StartTime_EndTime
+| Shift start time.
 |- valign="top"
 | EndTime
@@ Line 43: / Line 44: @@
 | not null
+|
-| Shift end time.<br />AK_Shift_StartTime_EndTime
+| Shift end time.
 |- valign="top"
 | ModifiedDate
@@ Line 49: / Line 50: @@
 | 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 66: / Line 93: @@
 |}
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 77: / Line 104: @@
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
 |}
+=== Dependencies ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 93: / Line 125: @@
 |}
 == wikivalues ==

← Older revision		Revision as of 22:28, 28 December 2009
Line 93:		Line 93:

	\|}		\|}
−
−
−
	== wikivalues ==		== wikivalues ==

← Older revision		Revision as of 22:25, 28 December 2009
Line 93:		Line 93:

	\|}		\|}
		+
		+
		+
	== wikivalues ==		== wikivalues ==