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
;