View: dbo.Payroll_Transaction_Employee_Reporting_Type_View
View definition
-- This view is used to link the employee’s reporting types to the payroll transaction and
-- will be used in the system for Employee Reporting Type Filter in Payroll Datasource
create view [dbo].[Payroll_Transaction_Employee_Reporting_Type_View]
as
select
bank_transaction_KEY = PBT.bank_transaction_KEY
, employee_reporting_type_KEY = EERT.employee_reporting_type_KEY
from
dbo.Payroll_Bank_Transaction PBT
inner join
dbo.Employee_N_Employee_Reporting_Type_View EERT on PBT.employee_KEY = EERT.employee_KEY