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.