Drugs and formularies

WAC increases — California HCAI SB 17 notices

drug_silver.fact_drug_hcai_sb17_wac_increase·partial·silver·WAC increases — California HCAI SB 17 notices

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Event-level Wholesale Acquisition Cost increase notices with manufacturer explanations (CA HCAI SB 17).
2The public lens on WAC list-price actions.

Grain

Key	Grain
N/A	1One row per (report_year, oshpd_id, NDC11, wac_effective_date, drug_category) increase notice; 2NULL drug_category coalesces to '' in the certified key (revised per the 2026-07-02 accepted gate design -- a genuine 2025 Brand/Generic publisher pair shares the old 4-column key).

Columns (49)

Column	Type	Meaning
`report_year`	int
`oshpd_id`	string
`ndc11`	string
`manufacturer_name`	string
`date_reported`	date
`drug_product_description`	string
`drug_category`	string
`drug_category_source`	string
`wac_effective_date`	date
`wac_increase_amount_usd`	double
`wac_after_increase_usd`	double
`patent_expiration_date`	date
`drug_source_type`	string
`gross_sales_volume_us_dollars`	double
`gross_sales_volume_nonpublic`	boolean
`cost_increase_factors`	string
`cost_increase_factors_nonpublic`	boolean
`change_improvement_desc`	string
`change_improvement_nonpublic`	boolean
`acquisition_date`	date
`acquired_from_company`	string
`acquisition_price_usd`	double
`acquisition_price_nonpublic`	boolean
`acquisition_price_comment`	string
`wac_at_acquisition_usd`	double
`wac_year_prior_to_acq_usd`	double
`year_introduced`	int
`wac_at_introduction_usd`	double
`supporting_documents`	string
`general_comments`	string
`source_resource_id`	string
`source_resource_last_modified`	string
`source_resource_hash`	string
`source_resource_size_bytes`	bigint
`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_hcai_sb17_wac_increase")     # the card, live
query_substrate(sql="SELECT * FROM drug_silver.fact_drug_hcai_sb17_wac_increase WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`ndc11`
Join	`how_to_join(source_fqn="drug_silver.fact_drug_hcai_sb17_wac_increase")`
Raw door	Tool: wac_pricing_lookup; Athena: drug_silver.fact_drug_hcai_sb17_wac_increase
Note	2024-04-01 regulatory change swapped unit-sales for gross-sales-USD.

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