IB_MESSAGES_5

Description: |
The IB_MESSAGES_5 table contains basic information about in Basket messages.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
MSG_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | MSG_ID | VARCHAR | No |
The unique identifier (.1 item) for the in basket message record.
2 | RESULT_TREND_C_NAME | VARCHAR | No |
Summarized result trend for the message.
May contain organization-specific values: No
Category Entries:
Stable
Not Stable
3 | RSH_RECRUIT_MSG_SOURCE_C_NAME | VARCHAR | No |
The message source category ID for the message. This may be set for messages with a message type (I EOW 30) of Research Recruitment.
May contain organization-specific values: No
Category Entries:
MyChart Request Response (Positive)
MyChart Request Response (Negative)
OurPractice Advisory
MyChart Study Finder
Public-Facing Study Webpage
4 | APPEAL_GRV_ID | NUMERIC | No |
The Appeal or Grievance record that triggered this In Basket message
5 | SUBJECT_UTF | VARCHAR | No |
Short description of the message contents in UTF.
6 | COVERAGE_ID | NUMERIC | No |
Stores coverage record that is related to the inbasket message
7 | ORIGINAL_EXPIRING_ORDER_ID | NUMERIC | No |
Order ID of the original order that generated the expiring order message.