# Hospital chargemaster — current (full, wide) view

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

The widest current-vintage hospital-chargemaster view (rate_id grain, ~93 cols incl alt-code arrays, all payer/plan/rate attributes). The full-detail surface for deep inspection / lineage; downstream views project from it.

**Grain.** One row per current chargemaster rate_id (full 93-column detail).

| column | type | meaning |
|---|---|---|
| rate_id | string |  |
| hospital_ccn | string |  |
| hospital_name | string |  |
| hospital_state | string |  |
| billing_code | string |  |
| code_system | string |  |
| alt_codes_hash | string |  |
| code_1 | string |  |
| code_1_type | string |  |
| code_2 | string |  |
| code_2_type | string |  |
| code_3 | string |  |
| code_3_type | string |  |
| code_4 | string |  |
| code_4_type | string |  |
| code_5 | string |  |
| code_5_type | string |  |
| description | string |  |
| payer_name | string |  |
| plan_name | string |  |
| rate_type | string |  |
| rate | double |  |
| min_rate | double |  |
| max_rate | double |  |
| billing_class | string |  |
| setting | string |  |
| modifiers | string |  |
| additional_info | string |  |
| collected_at | string |  |
| code_valid | boolean |  |
| gross_charge | double |  |
| cash_price | double |  |
| methodology | string |  |
| negotiated_pct | double |  |
| negotiated_algo | string |  |
| estimated_amount | double |  |
| drug_unit | string |  |
| drug_type | string |  |
| median_amount | double |  |
| tenth_percentile | double |  |
| ninetieth_percentile | double |  |
| allowed_count | bigint |  |
| version_id | string |  |
| source_files | array<string> |  |
| loaded_at | timestamp |  |
| methodology_statement | string |  |
| lookback_window_start | date |  |
| lookback_window_end | date |  |
| attestation_statement | string |  |
| confirm_attestation | boolean |  |
| attester_name | string |  |
| attester_title | string |  |
| npi_type2 | array<string> |  |
| cms_hpt_txt_probed | boolean |  |
| cms_hpt_txt_url | string |  |
| homepage_footer_link_present | boolean |  |
| content_sha256 | string |  |
| parser_version | string |  |
| mrf_schema_version | string |  |
| fetched_at | timestamp |  |
| raw_s3_key | string |  |
| pbd_npi | string |  |
| is_off_campus_pbd | boolean |  |
| parent_ccn | string |  |
| mrf_version_id | string |  |
| rate_outlier_flag | string |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| asserted_at_source | string |  |
| calculation_epoch | date |  |
| vintage | string |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| restatement_of | string |  |
| is_current | boolean |  |
| snapshot_set | string |  |
| s3_version_id | string |  |
| bronze_object_key | string |  |
| sha256_content_hash | string |  |
| source_lineage | string |  |
| parent_vintage_fingerprint | string |  |
| source_id | string |  |
| source_url | string |  |
| parser_artifact_hash | string |  |
| ingested_at | timestamp |  |
| count_of_compared_rates | bigint |  |
| additional_payer_notes | string |  |
| footnote | string |  |
| cbsa_code | string |  |
| chain_parent_id | string |  |
| payer_canonical_id | string |  |
| percentage_source | string |  |
| fact_builder_version | string |  |
| payment_grain | string |  |
| grain_confidence | string |  |
| allowed_count_band | string |  |

Tools that read it: coverage_status

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