Column medicare.qc_enrl_bene.consistent_dob

Overview of column consistent_dob in table medicare.qc_enrl_bene

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

Expressions

SELECT (CASE
  WHEN dob IS NULL THEN 'MISSING'
  WHEN dob_latest IS NOT NULL THEN 'AMBIGUOUS'
  ELSE 'CONSISTENT'
END)