PR_EST_SEARCH_PARAMS

Description:

Contains information about an audited search run in Cost Calculator.

Primary Key

Column Name	Ordinal Position
ESTIMATE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ESTIMATE_ID	NUMERIC	No
	The unique identifier (.1 item) for the patient estimate record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	SEARCH_RESULTS_CNT	INTEGER	No
	A numeric item for holding the number for successful results found in a Cost Calculator search.
4	SEARCH_RANGE	INTEGER	No
	The range in miles that the user searched from their starting zip code.
5	SEARCH_ZIP	VARCHAR	No
	The zip code that was used to search for providers.
6	SEARCH_LATITUDE	NUMERIC	No
	The latitude value of the search from Cost Calculator.
7	SEARCH_LONGITUDE	NUMERIC	No
	The longitude value of the search from Cost Calculator.
8	MIN_PRICE	NUMERIC	No
	The lowest price found for the related search parameters.
9	MAX_PRICE	NUMERIC	No
	The highest price found for the related search parameters.