Column medicare.enrollments.died Lineage SVG

medicare.enrollments.died medicare.enrollments.died CASE EXTRACT (YEAR from MAX(dod))  WHEN year THEN TRUE  ELSE FALSEEND medicare.beneficiaries.dod medicare.beneficiaries.dod MAX(dod) medicare.beneficiaries.dod->medicare.enrollments.died Copied medicare._beneficiaries.dod medicare._beneficiaries.dod MAX(dod) medicare._beneficiaries.dod->medicare.beneficiaries.dod Copied 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) medicare._ps.dod->medicare._beneficiaries.dod  Aggregated On bene_id 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) medicare.ps.dod->medicare._ps.dod Copied medicare.ps.dod_parent 8 incoming links (columns) medicare.ps.dod_parent->medicare.ps.dod