DENT_PROC_HX_ALT_EST_DFLT

Description: |
This table returns history data regarding whether or not a procedure's alternate choices would be defaulted onto an estimate.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
FINDING_ID | 1 |
GROUP_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | FINDING_ID | NUMERIC | No |
The unique identifier for the finding record
2 | GROUP_LINE | INTEGER | No |
The line number of the historical instant in the procedure record. Together with FINDING_ID, this forms the foreign key to the DENTAL_PROC_HX table.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple Yes/No values, representing whether procedure alternatives default on an estimate, associated with the procedure record and the historical instant from the DENTAL_PROC_HX table.
4 | DENT_ALT_DFLT_HX_YN | VARCHAR | No |
History of values that indicate whether or not a given procedure alternative should be included on an estimate by default
May contain organization-specific values: No
Category Entries:
No
Yes