This table stores the source treatment options for an estimate. When clinical information is updated on the estimate, then these treatment options will be included in the updated estimate. Treatments that don't have a source option will pull information from its selected option.
Primary Key
Column Name
Ordinal Position
ESTIMATE_ID
1
LINE
2
Column Information
Name
Type
Discontinued?
1
ESTIMATE_ID
NUMERIC
No
The unique identifier 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
TREATMENT_PLAN_ID
NUMERIC
No
The list of source treatment option records that estimates should be updated with. When estimates are updated, information from these options will be used rather than the selected options of treatments. If additional treatments are included in the estimates, then the selected option of those treatments will be used.