Rate Arrays
Parallel arrays per ROID, with rate values, accuracy scores, and metadata in corresponding positions.
Array Structure
| Array | Content at position i | Example |
|---|---|---|
rate_array | Dollar value | 125.00 |
rate_score_array | Accuracy score (0–7.x) | 7.00000125 |
source_array | Data source label | "payer" |
rate_type_array | Column name with prefix | "raw: payer_negotiated_rate" |
methodology_array | Contract methodology | "Fee Schedule" |
rate_class_array | "Raw", "Transform", or "Impute" | "Raw" |
Position alignment is guaranteed: position i in rate_array corresponds to position i in every other array. ARRAY_POSITION on rate_score_array yields the index used to extract all other fields.
Priority Ordering
Array position matters when multiple rates have identical scores. The ordering differs by bill type:
Inpatient:
- Hospital raw rates
- Hospital untransformed rates
- Payer raw rates
- Payer untransformed rates
- Hospital transforms (provider GC)
- Payer transforms (provider GC)
- Hospital transforms (CBSA GC)
- Payer transforms (CBSA GC)
- State-level transforms
- Imputations
Non-Inpatient: Similar structure, but untransformed rates get slight priority within each tier, provider-level GC comes before CBSA, and hospital source is placed before payer within each tier.
*_no_impute array variants track what the canonical rate would be without imputations — for example, best_idx_no_impute records the rate selection result excluding imputed values. These are used internally to measure imputation lift and are available in prod_combined_all.