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