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
Automatically associated with existing referral
Attachments invalidated by data cleanup
Orders transcribed
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.