PR_EST_PRO_SVC_TYPE_MULT

Description: |
Service type ID of the professional charge for all applicable coverages in the price estimate. This table has data for dental estimates using multiple coverages only. Refer to the PROC_SVC_TYPE_ID column in PR_EST_PROFEE_PROC for other dental estimates.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ESTIMATE_ID | 1 |
PROC_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ESTIMATE_ID | NUMERIC | No |
The unique identifier for the patient estimate record.
2 | PROC_LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple values associated with a specific group of data within this record.
4 | PROC_SVC_TYPE_ID | VARCHAR | No |
The unique ID of the service type associated with the corresponding coverage (I PES 391). This is used to determine the benefits for the patient estimate.
5 | PROC_SVC_TYPE_ID_SERVICE_TYPE_NAME | VARCHAR | No |
The name of this benefit service type.