| 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 |
| validated_prof_fee_rate | boolean | |
| claims_validated_rate | boolean | |
| commercial_validated_reimbursement_rate | boolean | |
| commercial_validated_cash_rate | boolean | |
| 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) | |
| state_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 |
| hosp_payer_id | integer | Legacy Hospital MRF payer ID |
| plan_alias | varchar | Network Name Representation on Consumer App |
| validated_subpackage | boolean | Sub-package has at least one validated base code |
| price | decimal(21,3) | Line-item price (negotiated_rate × average_units × anesthesia_unit_conversion) |
| allocation | decimal(21,3) | Allocation factor for non-base facility codes (for cost share) |
| allocated_price | decimal(21,3) | Price after allocation factor applied |