Table: dbo.Payroll_Item_Worker_Compensation_Exemption_Detail
Columns
Name | Type | Constraints | Description
payroll_item_worker_compensation_exemption_detail_KEY | int (4) | NOT NULL | unique key
payroll_item_worker_compensation_exemption_KEY | int (4) | NOT NULL | client payroll item exemption record this relates to
ste_state_code_KEY | nvarchar (4) | NOT NULL | State that this payroll item is exempt from for worker compensation calculations

Primary key
Name | Columns | Description
PK_Payroll_Item_Worker_Compensation_Exemption_Detail | payroll_item_worker_compensation_exemption_detail_KEY |
Unique constraints
Name | Columns | Description
UK_Payroll_Item_Worker_Compensation_Exemption_Detail$payroll_item_worker_compensation_exemption_KEY$ste_state_code_KEY | payroll_item_worker_compensation_exemption_KEY, ste_state_code_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Item_Worker_Compensation_Exemption_Detail__Payroll_Item_Worker_Compensation_Exemption__payroll_item_worker_compensati | payroll_item_worker_compensation_exemption_KEY | Payroll_Item_Worker_Compensation_Exemption (payroll_item_worker_compensation_exemption_KEY) |
FK_Payroll_Item_Worker_Compensation_Exemption_Detail__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |