Table: dbo.Worker_Compensation_Rate
Columns
NameTypeConstraintsDescription
worker_compensation_rate_KEYint (4)NOT NULL
worker_compensation_KEYint (4)NOT NULLLink to a worker comp code/state
effective_datesmalldatetime (4)NOT NULLWhen this rate takes affect for this state's worker comp class code
gross_worker_compensation_ratedecimal (5, 5)NOT NULLworker comp rate or percent before any adjustment
experience_modification_percentdecimal (5, 5)NOT NULLpercent to reduce the gross worker comp rate by for this client
payroll_deduction_ratedecimal (5, 5)NOT NULLemployee deduction rate or percent
Primary key
NameColumnsDescription
PK_Worker_Compensation_Rateworker_compensation_rate_KEY
Unique constraints
NameColumnsDescription
UK_Worker_Compensation_Rate$worker_compensation_KEY$effective_dateworker_compensation_KEY, effective_date
Foreign keys
NameColumnsReferenced tableDescription
FK_Worker_Compensation_Rate__Worker_Compensation__worker_compensation_KEYworker_compensation_KEYWorker_Compensation (worker_compensation_KEY)

Schema diagram