Column medicare.admissions.bene Lineage SVG

medicare.admissions.bene medicare.admissions.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.ip.bene_id medicare.ip.bene_id medicare.ip.bene_id->medicare.admissions.bene  Transformed medicare.ip.bene_id_parent 8 incoming links (columns) medicare.ip.bene_id_parent->medicare.ip.bene_id medicare.enrollments.bene_id medicare.enrollments.bene_id medicare.enrollments.bene_id->medicare.admissions.bene parent-child medicare._enrollments.bene_id medicare._enrollments.bene_id medicare._enrollments.bene_id->medicare.enrollments.bene_id Copied 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_id Copied medicare._beneficiaries.bene_id->medicare.beneficiaries.bene_id Copied