MESSAGE_METADATA
Description:
Stores message metadata for MedCom messages.

Primary Key
Column Name Ordinal Position
COMMUNICATION_ID 1

Column Information
Name Type Discontinued?
1 COMMUNICATION_ID NUMERIC No
The unique identifier (.1 item) for the routing record.
2 MESSAGE_CAT_LETTER_REASON_C_NAME VARCHAR No
Stores the Category for the message.
May contain organization-specific values: Yes
3 MESSAGE_SUBJECT_C_NAME VARCHAR No
The message subject stored as a discrete option.
May contain organization-specific values: Yes
No Entries Defined
4 MESSAGE_SUBJECT_STR VARCHAR No
The message's subject, stored as a free-text entry