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