EmployeePayHistory Table (AdventureWorks)

Contains current and historical salary information for employees.

EmployeePayHistory Table Definition

The EmployeePayHistory table is contained in the HumanResources schema.

Column	Data type	Nullability	Description
EmployeeID	int	Not null	Employee identification number. Foreign key to Employee.EmployeeID.
RateChangeDate	datetime	Not null	Date the change in pay is effective.
Rate	money	Not null	Hourly rate of pay.
PayFrequency	tinyint	Not null	1 = Salary received monthly 2 = Salary received biweekly
ModifiedDate	datetime	Not null	Date and time the row was last updated.

See Also

Reference

Department Table (AdventureWorks)

Employee Table (AdventureWorks)

EmployeeDepartmentHistory Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary