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.
10	IS_TEST_RUN_YN	VARCHAR	No
	Yes if this cost calculator search was done with a pending template. No otherwise. May contain organization-specific values: No Category Entries: No Yes
11	FAIL_REASON_C_NAME	VARCHAR	No
	Why this Cost Calculator search failed to return any results. May contain organization-specific values: No Category Entries: No representative employer group No data for representative employer group No providers in range
12	NO_PRICE_ERROR_CNT	INTEGER	No
	How many Cost Calculator results were excluded from this search because we were unable to calculate an allowed amount.
13	BENEFITS_ERROR_CNT	INTEGER	No
	How many Cost Calculator search results were excluded from this search because benefits applied a pend code.