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 |