Hospital price transparency

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

vlada_curated.vw_fact_hospital_chargemaster_comparable·live·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

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

Grain

Key	Grain
N/A	1One row per (CCN, billing_code, payer, plan, billing_class) — comparable rate.

Columns (33)

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

Query it

describe_data_source(source_fqn="vlada_curated.vw_fact_hospital_chargemaster_comparable")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.vw_fact_hospital_chargemaster_comparable WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	compare_hospital_rates
Identity key	`hospital_ccn`
Join	`how_to_join(source_fqn="vlada_curated.vw_fact_hospital_chargemaster_comparable")`
Raw door	Athena (read-only via query_substrate): vlada_curated.vw_fact_hospital_chargemaster_comparable
Company names	`payer_name` `payer_parent_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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