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.