Update patient_mgb_patients.sql for max(EligibilityDTS) precision

Update patient_mgb_patients.sql - when calculating max(EligibilityDTS) from HealthPlanDM.MemberMonthDetailFact, include ProductTypeCD and InsuranceTypeCD in the GROUP BY statement (and subsequent join between pd and mce). This will account for the fact that max eligibility year month can vary at that additional level of detail. (Not applicable/needed for ACODM.)

patient_mgb_patients/patient_mgb_patients.sql

@@ -100,13 +100,17 @@ with pcmh_practice as (
         inner join (
             select
                 pd.PlanCD,
+                pd.ProductTypeCD,
+                pd.InsuranceTypeCD,
                 max(edd.EligibilityDTS) as EligibilityDTS
             from Payer.HealthPlanDM.MemberMonthDetailFact mmdf
                 inner join Payer.HealthPlanDM.EligibilityDateDimension edd on mmdf.EligibilityDateID = edd.EligibilityDateID
                 inner join Payer.HealthPlanDM.ProductDimension pd on mmdf.ProductID = pd.ProductID
-            group by pd.PlanCD
+            group by pd.PlanCD, pd.ProductTypeCD, pd.InsuranceTypeCD
         ) mce on edd.EligibilityDTS = mce.EligibilityDTS
             and pd.PlanCD = mce.PlanCD
+            and pd.ProductTypeCD = mce.ProductTypeCD
+            and pd.InsuranceTypeCD = mce.InsuranceTypeCD
         left join Payer.Reference.ReportGroup rg on mmdf.PCPReportGroupID = rg.ReportGroupID
         left join Epic.Patient.Patient_Enterprise ptn on mdd.EDWPatientID = ptn.EDWPatientID
         left join Integration.MasterReference.Patient mrp on mdd.EDWPatientID = mrp.EDWPatientID