transparency_negotiated_price

The attributes attached to a negotiated price other than the amount itself. Deduplicated within a file, where a few hundred distinct combinations cover millions of prices.

Primary Key:

• transparency_file_id
• negotiated_price_id

Foreign Keys:

• transparency_file_id => transparency_file.transparency_file_id

Column	Data Type	Nullable	Indexed	Description
transparency_file_id	bigint	No	Yes	Link to the file this price came from. Price IDs are only unique within a file.
negotiated_price_id	integer	No	Yes	Assigned by the loader per file while deduplicating
billing_class	transparency_billing_class_type	No	No	Whether the price applies to professional or institutional billing
setting	text	Yes	No	Where the service is delivered, for example inpatient, outpatient, or both
negotiated_type	transparency_negotiated_type	No	No	How to read the negotiated rate, whether it is an amount, a percentage, or a payer's estimate
expiration_date	date	Yes	No	When the rate stops applying. Payers use 9999-12-31 to mean open ended.
service_code	text[]	Yes	No	Place of service codes the price applies to, for example 11 for an office
billing_code_modifier	text[]	Yes	No	Modifiers that must accompany the billing code for this price to apply
additional_information	text	Yes	No	Free text the payer adds when the other fields cannot express the arrangement