# plan_hospital_price

Plan Hospital Price · v1.5.0 · hospital

One hospital, one code, the rate by payer and plan name as the hospital filed it (where negotiated rates by insurer live today; the insurer-file / TiC tools are coming soon). Dry-run a bounded hospital fact_hospital_chargemaster proof. Requires hospital_ccn and billing_code, plans Iceberg files/bytes before materializing rows, and returns a receipt-shaped plan.

**Inputs.**
- `hospital_ccn` (required): 
- `billing_code` (required): 
- `version_id`: 
- `payer_name`: 
- `plan_name`: 
- `billing_class`: 
- `current_only`: 
- `require_byte_provenance`: 
- `max_rows`: 
- `max_planned_files`: 
- `max_planned_bytes`: 

**A real answer** (customer seat, 6.39 s, args `{"hospital_ccn":"070005","billing_code":"70450"}`):

```json
{
 "value": {
  "proof_kind": "hospital_price_proof",
  "source_table": "fact_hospital_chargemaster",
  "hospital_ccn": "070005",
  "billing_code": "70450",
  "version_id": null,
  "planned_file_count": 1,
  "planned_bytes": 93233000,
  "planned_record_count": 1908186,
  "planned_delete_file_count": 0,
  "plan_manifest_hash": "432b007b75d09646abed67f2ed3107945c3e9902b0518a03d1cffbceaa5b8abb",
  "row_count": 0,
  "status": "planned",
  "all_rows_have_byte_provenance": true,
  "distinct_payer_names": [],
  "distinct_plan_names": [],
  "distinct_billing_classes": [],
  "distinct_methodologies": [],
  "distinct_content_sha256": [],
  "distinct_raw_s3_keys": [],
  "distinct_mrf_version_ids": [],
  "verdict": "planned"
 },
 "unit": null,
 "vintage": null,
 "methodology": null,
 "caveats": [],
 "response_hash": "58de83528854634706f3ef649906303176a93561774568603234fdef9b65286d",
 "semantic_version": 1,
 "tool_version": "plan_hospital_price@1.5.0",
 "explanation": null,
 "status": "complete",
 "proof_id": "hospitalprice_207327c53f67604d",
 "receipt": {
  "receipt_version": "hospital_price_proof_receipt.v0",
  "substrate": "hospital",
  "proof_kind": "hospital_price_proof",
  "proof_id": "hospitalprice_207327c53f67604d",
  "tool_name": "plan_hospital_price",
  "tool_version": "1.5.0",
  "source_table": "fact_hospital_chargemaster",
  "source_descriptor": {
   "table": "fact_hospital_chargemaster",
   "snapshot_id": "4789942790573672775",
   "raw_s3_keys": [],
   "content_sha256": [],
   "mrf_version_ids": [],
   "source_urls": [],
   "parser_artifact_hashes": [],
   "s3_version_ids": []
  },
  "read_snapshot_set": {
   "fact_hospital_chargemaster": "4789942790573672775"
  },
  "filters": {
   "hospital_ccn": "070005",
   "billing_code": "70450",
   "current_only": true
  },
  "guardrails": {
   "max_rows": 500,
   "max_planned_files": 500,
   "max_planned_bytes": 268435456,
   "current_only": true,
   "require_byte_provenance": true,
   "raw_parquet_glob_reads": "disabled",
   "shared_mrf_expansion": "not_performed_mvp"
  },
  "plan": {
   "planned_file_count": 1,
   "planned_bytes": 93233000,
   "planned_record_count": 1908186,
   "planned_delete_file_count": 0,
   "plan_manifest_hash": "432b007b75d09646abed67f2ed3107945c3e9902b0518a03d1cffbceaa5b8abb",
   "planned_files_sample": [
    "data/_VXeSg/hospital_state=CT/hospital_ccn=070005/20261002_010134_00448_k6qzf-35fcae15-3a2d-46e0-8d5d-644da8afbb0b.parquet"
   ]
  },
  "evidence": {
   "plan": {
    "planned_file_count": 1,
    "planned_bytes": 93233000,
    "planned_record_count": 1908186,
    "planned_delete_file_count": 0,
    "plan_manifest_hash": "432b007b75d09646abed67f2ed3107945c3e9902b0518a03d1cffbceaa5b8abb",
    "planned_files_sample": [
     "data/_VXeSg/hospital_state=CT/hospital_ccn=070005/20261002_010134_00448_k6qzf-35fcae15-3a2d-46e0-8d5d-644da8afbb0b.parquet"
    ]
   },
   "audit_chain": {
    "row_count": 0,
    "raw_s3_key_count": 0,
    "content_sha256_count": 0,
    "mrf_version_id_count": 0,
    "parser_artifact_hash_count": 0,
    "all_rows_have_byte_provenance": true
   }
  },
  "row_count": 0,
  "status": "planned",
  "caveats": [
   "billing_class_may_be_mixed",
   "current_rows_only_version_not_pinned_by_input",
   "hospital_price_proof_mvp_no_provider_group_expansion",
   "hospital_rates_are_chargemaster_mrf_rates_not_claims",
   "no_utilization_weighting_applied",
   "payer_name_may_be_mixed",
   "plan_name_may_be_mixed"
  ],
  "input_hash": "207327c53f67604d2fa515cbfde95955a8a3db0dbf20fdfddf8e97968f331723",
  "response_hash": "58de83528854634706f3ef649906303176a93561774568603234fdef9b65286d",
  "replay_pointer": {
   "tool": "plan_hospital_price",
   "inputs": {
    "hospital_ccn": "070005",
    "billing_code": "70450",
    "current_only": true,
    "require_byte_provenance": true,
    "max_rows": 500,
    "max_planned_files": 500,
    "max_planned_bytes": 268435456
   },
   "receipt_id": "hpr_58de83528854634706f3ef64"
  },
  "receipt_id": "hpr_58de83528854634706f3ef64"
 },
 "audience": "customer",
 "answer": {
  "value_ref": "value",
  "scope": {
   "tool": "plan_hospital_price",
   "filters": {
    "hospital_ccn": "070005",
    "billing_code": "70450",
    "current_only": true,
    "require_byte_provenance": true,
    "max_rows": 500,
    "max_planned_files": 500,
    "max_planned_bytes": 268435456
   }
  }
 },
 "method": "Negotiated facility prices for 70450 across hospitals, all plan types, compared on a single price basis. Percent-of-charge prices and list prices were set aside. You did not specify current_only; yes was used. You did not specify max_planned_bytes; 268435456 was used. You did not specify max_planned_files; 500 was used. You did not specify require_byte_provenance; yes was used.",
 "evidence": {
  "response_hash": "58de83528854634706f3ef649906303176a93561774568603234fdef9b65286d"
 },
 "defaults_applied": [
  {
   "param": "current_only",
   "used": true,
   "reason": "tool default"
  },
  {
   "param": "max_planned_bytes",
   "used": 268435456,
   "reason": "tool default"
  },
  {
   "param": "max_planned_files",
   "used": 500,
   "reason": "tool default"
  },
  {
   "param": "require_byte_provenance",
   "used": true,
   "reason": "tool default"
  }
 ],
 "freshness": {
  "state": "unknown",
  "why": "This tool does not report an edition for its answer, and the door could not derive one from what the answer reads. Treat the result as current to no stated date."
 }
}
```

REST: `POST https://api.vladahealth.com/v1/tools/plan_hospital_price` with the inputs as the JSON body. MCP: the tool by name.