Skip to main content

Pricing Service Rates

ColumnType
network_provider_sub_package_idbigint
network_provider_ssp_idbigint
idbigint
roidbigint
ssp_idvarchar
ssp_namevarchar
sub_package_idvarchar
payer_idvarchar
payer_namevarchar
network_idbigint
network_namevarchar
provider_idvarchar
provider_typevarchar
npiarray(varchar)
statevarchar
cbsavarchar
cbsa_namevarchar
fee_typevarchar
is_package_base_codeinteger
billing_codevarchar
billing_code_typevarchar
average_unitsdecimal(21,3)
anesthesia_unit_conversiondecimal(21,3)
billing_code_descriptionvarchar
validated_rateboolean
validated_prof_fee_rateboolean
claims_validated_rateboolean
commercial_validated_reimbursement_rateboolean
commercial_validated_cash_rateboolean
state_avg_negotiated_rate_usedboolean
state_avg_discounted_cash_rate_usedboolean
negotiated_ratedouble
discounted_cash_ratedouble
state_avg_medicare_ratedouble
lower_bounddouble
upper_bounddouble
contract_methodologyvarchar
gross_chargedouble
sourcevarchar
hosp_payer_idinteger
plan_aliasvarchar
validated_subpackageboolean
pricedouble
allocationdecimal(13,3)
allocated_pricedouble