Table: dbo.Payroll_Bank_Transaction_Worker_Compensation_Item
Columns
NameTypeConstraintsDescription
payroll_bank_transaction_worker_compensation_item_KEYint (4)NOT NULLunique key
bank_transaction_KEYint (4)NOT NULLpayroll check this relates to
worker_compensation_KEYint (4)NOT NULLclient worker compensation info this is for
vendor_KEYint (4)vendor agent for creation of a vendor liability at check printing time
is_exempt_from_worker_compensationbit (1)NOT NULLT/F: Is this employee exempt from worker compensation for this state/worker comp class code
Primary key
NameColumnsDescription
PK_Payroll_Bank_Transaction_Worker_Compensation_Itempayroll_bank_transaction_worker_compensation_item_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Bank_Transaction_Worker_Compensation_Item$bank_transaction_KEY$worker_compensation_KEYbank_transaction_KEY, worker_compensation_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Bank_Transaction_Worker_Compensation_Item__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYPayroll_Bank_Transaction (bank_transaction_KEY)
FK_Payroll_Bank_Transaction_Worker_Compensation_Item__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
FK_Payroll_Bank_Transaction_Worker_Compensation_Item__Worker_Compensation__worker_compensation_KEYworker_compensation_KEYWorker_Compensation (worker_compensation_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__Payroll_Bank_Transaction_Worker_Compensation_Item__payroll_bapayroll_bank_transaction_worker_compensation_item_KEYPayroll_Bank_Transaction_Worker_Compensation_Item_Distribution
FK_Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item__Payroll_Bank_Transaction_Worker_Compensation_Item__ppayroll_bank_transaction_worker_compensation_item_KEYPayable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item

Schema diagram