View: dbo.Payroll_Consolidation_Group_Client_View
View definition
-- Added to allow clients to be filtered by payroll consolidation group.
-- This is needed because the filter needs to consider both the Payroll_Consolidation_Group and Payroll_Consolidation_Group_Member tables.
create view dbo.Payroll_Consolidation_Group_Client_View
as
select
client_KEY = PCG.primary__client_KEY
, payroll_consolidation_group_KEY = PCG.payroll_consolidation_group_KEY
from
dbo.Payroll_Consolidation_Group PCG
union
select
client_KEY = PCGM.client_KEY
, payroll_consolidation_group_KEY = PCGM.payroll_consolidation_group_KEY
from
dbo.Payroll_Consolidation_Group_Member PCGM