Drugs and formularies

Part D formulary exclusion list (CMS SPUF)

drug_silver.fact_drug_formulary_excluded·live·silver·Part D Plans & Formularies

Rows

355,140

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Plan-level explicit drug-exclusion list from CMS SPUF, with tier, prior-auth, step-therapy, quantity-limit, and capped-benefit flags.
2The cross-cut "which plans exclude drug X / how the exclusion list grew" lens.

Grain

Key	Grain
N/A	1One row per (contract_id, plan_id, drug_identifier, drug_identifier_type, report_quarter).

Columns (27)

Column	Type	Meaning
`contract_id`	string
`plan_id`	string
`drug_identifier`	string
`drug_identifier_type`	string
`report_quarter`	string
`tier`	int
`quantity_limit_yn`	boolean
`quantity_limit_amount`	double
`quantity_limit_days`	int
`prior_auth_yn`	boolean
`step_therapy_yn`	boolean
`capped_benefit_yn`	boolean
`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_drug_formulary_excluded")     # the card, live
query_substrate(sql="SELECT * FROM drug_silver.fact_drug_formulary_excluded WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`drug_identifier`
Join	`how_to_join(source_fqn="drug_silver.fact_drug_formulary_excluded")`
Raw door	Tools: exclusion_lens, formulary_coverage_lookup; Athena: drug_silver.fact_drug_formulary_excluded
Note	SPUF substrate sibling of fact_drug_formulary; filter is_current = true.

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