Outpatient Percentage Base Rate
Some hospital outpatient contracts are structured as a single percentage of billed charges applied uniformly across all HCPCS codes — rather than code-by-code rates. When Clear Rates observes this pattern, it detects the implied percentage and applies it to fill in missing outpatient HCPCS rates.
Why This Is Needed
Hospital MRFs often publish a pct-of-charges rate for one or two representative HCPCS codes but omit the rest. If the payer consistently applies the same percentage to all outpatient codes at that hospital, the observed codes reveal the contract structure and the missing ones can be filled in.
Detection Logic
The pipeline examines percentage-type rates for billing_code_type = 'HCPCS' and bill_type = 'Outpatient' from the long rates table. For each (payer_id, network_id, provider_id) group, it finds the most frequently occurring percentage:
| Requirement | Value |
|---|---|
| Rate type | percentage (not dollar) |
| Bill type | Outpatient |
| Billing code type | HCPCS |
| Minimum frequency | > 200 observed codes |
| Dominance | > 90% of all outpatient percentage codes share this rate |
If both thresholds are met, the detected percentage is the outpatient base rate for that provider-payer.
Application
The detected percentage is applied as a pct-to-dollar imputation against the gross charge for each missing outpatient ROID:
imputed_rate = 0.01 × op_percentage_base_rate × gross_charge
The 0.01 converts the stored percentage (e.g., 85) to a decimal (e.g., 0.85).
Walk-Through
op_percentage_candidate_base_rate = 85, op_percentage_effective = 0.85The OP percentage base rate is a derived imputation, not a transformation. Transformations convert existing pct-of-charges rates in the MRF; this method detects a pattern across observed rates and applies it to codes that have no MRF entry at all.