Column medicare.qc_enrl_bene.curec_latest Lineage SVG

medicare.qc_enrl_bene.curec_latest medicare.qc_enrl_bene.curec_latest Non-null only when duplicate source records disagree on CUREC within a (bene_id, year, state) group. Drives consistent_curec. Defensive / future- proofing: this multiplicity does not occur in the synthetic dataset (every group is a single row) but can arise in real Medicare data from overlapping or reissued MBSF files, where MAX(curec) would otherwise silently pick one value. CASE  WHEN MIN(curec) <> MAX(curec) THEN MAX(curec)END medicare.enrollments.curec medicare.enrollments.curec MAX(curec) medicare.enrollments.curec->medicare.qc_enrl_bene.curec_latest join natural medicare._enrollments.curec medicare._enrollments.curec MAX(curec) medicare._enrollments.curec->medicare.enrollments.curec Copied medicare._ps.curec medicare._ps.curec medicare._ps.curec->medicare._enrollments.curec  Aggregated On bene_id, year, state medicare.ps.curec medicare.ps.curec medicare.ps.curec->medicare._ps.curec Copied medicare.ps.curec_parent 8 incoming links (columns) medicare.ps.curec_parent->medicare.ps.curec