Column medicare._ps.dod

Overview of column dod in table medicare._ps

Table	medicare._ps
Qualified name	medicare._ps.dod
Datatype	date
Column type	copied

Date of beneficiary death, if available

Casts:

Original type	Cast expression
character varying	(CASE WHEN {column_name} = ‘00000000’ THEN NULL ELSE public.parse_date({column_name}) END)
numeric	(CASE WHEN {column_name} < 19000000 THEN NULL ELSE to_date(to_char({column_name}, ‘00000000’), ‘YYYYMMDD’) END)

Data lineage for column medicare._ps.dod