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 |