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.