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 |