Column medicare.qc_enrl_bene.discrepancies

Overview of column discrepancies in table medicare.qc_enrl_bene


Table	medicare.qc_enrl_bene
Qualified name	medicare.qc_enrl_bene.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.qc_enrl_bene.discrepancies Lineage SVG — Data lineage for column medicare.qc_enrl_bene.discrepancies