Column medicare._beneficiaries.discrepancies

Overview of column discrepancies in table medicare._beneficiaries


Table	medicare._beneficiaries
Qualified name	medicare._beneficiaries.discrepancies
Datatype	string
Column type	computed

Number of possible discrepancies for the beneficiary, .i.e., records that use alternative DOB, race, ethnicity or DOD

Expressions

SELECT (
  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
)

Column medicare._beneficiaries.discrepancies Lineage SVG — Data lineage for column medicare._beneficiaries.discrepancies