IB_MESSAGE_THREAD

Description:

Shows information regarding all messages in an HTH thread.

Primary Key

Column Name	Ordinal Position
THREAD_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	THREAD_ID	NUMERIC	No
	Unique message thread ID. A message thread is similar to a conversation in email - it is a series of messages related to the same patient encounter.
2	LINE	INTEGER	No
	The Line Count
3	MESSAGE_CID	NUMERIC	No
	In Basket Message (EOW) CID
4	MESSAGE_ID	VARCHAR	No
	In Basket Message (EOW) ID
5	ROUTING_COMMENT	VARCHAR	No
	Comments attached to the In Basket message being routed. This column will be automatically truncated at 4000 characters.
6	ATTACHED_NOTE_ID	VARCHAR	No
	Note attached to the In Basket message being routed.
7	SMART_ROUTE_SRC_MSG_ID	VARCHAR	No
	Cross-deployment permanent storage for the source message of a smart routing event.