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 ) | |||