Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: HumanResources EmployeeDepartmentHistory (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 17:03


wikibot

TableHumanResources.EmployeeDepartmentHistory
DescriptionEmployee department transfers.

ColumnData TypeNullableDefaultDescription / PK / Index
EmployeeIDintnot null Employee identification number. Foreign key to Employee.EmployeeID.
PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
DepartmentIDsmallintnot null Department in which the employee worked including currently. Foreign key to Department.DepartmentID.
PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentIDIX_EmployeeDepartmentHistory_DepartmentID
ShiftIDtinyintnot null Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.
PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentIDIX_EmployeeDepartmentHistory_ShiftID
StartDatedatetimenot null Date the employee started work in the department.
PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID
EndDatedatetimenull Date the employee left the department. NULL = Current department.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
HumanResources.DepartmentDepartmentIDDepartmentID
HumanResources.EmployeeEmployeeIDEmployeeID
HumanResources.ShiftShiftIDShiftID

Reference TypeObject TypeReferencing Object
SelectViewHumanResources.vEmployeeDepartment
SelectViewHumanResources.vEmployeeDepartmentHistory

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