# Hospital chargemaster — comparable view (real-negotiated, classified)

`vlada_curated.vw_fact_hospital_chargemaster_comparable` · Hospital price transparency · status live

The serving view over the hospital chargemaster, FILTERED to comparable / real-negotiated rates with payer entity/plan structure resolved and a comparability class. The surface the pricing engine reads for hospital rates (backed by fact_hospital_comparability_mat).

**Grain.** One row per (CCN, billing_code, payer, plan, billing_class) — comparable rate.

| column | type | meaning |
|---|---|---|
| hospital_ccn | string |  |
| hospital_name | string |  |
| hospital_state | string |  |
| billing_code | string |  |
| code_system_resolved | string |  |
| billing_class_resolved | varchar(13) |  |
| facility_type | varchar(9) |  |
| payer_parent_name | string |  |
| payer_name | string |  |
| plan_name | string |  |
| payer_entity_class | string |  |
| plan_product_structure | string |  |
| line_of_business | string |  |
| rate_type | string |  |
| methodology_norm | varchar(17) |  |
| payment_grain | string |  |
| grain_confidence | string |  |
| rate | double |  |
| gross_charge | double |  |
| cash_price | double |  |
| x_medicare | double |  |
| negotiated_pct | double |  |
| negotiated_algo | string |  |
| derived_amount | double |  |
| derived_amount_basis | string |  |
| comparability_class | varchar(18) |  |
| comparability_reason | string |  |
| methodology_filed | varchar(17) |  |
| methodology_basis | varchar(28) |  |
| plausibility_band | varchar(23) |  |
| price_basis | varchar(21) |  |
| billing_class_basis | varchar(29) |  |
| code_bucket | bigint |  |

Tools that read it: compare_hospital_rates

Query it: `query_substrate` with `SELECT ... FROM vlada_curated.vw_fact_hospital_chargemaster_comparable WHERE ... LIMIT 100`; read `describe_data_source("vlada_curated.vw_fact_hospital_chargemaster_comparable")` first.