Column medicare.qc_enrl_bene.discrepancies Lineage SVG

medicare.qc_enrl_bene.discrepancies medicare.qc_enrl_bene.discrepancies Number of possible discrepancies for the beneficiary, .i.e., records that use alternative DOB, race, ethnicity or DOD (  COUNT(distinct {identifiers}) - 1 +  CASE    (COUNT(DISTINCT dod) FILTER (WHERE dod is not null))    WHEN 0 THEN 0    ELSE COUNT(DISTINCT dod) FILTER (WHERE dod is not null) - 1  END) medicare.beneficiaries.dod medicare.beneficiaries.dod MAX(dod) medicare.beneficiaries.dod->medicare.qc_enrl_bene.discrepancies join natural 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