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