View: dbo.Direct_Deposit_Refund_Bank_Account_View

View definition

-- creating view dbo.Direct_Deposit_Refund_Bank_Account_View -- to make sure refund bank account info is available to pass through Uberdataset -- not giving direct access to Checkbook table with not enabling constraints -- as tables in uberdataset are going through common data adapter where -- checkbook table and client payroll information have issue with foreign key constraints CREATE VIEW dbo.Direct_Deposit_Refund_Bank_Account_View AS SELECT cb.checkbook_KEY , cb.client_KEY , cb.bank_KEY , cb.bank_account_type_KEY , cb.description , cb.bank_account_number , b.bank_name , b.routing_number FROM dbo.Checkbook AS cb INNER JOIN dbo.Bank AS b ON cb.bank_KEY = b.bank_KEY ;