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
4 APPEAL_GRV_ID NUMERIC No
The Appeal or Grievance record that triggered this In Basket message