| Table: dbo.Payroll_Bank_Transaction_Worker_Compensation_Item | |||
| Columns | |||
| Name | Type | Constraints | Description |
| payroll_bank_transaction_worker_compensation_item_KEY | int (4) | NOT NULL | unique key |
| bank_transaction_KEY | int (4) | NOT NULL | payroll check this relates to |
| worker_compensation_KEY | int (4) | NOT NULL | client worker compensation info this is for |
| vendor_KEY | int (4) | vendor agent for creation of a vendor liability at check printing time | |
| is_exempt_from_worker_compensation | bit (1) | NOT NULL | T/F: Is this employee exempt from worker compensation for this state/worker comp class code |
| Primary key | |||
| Name | Columns | Description | |
| PK_Payroll_Bank_Transaction_Worker_Compensation_Item | payroll_bank_transaction_worker_compensation_item_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Payroll_Bank_Transaction_Worker_Compensation_Item$bank_transaction_KEY$worker_compensation_KEY | bank_transaction_KEY, worker_compensation_KEY | ||