Column medicare._beneficiaries.orec_latest Lineage SVG

medicare._beneficiaries.orec_latest medicare._beneficiaries.orec_latest Non-null only when OREC was not consistent across the beneficiary's records (i.e. it changed over the years). Drives consistent_orec, analogously to dob_latest -> consistent_dob. CASE  WHEN MIN(orec) <> MAX(orec) THEN MAX(orec)END medicare._ps.orec medicare._ps.orec medicare._ps.orec->medicare._beneficiaries.orec_latest  Aggregated On bene_id medicare.ps.orec medicare.ps.orec medicare.ps.orec->medicare._ps.orec Copied medicare.ps.orec_parent 8 incoming links (columns) medicare.ps.orec_parent->medicare.ps.orec