PROV_KEYWORD_INDEX
Description:
Index of providers who appeared in the Cost Calculator search and which keyword Search Terms applied to each at the time of the search.

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 SRCH_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.