Generated using SQL Data Dictionary demo version.
Employee pay history.
| Column | Data Type | Identity | Nullable | Default | |
|---|---|---|---|---|---|
| PK, FK | BusinessEntityID | int | |||
| Employee identification number. Foreign key to Employee.BusinessEntityID. | |||||
| PK | RateChangeDate | datetime | |||
| Date the change in pay is effective | |||||
| Rate | money | ||||
| Salary hourly rate. | |||||
| PayFrequency | tinyint | ||||
| 1 = Salary received monthly, 2 = Salary received biweekly | |||||
| ModifiedDate | datetime | getdate() | |||
| Date and time the record was last updated. | |||||
Primary key (clustered) constraint