network_provider_sub_package_id | bigint |
network_provider_ssp_id | bigint |
id | bigint |
roid | bigint |
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 |
npi | array(varchar) |
state | varchar |
cbsa | varchar |
cbsa_name | varchar |
fee_type | varchar |
is_package_base_code | integer |
billing_code | varchar |
billing_code_type | varchar |
average_units | decimal(21,3) |
anesthesia_unit_conversion | decimal(21,3) |
billing_code_description | varchar |
validated_rate | boolean |
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 |
state_avg_discounted_cash_rate_used | boolean |
negotiated_rate | double |
discounted_cash_rate | double |
state_avg_medicare_rate | double |
lower_bound | double |
upper_bound | double |
contract_methodology | varchar |
gross_charge | double |
source | varchar |
hosp_payer_id | integer |
plan_alias | varchar |
validated_subpackage | boolean |
price | double |
allocation | decimal(13,3) |
allocated_price | double |