MYC_WMG_AUDIT

Description:

This table contains audit trail items that store information about a message related to the message viewers functionality.

Primary Key

Column Name	Ordinal Position
MESSAGE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	MESSAGE_ID	VARCHAR	No
	The unique ID used to identify a web-based chart system message record. A new record is created each time a patient sends a message from a web-based chart system to a system user and each time a system user sends a message to a web-based chart system patient.
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	WMG_AUD_EVENT_INST	DATETIME (Attached)	No
	Contains the instant of the audit trail entry in local time.
4	WMG_AUD_VIEWER_ID	VARCHAR	No
	MyChart ID of the person associated with this audit item
5	WMG_AUD_LOCATION_C_NAME	VARCHAR	No
	This is the new location of the message May contain organization-specific values: No Category Entries: Inbox Sent Messages Trash Can Bedside Conversation
6	WMG_AUD_STATUS_C_NAME	VARCHAR	No
	This is the status (ie: read, unread) of the message May contain organization-specific values: No Category Entries: Read Unread