Column medicare.qc_enrl_bene.orec_latest

Overview of column orec_latest in table medicare.qc_enrl_bene


Table	medicare.qc_enrl_bene
Qualified name	medicare.qc_enrl_bene.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.qc_enrl_bene.orec_latest Lineage SVG — Data lineage for column medicare.qc_enrl_bene.orec_latest