IB_MESSAGES_3
Description:
The IB_MESSAGES_3 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 for the task record.
2 CHART_CORR_ID NUMERIC No
The Unique Chart Correction record ID associated with this In Basket message.
3 FAX_RECV_SMT_ID NUMERIC No
The unique ID of the submitter record that is associated with this record for failed fax messages.
4 FAX_RECV_SMT_ID_RECORD_NAME VARCHAR No
The name of the submitter record.
5 FAX_RECV_PT_RQG_ID NUMERIC No
The unique ID of the requisition grouper record that is associated with this record for failed fax messages.
6 COMMUNICATION_CSN NUMERIC No
This is the contact serial number (CSN) of the linked communication.
7 CE_NOTIFICATN_TYP_C_NAME VARCHAR No
Event Notification Type
May contain organization-specific values: No
Category Entries:
Ambulatory Encounter
Patient Discharged
Patient Arrived at ED
Hospital Outpatient Visit
Patient Admission
Patient Dismissed from ED
Patient Discharged from ED
Emergency
General
Other
8 CVG_ID NUMERIC No
This item will be used to store the coverage ID for which a member's coverage-level PCP has been added.
9 CONTRIBUTE_TO_RESULTNOTE_YN VARCHAR No
Indicates whether a message contributed to a result note
May contain organization-specific values: No
Category Entries:
No
Yes
10 PAT_REM_LIST_ID VARCHAR No
This associates a Patient Reminder with a Patient Reminder List.
11 REPLY_TO_MSG_ID VARCHAR No
The unique ID associated with the message this message was a reply to.
12 PARENT_MSG_ID VARCHAR No
The unique ID of the parent In Basket message for this row. If the message for this row was not generated by a different message, this column will be null.
13 QUESTIONNAIRE_FORM_ID VARCHAR No
Stores questionnaire for initiate calls message
14 QUESTIONNAIRE_FORM_ID_FORM_NAME VARCHAR No
The name of the form associated with the questionnaire.
15 REASON_FOR_CALL_RFV_ID NUMERIC No
Stores reason for call attached to in basket message.
16 REFILL_ERROR_TYPE_C_NAME VARCHAR No
The type of e-prescribing interface error for refill request
May contain organization-specific values: No
Category Entries:
Patient not found
Duplicate Patient found
Medication not found
Provider not found
Other
17 ABN_NOTE_ID VARCHAR No
Stores the linked ABN for which this In Basket message was generated.