IB_MESSAGE_PAT_ENC

Description:

This table holds related patient contacts for the In Basket message record. This table is intended to replace IB_MESSAGES_2__EPT_CSN_ID because this table can store multiple encounters per message. Typically, this table will only have one line per message because most In Basket message records only have a singular contact associated, if any.

Primary Key

Column Name	Ordinal Position
MSG_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	MSG_ID	VARCHAR	No
	The unique identifier for the task record.
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	PAT_ENC_CSN_ID	NUMERIC	No
	The unique contact serial number for the patient encounter related to the In Basket message.