EmployeePayHistory Table (AdventureWorks)
Contains current and historical salary information for employees.
The EmployeePayHistory table is contained in the HumanResources schema.
Employee identification number. Foreign key to Employee.EmployeeID.
Date the change in pay is effective.
Hourly rate of pay.
1 = Salary received monthly
2 = Salary received biweekly
Date and time the row was last updated.