DENTAL_PROC_MODIFIERS_HX

Description: |
This table extracts the history of changes to a dental procedure's modifiers.

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 (.1 item) for the finding record.
2 | GROUP_LINE | INTEGER | No |
The line number of the associated procedure modifier edit history in the dental procedure record. Together with FINDING_ID, this forms the foreign key to the DENTAL_PROCEDURE_HX table.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the procedure modifier histories associated with the dental procedure from the DENTAL_PROCEDURE_HX table.
4 | DENTAL_PROC_HX_MODIFIER_ID | VARCHAR | No |
This item contains the history of procedure modifiers associated with a dental procedure. These procedure modifiers allow users to add additional details to their dental procedures.
5 | DENTAL_PROC_HX_MODIFIER_ID_MODIFIER_NAME | VARCHAR | No |
The name of the modifier record.