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.