Medicare Advantage, Part D, Medicaid

HCPCS/CPT -> HCRIS cost-center crosswalk (the precision layer)

medicare_silver.hcpcs_cost_center_crosswalk·live·silver·Billing Code Intelligence

Rows

28,328

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The map that makes cost-based pricing accurate: each billing code -> the cost center where a hospital accumulates that service's cost (CT, MRI, Lab, OR, Clinic, ...).
2Derived from a 1.8-billion-row EMPIRICAL bridge (the modal UB-04 revenue code hospitals actually billed each code under, from our MRF) mapped through the authoritative CMS revenue-code -> cost-center spine, then adversarially validated by a sub-agent fleet (2,805 high-value codes).
3Join hcpcs -> cost_center_line, then use hospital_cost_report_dept for that center's CCR.

Grain

Key	Grain
N/A	1One row per HCPCS/CPT code. 228,328 codes -> their HCRIS 2552-10 Worksheet C cost center, so a code can be priced on the RIGHT department cost-to-charge ratio.

Columns (11)

Column	Type	Meaning
`hcpcs`	string
`cost_center_line`	string
`cost_center_label`	string
`modal_rc`	string
`modal_share`	string
`rc_support_rows`	string
`method`	string
`confidence`	string
`is_em_professional`	string
`fleet_validated`	string
`validation_note`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`hcpcs`
Join	`how_to_join(source_fqn="medicare_silver.hcpcs_cost_center_crosswalk")`
Raw door	Athena (read-only via query_substrate): medicare_silver.hcpcs_cost_center_crosswalk

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