# Column medicare.qc_enrl_bene.consistent_dob

## Overview of column consistent_dob in table medicare.qc_enrl_bene 

|                               |                        |
| ----------------------------- | ---------------------- |
| Table                         | [medicare.qc_enrl_bene](../medicare.qc_enrl_bene.md)           |
| Qualified name                | medicare.qc_enrl_bene.consistent_dob  |
| Datatype                      | VARCHAR(12)        |
| Column type | computed |



## Expressions

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

```