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	copied

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

Data lineage for column medicare.beneficiaries.orec_latest