# WAC increases — California HCAI SB 17 notices

`drug_silver.fact_drug_hcai_sb17_wac_increase` · Drugs and formularies · status partial

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

**Grain.** One row per (report_year, oshpd_id, NDC11, wac_effective_date, drug_category) increase notice; NULL 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).

| 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: `query_substrate` with `SELECT ... FROM drug_silver.fact_drug_hcai_sb17_wac_increase WHERE ... LIMIT 100`; read `describe_data_source("drug_silver.fact_drug_hcai_sb17_wac_increase")` first.