Column medicare.beneficiaries.discrepancies

Overview of column discrepancies in table medicare.beneficiaries

Table	medicare.beneficiaries
Qualified name	medicare.beneficiaries.discrepancies
Datatype	string
Column type	copied

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
)

Data lineage for column medicare.beneficiaries.discrepancies