Part D excluded-drug coverage in the coverage gap (GAP_COV), CMS SPUF sidecar, 2019-Q1 to 2024-Q3

What it is

1. 1Whether a plan covers each drug on its excluded-drug list (the supplemental coverage of drugs excluded from the basic Part D benefit) in the coverage gap: gap_cov true = Y, false = N, from the GAP_COV field of the quarterly SPUF excluded drugs file, which the original SPUF parser never read.
2. 2A sidecar of drug_silver.fact_drug_formulary_excluded: join on (contract_id, plan_id, drug_identifier, drug_identifier_type, report_quarter) to the parent's is_current = true rows; every sidecar row joins exactly one parent row and every parent row in 2019-Q1..2024-Q3 has one.
3. 3268,567 rows in 23 quarters: 189,204 covered, 79,363 not, 0 NULL;
4. 419,537 NDC-keyed and 249,030 RxCUI-keyed rows (Athena d3768534).

Grain

Columns (21)

Query it

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