REC_LINK_AUDIT_TRL

Description: |
This table stores an audit trail of changes made to a recommendation's linking.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
FINDING_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | FINDING_ID | NUMERIC | No |
The unique ID of the recommendation record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | AUDIT_DATETIME | DATETIME (Local) | No |
The date and time when the recommendation link change was made.
4 | AUDIT_USER_ID | VARCHAR | No |
The unique ID of the user that made the change to the recommendation link.
5 | AUDIT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | AUDIT_WORKFLOW_C_NAME | VARCHAR | No |
The category number for the workflow that triggered the link changes.
May contain organization-specific values: No
Category Entries:
Interface
Track Recommendations
Open Recommendations
Appointment Scheduled
Appointment Canceled
Appointment Marked Incomplete
Appointment Status Edited
Order Entered
Order Changed
Order Canceled
Order Linked to Appointment
Order Unlinked from Appointment
Study Signed
Recommendation Updated
Order Released
Utility
Study Saved
Order No Longer Available for Scheduling
Related Order Linked