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) |