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
Inpatient Discharge
Patient Arrived at ED/Obs
Hospital Outpatient Visit
Inpatient Admission
Patient Dismissed from ED
Patient Discharged from ED/Obs
Emergency
General
Surgery Complete
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_LIST_DESCRIPTION | VARCHAR | No |
Description of the patient 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_REASON_VISIT_NAME | VARCHAR | No |
The name of the Reason for Visit record.
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.