| Table: dbo.Worker_Compensation_Rate | |||
| Columns | |||
| Name | Type | Constraints | Description |
| worker_compensation_rate_KEY | int (4) | NOT NULL | |
| worker_compensation_KEY | int (4) | NOT NULL | Link to a worker comp code/state |
| effective_date | smalldatetime (4) | NOT NULL | When this rate takes affect for this state's worker comp class code |
| gross_worker_compensation_rate | decimal (5, 5) | NOT NULL | worker comp rate or percent before any adjustment |
| experience_modification_percent | decimal (5, 5) | NOT NULL | percent to reduce the gross worker comp rate by for this client |
| payroll_deduction_rate | decimal (5, 5) | NOT NULL | employee deduction rate or percent |
| Primary key | |||
| Name | Columns | Description | |
| PK_Worker_Compensation_Rate | worker_compensation_rate_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Worker_Compensation_Rate$worker_compensation_KEY$effective_date | worker_compensation_KEY, effective_date | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Worker_Compensation_Rate__Worker_Compensation__worker_compensation_KEY | worker_compensation_KEY | Worker_Compensation (worker_compensation_KEY) | |