REC_LINK_AUDIT_ASN

Description: |
This table contains the appointment serial number 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 appointment serial numbers that are associated with the recommendation and the workflow from the REC_LINK_AUDIT_TRL table.
4 | AUD_APPT_SERIAL_NO | NUMERIC | No |
The appointment serial number for the recommendation audit trail entry.