Percentage to Dollar

Convert percentage rates to dollar amounts using gross charges. 6 GC sources × 6 rate types = 36 output columns.

Walkthrough

Converting a pct-billed rate to dollars

Input: Hospital reports "125% of gross charges" for code 99213.

Gross charge lookup: Provider-level gross charge (gc_hosp) = \$160.

Formula: 0.01 × 125 × \$160 = \$200

All 6 GC sources applied: gc_hosp, gc_hosp_cbsa, gc_hosp_state, gc_komodo, gc_komodo_cbsa, gc_komodo_state — each produces a separate output column.

Six new dollar columns are written. If a GC source has no data for this provider/code, that column is NULL.

The 36 Output Columns

Six rate types (payer percentage, payer fee schedule pct, hospital pct-of-billed, hospital case rate pct, hospital per diem pct, Komodo pct) crossed with six gross charge sources produce 36 pct-to-dollar columns. Naming follows:

{rate_type}_{gc_source}_perc_to_dol

Example: hospital_perc_of_total_billed_charges_gc_hosp_perc_to_dol

Accuracy scoring impact

Provider-level GC transforms (gc_hosp) score higher than geographic medians (gc_hosp_cbsa, gc_hosp_state) because they are more specific to the actual hospital. Accuracy scores drive rate selection to automatically prefer the most specific GC source — no manual intervention needed.