Drugs and formularies

Part D tier coverage in the coverage gap (GAP_COV_TIER), CMS SPUF sidecar, 2019-Q1 to 2024-Q3

drug_silver.fact_part_d_plan_cost_share_gap_coverage·live·silver

Rows

3,933,149

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Whether each cost-sharing tier of a Part D plan is covered in the coverage gap: gap_cov_tier 1 = fully covered, 2 = partially covered, 3 = not covered (PUFRecordLayout-2024), from the GAP_COV_TIER field of the quarterly SPUF beneficiary cost file, which the original SPUF parser never read.
2A sidecar of drug_silver.fact_part_d_plan_cost_share: join on (contract_id, plan_id, segment_id, coverage_level, tier, days_supply, report_quarter) to the parent's is_current = true rows (in vw_fact_part_d_plan_cost_share_v3 the days_supply column is days_supply_code).
3Every sidecar row joins exactly one parent row and every parent row in 2019-Q1..2024-Q3 has one.
43,933,149 rows in 23 quarters: 753,954 fully, 139,770 partially, 3,039,425 not covered, 0 NULL (Athena 0f3b8f11).

Grain

Key	Grain
N/A	1One row per (report_quarter, contract_id, plan_id, segment_id, coverage_level, tier, days_supply), the key of drug_silver.fact_part_d_plan_cost_share.

Columns (23)

Column	Type	Meaning
`contract_id`	string
`plan_id`	string
`segment_id`	string
`coverage_level`	int
`tier`	int
`days_supply`	int
`gap_cov_tier`	int
`report_quarter`	string
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`effective_period_end`	date
`cms_vintage_sequence`	int
`parse_revision`	int
`parser_artifact_hash`	string
`source_url`	string
`sha256_content_hash`	string
`source_id`	string
`is_current`	boolean
`bronze_object_key`	string
`s3_version_id`	string
`vintage_tag`	string
`drug_source_version_id`	string

Query it

describe_data_source(source_fqn="drug_silver.fact_part_d_plan_cost_share_gap_coverage")     # the card, live
query_substrate(sql="SELECT * FROM drug_silver.fact_part_d_plan_cost_share_gap_coverage WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`report_quarter,contract_id,plan_id,segment_id,coverage_level,tier,days_supply`
Join	`how_to_join(source_fqn="drug_silver.fact_part_d_plan_cost_share_gap_coverage")`
Raw door	Athena (read-only via query_substrate): drug_silver.fact_part_d_plan_cost_share_gap_coverage JOIN drug_silver.vw_fact_part_d_plan_cost_share_v3 on the seven key columns (days_supply = days_supply_code), parent is_current = true, pin report_quarter
Note	Register source cms_part_d_spuf (w3, serve raw). RAW. Sidecar of drug_silver.fact_part_d_plan_cost_share; the parent is unchanged. Loaded on the drug fleet 2026-10-06/07; registered 2026-10-07.

This page as markdown: /docs-md/data/drug_silver_fact_part_d_plan_cost_share_gap_coverage.md · every page in one file: /llms-full.txt