Column medicare.enrollments.bene Lineage SVG

medicare.enrollments.bene medicare.enrollments.bene HLL hash (see https://en.wikipedia.org/w iki/HyperLogLog). Can be used to calculate number of beneficiaries satisfying a certain given condition Use #(hll_add_agg(bene)) or hll_cardinality(hll_add_agg(bene)) aggregator GENERATED ALWAYS AS (hll_hash_text(bene_id)) STORED medicare._enrollments.bene_id medicare._enrollments.bene_id medicare._enrollments.bene_id->medicare.enrollments.bene  Transformed medicare._ps.bene_id medicare._ps.bene_id medicare._ps.bene_id->medicare._enrollments.bene_id  Aggregated On bene_id, year, state medicare._beneficiaries.bene_id medicare._beneficiaries.bene_id medicare._ps.bene_id->medicare._beneficiaries.bene_id  Aggregated On bene_id medicare.ps.bene_id medicare.ps.bene_id medicare.ps.bene_id->medicare._ps.bene_id Copied medicare.ps.bene_id->medicare._ps.bene_id Copied medicare.ps.bene_id_parent 8 incoming links (columns) medicare.ps.bene_id_parent->medicare.ps.bene_id medicare.ps.bene_id_parent->medicare.ps.bene_id medicare.beneficiaries.bene_id medicare.beneficiaries.bene_id medicare.beneficiaries.bene_id->medicare.enrollments.bene parent-child medicare._beneficiaries.bene_id->medicare.beneficiaries.bene_id Copied