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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Bank_Transaction_Worker_Compensation_Item__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payroll_Bank_Transaction (bank_transaction_KEY) |
FK_Payroll_Bank_Transaction_Worker_Compensation_Item__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |
FK_Payroll_Bank_Transaction_Worker_Compensation_Item__Worker_Compensation__worker_compensation_KEY | worker_compensation_KEY | Worker_Compensation (worker_compensation_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__Payroll_Bank_Transaction_Worker_Compensation_Item__payroll_ba | payroll_bank_transaction_worker_compensation_item_KEY | Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution |
FK_Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item__Payroll_Bank_Transaction_Worker_Compensation_Item__p | payroll_bank_transaction_worker_compensation_item_KEY | Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item |