MYC_MESG_VIEWERS

Description:

This table contains the viewers that may see a message, as well as information about the message as it pertains to each viewer, such as the location, like Inbox or Sent, and status, like read or unread. Viewers are defined by Patient Access Accounts (WPR) records.

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	VIEWER_WPR_ID	VARCHAR	No
	This is the ID of the MyChart user who may view the message
4	MSG_LOCATION_C_NAME	VARCHAR	No
	This indicates the location of the message for the particular viewer May contain organization-specific values: No Category Entries: Inbox Sent Messages Trash Can Bedside Conversation
5	MSG_STATUS_C_NAME	VARCHAR	No
	This indicates the status of the message for a particular viewer. May contain organization-specific values: No Category Entries: Read Unread