# Hospital chargemaster — canonical view

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

Canonical hospital-chargemaster view: resolved code system, payer/plan, rate type, billing class, rate, gross charge. The canonicalized rate surface (broader than _comparable; before the comparability filter).

**Grain.** One row per canonical hospital rate (CCN, billing_code, payer, plan).

| column | type | meaning |
|---|---|---|
| hospital_ccn | string |  |
| hospital_name | string |  |
| hospital_state | string |  |
| billing_code | string |  |
| code_system | string |  |
| code_system_resolved | string |  |
| code_system_precision | varchar(14) |  |
| payer_name | string |  |
| plan_name | string |  |
| rate_type | string |  |
| billing_class | string |  |
| rate | double |  |
| gross_charge | double |  |
| cash_price | double |  |
| methodology | string |  |
| methodology_norm | varchar(17) |  |
| payment_grain | string |  |
| grain_confidence | string |  |
| negotiated_pct | double |  |
| negotiated_algo | string |  |
| estimated_amount | double |  |
| median_amount | double |  |
| allowed_count | bigint |  |
| billing_code_comparable | string |  |
| billing_code_precision | varchar(14) |  |
| billing_class_norm | varchar(13) |  |
| billing_class_resolved | varchar(13) |  |
| billing_class_source | varchar(21) |  |
| billing_class_learned_inst_frac | double |  |
| payer_canonical_id | string |  |
| payer_parent_name | string |  |
| payer_entity_class | string |  |
| payer_match_method | string |  |
| line_of_business | string |  |
| plan_product_structure | string |  |
| plan_classify_method | string |  |
| plan_classify_confidence | double |  |
| plan_label_scope | varchar(16) |  |
| build_vintage | string |  |
| fact_builder_version | string |  |
| on_fixed_build | boolean |  |
| state_certification | varchar(15) |  |
| state_certified | boolean |  |

Tools that read it: compare_hospital_rates, coverage_status

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