View: dbo.Payroll_Bank_Transaction_View | |||
View definition | |||
CREATE VIEW dbo.Payroll_Bank_Transaction_View AS SELECT pbt.bank_transaction_KEY , pbt.employee_KEY , pbt.pay_frequency_KEY , pbt.period_begin_date , pbt.period_end_date , pbt.weeks_worked , pbt.ste_location_code , pbt.do_not_create_check_from_enter_batch_checks , pbt.employee_earning_type_KEY , pbt.employee_multi_state_income_tax_calculation_method_KEY , pbt.state_unemployment_combined , pbt.psd_code -- NOT pbt.existing_bad_data FROM dbo.Payroll_Bank_Transaction AS pbt ; | |||