DOCS_RCVD_ACT_AUD

Description:

This table contains data on actions that a user took on a direct message. For example, information about linking messages to patients, routing and creating referrals are all discretely audited in this table.

Primary Key

Column Name	Ordinal Position
DOCUMENT_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	DOCUMENT_ID	NUMERIC	No
	This item stores the Received Document record ID.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	MSG_ACT_C_NAME	VARCHAR	No
	Contains granular actions that were performed on a Provide and Register message (or incoming group of external documents). Such actions may include how the patient was linked to the message, routing, and referral creation that occurred. These actions are shown to the user on an audit trail on the Incoming Messages Report or the International Review Report. May contain organization-specific values: No Category Entries: Received Pended Manually linked to patient Automatically linked to matching patient Created patient Automatically routed to In Basket Manually routed to In Basket Manually created a referral Automatically created a referral Rejected Processed Routing to In Basket Released Documents No patient match No routing needed No referral needed In Basket routing failure Reply sent Reply received External encounter linked to originating referral Automatically created patient Automatically linked due to known referral Conversation reviewed Encounter invalidated Linked patient does not match source referral patient Message comment added Message received to place external order Message received to update external order Message received to cancel external order External order message timed out External order message resubmitted Resolved associated external chart correction notice Routing decision reset Referral decision reset Source Patient Id discarded Automatically linked due to matching external patient ID Share Everywhere Message Deleted Message received to create/update external encounter for billing Message received to cancel external encounter for billing External billing message timed out External billing message resubmitted User specified a service area for Incoming Message
6	MSG_ACT_CMT	VARCHAR	No
	Contains comments for actions that were performed on a Provide and Register message (or incoming group of external documents). Such actions may include how the patient was linked to the message, routing, and referral creation that occurred. These actions are shown to the user on an audit trail on the Incoming Messages Report or the International Review Report. Comments can be user entered or hard coded.
7	MSG_ACT_UTC_DTTM	DATETIME (UTC)	No
	Contains the time of actions that were performed on a Provide and Register message (or incoming group of external documents). Such actions may include how the patient was linked to the message, routing, and referral creation that occurred. These actions are shown to the user on an audit trail on the Incoming Messages Report or the International Review Report.
8	MSG_ACT_EXTERNAL_ORDER_UID	VARCHAR	No
	This item contains the identifier of an external order associated with an event such as receiving an interface message to place an order, to update an order, or to cancel an order.