Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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