| network_provider_sub_package_id | bigint | ID representing distinct combination of Network Provider and Sub Package |
| network_provider_ssp_id | bigint | ID representing distinct combination of Network Provider and SSP |
| id | bigint | |
| roid | bigint | Rate Object ID to connect to Clear Rates |
| ssp_id | varchar | |
| ssp_name | varchar | |
| sub_package_id | varchar | |
| payer_id | varchar | |
| payer_name | varchar | |
| network_id | bigint | |
| network_name | varchar | |
| provider_id | varchar | |
| provider_type | varchar | |
| state | varchar | |
| cbsa | varchar | |
| cbsa_name | varchar | |
| fee_type | varchar | professional or facility |
| is_package_base_code | integer | 1 if this billing code is the base code for the sub-package, 0 otherwise |
| billing_code | varchar | |
| billing_code_type | varchar | |
| average_units | decimal(21,3) | Average units for this billing code from SSP data |
| anesthesia_unit_conversion | decimal(21,3) | Unit conversion factor for anesthesia codes (0.067 for anesthesia, 1 otherwise) |
| billing_code_description | varchar | |
| validated_rate | boolean | Rate has canonical_rate_score = 5 |
| state_avg_negotiated_rate_used | boolean | Geographic backfill was used for negotiated rate |
| state_avg_discounted_cash_rate_used | boolean | Geographic backfill was used for cash rate |
| negotiated_rate | decimal(21,3) | |
| discounted_cash_rate | decimal(21,3) | |
| cbsa_avg_medicare_rate | decimal(21,3) | |
| lower_bound | decimal(21,3) | Clear Rates outlier bound |
| upper_bound | decimal(21,3) | Clear Rates outlier bound |
| contract_methodology | varchar | |
| gross_charge | decimal(21,3) | |
| source | varchar | hospital, payer, or imputation |
| validated_subpackage | boolean | Sub-package's base code (facility, or professional if an Imaging Center) has a plausible negotiated rate (> 1) |
| price | decimal(21,3) | Line-item price (negotiated_rate × average_units × anesthesia_unit_conversion); NULL for non-base-code facility lines |
| allocation | decimal(21,3) | Share (0-1) of the case rate attributed to this facility line item, based on its relative cost vs. other billing codes in the sub-package; renormalized within each payer/network/provider/sub-package so allocations always sum to 1. Always 1 for professional rows. |
| allocated_price | decimal(21,3) | Case rate × allocation for facility line items, so SUM(allocated_price) across a sub-package's facility lines equals the case rate. NULL for professional rows — use price instead. |