Column medicare.ps.dod Lineage SVG

medicare.ps.dod medicare.ps.dod Date of beneficiary death, if available 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) cms.mbsf_ab_2011.DEATH_DT cms.mbsf_ab_2011.DEATH_DT Date of Death cms.mbsf_ab_2011.DEATH_DT->medicare.ps.dod union cms.mbsf_ab_2012.DEATH_DT cms.mbsf_ab_2012.DEATH_DT Date of Death cms.mbsf_ab_2012.DEATH_DT->medicare.ps.dod union cms.mbsf_ab_2013.DEATH_DT cms.mbsf_ab_2013.DEATH_DT Date of Death cms.mbsf_ab_2013.DEATH_DT->medicare.ps.dod union cms.mbsf_abcd_2015.DEATH_DT cms.mbsf_abcd_2015.DEATH_DT Beneficiary Date of Death cms.mbsf_abcd_2016.DEATH_DT cms.mbsf_abcd_2016.DEATH_DT Beneficiary Date of Death cms.mbsf_abcd_2017.DEATH_DT cms.mbsf_abcd_2017.DEATH_DT Beneficiary Date of Death cms.mbsf_abcd_2018.DEATH_DT cms.mbsf_abcd_2018.DEATH_DT Beneficiary Date of Death cms.mbsf_ab_2014.DEATH_DT cms.mbsf_ab_2014.DEATH_DT Date of Death cms.mbsf_ab_2014.DEATH_DT->medicare.ps.dod union cms.mbsf_abcd_2015.DEATH_DT->medicare.ps.dod union cms.mbsf_abcd_2016.DEATH_DT->medicare.ps.dod union cms.mbsf_abcd_2017.DEATH_DT->medicare.ps.dod union cms.mbsf_abcd_2018.DEATH_DT->medicare.ps.dod union