Column medicare.qc_enrl_bene.consistent_orec

Overview of column consistent_orec in table medicare.qc_enrl_bene

Table	medicare.qc_enrl_bene
Qualified name	medicare.qc_enrl_bene.consistent_orec
Datatype	VARCHAR(12)
Column type	computed

QC flag for OREC (Original Reason for Entitlement) consistency across the beneficiary’s records. AMBIGUOUS means OREC changed over the years, which should not happen for a genuine “original” code and indicates a data-quality issue. Mirrors consistent_dob / consistent_dod.

Expressions

SELECT (CASE
  WHEN orec IS NULL THEN 'MISSING'
  WHEN orec_latest IS NOT NULL THEN 'AMBIGUOUS'
  ELSE 'CONSISTENT'
END)