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