HumanResources.EmployeePayHistory (table)
wikibot
| Table | HumanResources.EmployeePayHistory |
| Column | Data Type | Nullable | Default | PK | Index |
| EmployeeID | int | not null | PK_EmployeePayHistory_EmployeeID_RateChangeDate | ||
| RateChangeDate | datetime | not null | PK_EmployeePayHistory_EmployeeID_RateChangeDate | ||
| Rate | money | not null | |||
| PayFrequency | tinyint | not null | |||
| ModifiedDate | datetime | not null | (getdate()) |
| Relation | Column | Referenced Column |
| HumanResources.Employee | EmployeeID | EmployeeID |
