Table: dbo.Worker_Compensation_Limit_Detail
Columns
NameTypeConstraintsDescription
worker_compensation_limit_detail_KEYint (4)NOT NULLunique ky
begin_datesmalldatetime (4)NOT NULLDate this limit takes effect
expiration_datesmalldatetime (4)NOT NULLdate this limit expires
is_a_per_check_limitbit (1)NOT NULLT/F: Is this a per check limit
is_for_officersbit (1)NOT NULLT/F: Is this limit only for officers. If false then it means it is for non-officers
employer_minimum_limitdecimal (9, 2)NOT NULLemployer minimum limit
employer_maximum_limitdecimal (9, 2)NOT NULLemployer maximum limit
Primary key
NameColumnsDescription
PK_Worker_Compensation_Limit_Detailworker_compensation_limit_detail_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Worker_Compensation_Limit__Worker_Compensation_Limit_Detail__worker_compensation_limit_detail_KEYworker_compensation_limit_detail_KEYWorker_Compensation_Limit

Schema diagram