Table: dbo.Worker_Compensation_Limit_Detail
Columns
Name | Type | Constraints | Description
worker_compensation_limit_detail_KEY | int (4) | NOT NULL | unique ky
begin_date | smalldatetime (4) | NOT NULL | Date this limit takes effect
expiration_date | smalldatetime (4) | NOT NULL | date this limit expires
is_a_per_check_limit | bit (1) | NOT NULL | T/F: Is this a per check limit
is_for_officers | bit (1) | NOT NULL | T/F: Is this limit only for officers. If false then it means it is for non-officers
employer_minimum_limit | decimal (9, 2) | NOT NULL | employer minimum limit
employer_maximum_limit | decimal (9, 2) | NOT NULL | employer maximum limit

Primary key
Name | Columns | Description
PK_Worker_Compensation_Limit_Detail | worker_compensation_limit_detail_KEY |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Worker_Compensation_Limit__Worker_Compensation_Limit_Detail__worker_compensation_limit_detail_KEY | worker_compensation_limit_detail_KEY | Worker_Compensation_Limit |