View: dbo.Employee_Payroll_Item_Special_Timing_View
View definition
CREATE VIEW dbo.Employee_Payroll_Item_Special_Timing_View
WITH SCHEMABINDING
AS
SELECT
e.employee_KEY,
pist.payroll_item_special_timing_KEY,
pist.payroll_item_special_timing_frequency_KEY,
pist.selected_week_one,
pist.selected_week_two,
pist.selected_week_three,
pist.selected_week_four,
pist.selected_week_five,
pist.payroll_item_special_timing_selected_payroll_period_basis_KEY,
pist.selected_payroll__payroll_item_special_timing_date_basis_KEY,
pist.start_date,
pist.end_date,
pist.payroll_item_special_timing_date_basis_KEY
FROM dbo.Employee e
JOIN dbo.Employee_Payroll_Item epi on e.employee_KEY = epi.employee_KEY
JOIN dbo.Employee_Payroll_Item_N_Payroll_Item_Special_Timing epinpist
on epinpist.employee_payroll_item_KEY = epi.employee_payroll_item_KEY
JOIN dbo.Payroll_Item_Special_Timing pist
on pist.payroll_item_special_timing_KEY = epinpist.payroll_item_special_timing_KEY
UNION
SELECT
e.employee_KEY,
pist.payroll_item_special_timing_KEY,
pist.payroll_item_special_timing_frequency_KEY,
pist.selected_week_one,
pist.selected_week_two,
pist.selected_week_three,
pist.selected_week_four,
pist.selected_week_five,
pist.payroll_item_special_timing_selected_payroll_period_basis_KEY,
pist.selected_payroll__payroll_item_special_timing_date_basis_KEY,
pist.start_date,
pist.end_date,
pist.payroll_item_special_timing_date_basis_KEY
FROM dbo.Employee e
JOIN dbo.Employee_Payroll_Item epi
on e.employee_KEY = epi.employee_KEY
JOIN dbo.Child_Support_Order cso
on cso.employee_payroll_item_KEY = epi.employee_payroll_item_KEY
JOIN dbo.Payroll_Item_Special_Timing pist
on pist.payroll_item_special_timing_KEY = cso.payroll_item_special_timing_KEY
UNION
SELECT
e.employee_KEY,
pist.payroll_item_special_timing_KEY,
pist.payroll_item_special_timing_frequency_KEY,
pist.selected_week_one,
pist.selected_week_two,
pist.selected_week_three,
pist.selected_week_four,
pist.selected_week_five,
pist.payroll_item_special_timing_selected_payroll_period_basis_KEY,
pist.selected_payroll__payroll_item_special_timing_date_basis_KEY,
pist.start_date,
pist.end_date,
pist.payroll_item_special_timing_date_basis_KEY
FROM dbo.Employee e
JOIN dbo.Employee_Payroll_Item epi
on e.employee_KEY = epi.employee_KEY
JOIN dbo.Creditor_Garnishment_Order cgo
on cgo.employee_payroll_item_KEY = epi.employee_payroll_item_KEY
JOIN dbo.Payroll_Item_Special_Timing pist
on pist.payroll_item_special_timing_KEY = cgo.payroll_item_special_timing_KEY
UNION
SELECT
e.employee_KEY,
pist.payroll_item_special_timing_KEY,
pist.payroll_item_special_timing_frequency_KEY,
pist.selected_week_one,
pist.selected_week_two,
pist.selected_week_three,
pist.selected_week_four,
pist.selected_week_five,
pist.payroll_item_special_timing_selected_payroll_period_basis_KEY,
pist.selected_payroll__payroll_item_special_timing_date_basis_KEY,
pist.start_date,
pist.end_date,
pist.payroll_item_special_timing_date_basis_KEY
FROM dbo.Employee e
JOIN dbo.Employee_Payroll_Item epi
on e.employee_KEY = epi.employee_KEY
JOIN dbo.Employee_Payroll_Item_Garnishment_Order epigo
on epigo.employee_payroll_item_KEY = epi.employee_payroll_item_KEY
JOIN dbo.Garnishment_Order gno
on gno.garnishment_order_KEY = epigo.garnishment_order_KEY
JOIN dbo.Payroll_Item_Special_Timing pist
on pist.payroll_item_special_timing_KEY = gno.payroll_item_special_timing_KEY