View: dbo.Employee_Payroll_Item_View
View definition
-- View for the Employee_Payroll_Item table. Allows for joined in fields.
create view dbo.Employee_Payroll_Item_View
as
(
select EPI.*,
parent__employee_payroll_item_KEY = CEPINPEPI.parent__employee_payroll_item_KEY
from
dbo.Employee_Payroll_Item as EPI
left join
dbo.Child_Employee_Payroll_Item_N_Parent_Employee_Payroll_Item as CEPINPEPI
on
EPI.employee_payroll_item_KEY = CEPINPEPI.child__employee_payroll_item_KEY
)