Skip to content

Update patient_mgb_patients.sql for max(EligibilityDTS) precision

Boukus, Ellyn R requested to merge eb_PatientMGBPatients_UpdateMaxElig into main

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

Merge request reports