View: dbo.Payable_Transaction_N_Payroll_Check_View | |||
View definition | |||
-- Once upon a time, there was a table in the database named Payable_Transaction_N_Payroll_Check. This table linked a -- given payroll check with all the payroll liabilities (payable transactions) it generated. This arrangement proved to -- be inadequate. The Payable_Transaction_N_Payroll_Check table was replaced with three dictionary tables that linked -- various payroll check detail with the liabilities they generated. To make this replacement easier, this view was -- created to generate the contents of the original table from the three new tables. --drop view dbo.Payable_Transaction_N_Payroll_Check_View create view dbo.Payable_Transaction_N_Payroll_Check_View as -- SELECT payable_transaction_KEY, bank_transaction_KEY FROM ( select payable_transaction_KEY , bank_transaction_KEY from dbo.Payable_Transaction_N_Payroll_Check_Payroll_Item PTNPCPI join dbo.Payroll_Check_Payroll_Item PCPI on PTNPCPI.payroll_check_payroll_item_KEY = PCPI.payroll_check_payroll_item_KEY UNION select payable_transaction_KEY , bank_transaction_KEY from dbo.Payable_Transaction_N_Payroll_Check_Tax_Item PTNPCTI join dbo.Payroll_Check_Tax_Item PCTI on PTNPCTI.payroll_check_tax_item_KEY = PCTI.payroll_check_tax_item_KEY UNION SELECT payable_transaction_KEY , bank_transaction_KEY from dbo.Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item PTNPBTWCI join dbo.Payroll_Bank_Transaction_Worker_Compensation_Item PBTWCI on PTNPBTWCI.payroll_bank_transaction_worker_compensation_item_KEY = PBTWCI.payroll_bank_transaction_worker_compensation_item_KEY ) as MyTable | |||