PR_EST_INFO_3
Description:
General information about the price estimate. Split from PR_EST_INFO.

Primary Key
Column Name Ordinal Position
ESTIMATE_ID 1

Column Information
Name Type Discontinued?
1 ESTIMATE_ID NUMERIC No
The unique identifier for the patient estimate record.
2 EST_USED_LOB_ID VARCHAR No
The line of business on the benefit plan that was effective for the employer group at the time the estimate was created. This item will not change and is used in reporting.
3 EST_USED_LOB_ID_LOB_NAME VARCHAR No
The name of the line of business record.
4 EST_USED_CARRIER_ID VARCHAR No
The carrier that was on the benefit plan that was effective for the employer group at the time the estimate was created. This item will not change and is used in reporting.
5 EST_USED_CARRIER_ID_CARRIER_NAME VARCHAR No
The name of the carrier record.