Generated using SQL Data Dictionary demo version.

Table HumanResources.EmployeePayHistory (316 rows)

Employee pay history.

  Column Data Type Identity Nullable Default
PK, FK BusinessEntityID int
Employee identification number. Foreign key to Employee.BusinessEntityID.
PK RateChangeDate datetime
Date the change in pay is effective
Rate money
Salary hourly rate.
PayFrequency tinyint
1 = Salary received monthly, 2 = Salary received biweekly
ModifiedDate datetime getdate()
Date and time the record was last updated.



Used by: