Table: dbo.Benefit_Item_Worker_Compensation_Exemption_Detail
Columns
Name | Type | Constraints | Description
benefit_item_worker_compensation_exemption_detail_KEY | int (4) | NOT NULL | unique key
benefit_item_worker_compensation_exemption_KEY | int (4) | NOT NULL | particular benefit item this detail is for
ste_state_code_KEY | nvarchar (4) | NOT NULL | state this benefit item is exempt from worker compensation calculation

Primary key
Name | Columns | Description
PK_Benefit_Item_Worker_Compensation_Exemption_Detail | benefit_item_worker_compensation_exemption_detail_KEY |
Unique constraints
Name | Columns | Description
UK_Benefit_Item_Worker_Compensation_Exemption_Detail$benefit_item_worker_compensation_exemption_KEY$ste_state_code_KEY | benefit_item_worker_compensation_exemption_KEY, ste_state_code_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Benefit_Item_Worker_Compensation_Exemption_Detail__Benefit_Item_Worker_Compensation_Exemption__benefit_item_worker_compensati | benefit_item_worker_compensation_exemption_KEY | Benefit_Item_Worker_Compensation_Exemption (benefit_item_worker_compensation_exemption_KEY) |
FK_Benefit_Item_Worker_Compensation_Exemption_Detail__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |