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