Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: HumanResources EmployeePayHistory (table)

Compare Page Revisions



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


Page Revision: 2010/01/09 18:02


wikibot

TableHumanResources.EmployeePayHistory
DescriptionEmployee pay history.

ColumnData TypeNullableDefaultDescription / PK / Index
EmployeeIDintnot null Employee identification number. Foreign key to Employee.EmployeeID.
PK_EmployeePayHistory_EmployeeID_RateChangeDate
RateChangeDatedatetimenot null Date the change in pay is effective
PK_EmployeePayHistory_EmployeeID_RateChangeDate
Ratemoneynot null Salary hourly rate.
PayFrequencytinyintnot null 1 = Salary received monthly, 2 = Salary received biweekly
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



RelationColumnReferenced Column
HumanResources.EmployeeEmployeeIDEmployeeID

Reference TypeObject TypeReferencing Object
InsertProcedureHumanResources.uspUpdateEmployeeHireInfo

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