transparency_in_network_negotiated_rate

A negotiated rate for a billing code, applying to every provider in a provider set. This table is large, so it holds nothing but the rate and the keys needed to interpret it.

Primary Key:

• transparency_file_id
• in_network_id
• negotiated_price_id
• provider_set_id
• negotiated_rate

Foreign Keys:

• transparency_file_id => transparency_in_network.transparency_file_id, in_network_id => transparency_in_network.in_network_id
• transparency_file_id => transparency_negotiated_price.transparency_file_id, negotiated_price_id => transparency_negotiated_price.negotiated_price_id

Indexes:

• transparency_in_network_negotiated_rate_in_network_idx - transparency_file_id, in_network_id
• transparency_in_network_negotiated_rate_negotiated_price_idx - transparency_file_id, negotiated_price_id

Column	Data Type	Nullable	Indexed	Description
transparency_file_id	bigint	No	Yes	Link to the file this rate came from. Every other ID here is only unique within a file.
in_network_id	integer	No	Yes	Link to the in_network entry the rate is for
negotiated_price_id	integer	No	Yes	Link to the attributes needed to interpret the rate, including whether it is an amount or a percentage
provider_set_id	integer	No	Yes	Link to the set of provider references the rate applies to
negotiated_rate	numeric	No	Yes	The rate, read according to the negotiated_type on the linked negotiated price