Column medicare._beneficiaries.orec_latest

Overview of column orec_latest in table medicare._beneficiaries


Table	medicare._beneficiaries
Qualified name	medicare._beneficiaries.orec_latest
Datatype	string
Column type	computed

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.

Expressions

SELECT CASE
  WHEN MIN(orec) <> MAX(orec) THEN MAX(orec)
END

Column medicare._beneficiaries.orec_latest Lineage SVG — Data lineage for column medicare._beneficiaries.orec_latest