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