Column medicare.qc_enrl_bene.consistent_dod

Overview of column consistent_dod in table medicare.qc_enrl_bene

Table

medicare.qc_enrl_bene

Qualified name

medicare.qc_enrl_bene.consistent_dod

Datatype

VARCHAR(12)

Column type

computed

Expressions

SELECT (CASE
  WHEN dod IS NULL THEN 'NONE'
  WHEN dod_earliest IS NOT NULL THEN 'AMBIGUOUS'
  ELSE 'CONSISTENT'
END)