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.