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