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