REC_LINK_AUDIT_DTL

Description: |
This table contains the item detail for a recommendation audit trail entry.

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 ID of the recommendation record.
2 | GROUP_LINE | INTEGER | No |
The line number of the associated workflow in this recommendation record. Together with FINDING_ID, this forms the foreign key to the REC_LINK_AUDIT_TRL.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple audit trail item details that are associated with the recommendation and the workflow from the REC_LINK_AUDIT_TRL table.
4 | AUDIT_ITEM_DETAIL | VARCHAR | No |
The detail that describes the appointment or order that was linked or unlinked in the recommendation audit trail entry.