Column medicare.ps.dod

Overview of column dod in table medicare.ps

Table	medicare.ps
Qualified name	medicare.ps.dod
Datatype	date
Column type	transformed

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