Skip to content

Update patient_primary_payer.sql for more precision with Max(EligibilityDTS)

Boukus, Ellyn R requested to merge eb_PatientPrimaryPayer_UpdateMaxElig into main

Update patient_primary_payer.sql - when calculating max(EligibilityDTS) from HealthPlanDM.MemberMonthDetailFact, include ProductTypeCD and InsuranceTypeCD in the GROUP BY statement. 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