IB_MESSAGES

Description: |
The IB_MESSAGES 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 ID of the In Basket Message.
2 | CREATE_TIME | DATETIME (Local) | No |
The time the message record was created.
3 | REGARDING_TOPIC | VARCHAR | No |
A short description of the message contents.
4 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
5 | PAT_ENC_DATE_REAL | FLOAT | No |
The encounter date of the patient associated with this message.
6 | SENDER_USER_ID | VARCHAR | No |
The unique ID of the sender (networked to the User master file).
7 | SENDER_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
8 | NAME_OF_CALLER | VARCHAR | No |
The name of the caller.
9 | TRANSCRIPTION_LINE | VARCHAR | No |
This is the ID of the dictation transcription for a transcription created outside of Epic and sent to In Basket through an interface. It is networked to the Notes (HNO) master file.
10 | ORDER_PROC_ID | NUMERIC | No |
The unique ID of the order procedure (networked to the Orders master file).
11 | ORDER_MED_ID | NUMERIC | No |
The unique ID of the order procedure (networked to the Orders master file).
12 | ORD_DATE_REAL | FLOAT | No |
The internal date of the ordered procedure.
13 | PAT_EMAIL_RESP_YN | VARCHAR | No |
Indicates if the patient wants an e-mail response to their In Basket message. Y indicates that the patient does want an e-mail response and N indicates that the patient does not want an e-mail response.
May contain organization-specific values: No
Category Entries:
YES
NO
14 | APPT_STATUS_C | INTEGER | No |
Appointment Notification Email Message Type - The Appointment Status of the specific encounter
15 | CANCEL_REASON_C | INTEGER | No |
Appointment Notification Email Message Type - If the APPT_STATUS_C column is canceled, this column contains the link to the reason for cancellation
16 | PAT_ENC_CSN_ID | NUMERIC | No |
A unique serial number for this encounter. This number is unique across all patients and encounters in the system. This column should be replaced with IB_MESSAGE_PAT_ENCS.PAT_ENC_CSN_ID instead. Historical records will still have this data populated, as well as data moving forward, but it may not contain all of the encounter contact serial numbers (CSNs) as the new column and table would
17 | PAT_ORDENC_DT_REAL | FLOAT | No |
The new orders only encounter associated with this message. This will be used if a reflex action is performed on a result and the original contact is owned elsewhere.
18 | DICT_HNO_ID | VARCHAR | No |
This is the ID of the dictation transcription for a dictation transcribed in Epic (not in a third party system). It is networked to the notes (HNO) master file.
19 | TASK_ID_ID | VARCHAR | No |
Stores the task ID this message is associated with
20 | REFERRAL_ID | NUMERIC | No |
Stores referral record that is related to the In Basket message
21 | CLAIM_ID | NUMERIC | No |
Stores claim record that is related to the In Basket message
22 | ORGANIZATION_ID | NUMERIC | No |
Stores the Care Everywhere organization related to this message
23 | ORGANIZATION_ID_EXTERNAL_NAME | VARCHAR | No |
Organization's external name used as the display name on forms and user interfaces.
24 | QUERY_OUTCOME_C_NAME | VARCHAR | No |
Outcome of the Care Everywhere search.
May contain organization-specific values: No
Category Entries:
Successful
Unsuccessful
25 | QUERY_INSTANT | DATETIME (Attached) | No |
Instant the query was performed
26 | QUERY_USER_NAME | VARCHAR | No |
User who performed the query
27 | QUERY_ENC | VARCHAR | No |
Encounter associated with the query
28 | QUERY_ENC_PROV | VARCHAR | No |
Provider for the encounter associated with the query
29 | QUERY_DEPT | VARCHAR | No |
Login department for the user performing the query
30 | QUERY_REASON_C_NAME | VARCHAR | No |
Reason for performing the query
May contain organization-specific values: No
Category Entries:
Other
Automatic System Request
PCP Review
Unknown
Emergency Visit
Referral
Scheduled Visit
Urgent Care
Walk In
Admission
Phone / E-mail Encounter
Care Coordination
Background Batch Request
Background Verification Query
Data Request
Chart Gateway Batch Query
Chart Gateway Targeted Query
Patient Portal Initiated
Chart Correction
Chart Gateway Link Forwarded Query
Switch from Standalone to Gateway
Automatic Request to Repair Link
Orders Anywhere Query
Prior Authorization
Payer Platform ADT
Payer Platform Update Notification
Payer Platform Scheduled Appointment
Network Affiliation
Patient Newly Enabled
Book Anywhere
Payer Coverage Finder
Payer Platform Prep Data
Automatic Query to Payer Before Appointment
Reference Claim Link
Payer Platform Member Estimates
Life Sciences Study Enrollment
Member Coverage Linking - Provider Backfill
Payer Coverage Finder - Foreground
Claim Status - Foreground
Claim Status - Background
Professional Billing Exchange
Member Coverage Linking - Payer Backfill
Member Coverage Linking - Patient Event
EUME Query High Priority
EUME Query Low Priority
Request Outside Records Activity
Concurrent Authorization
Express Claim - Foreground
Express Claim - Background
Result Backfill
Backfill Utility Query
Attribution Dispute Query
Treatment
Payment
Healthcare Operations
System Administration
Fraud Detection
Psychotherapy
Training
Legal Disclosure
Marketing
Facility Directory
Family Disclosure
Individual Present Disclosure
Emergency
Disaster Relief
Public Health
Abuse Disclosure
Health Oversight Disclosure
Judicial Disclosure
Law Enforcement Disclosure
Deceased Disclosure
Organ Donation Disclosure
Research Disclosure
Health Safety Threat
Government Disclosure
Workers Compensation
Insurance or Disability Coverage Disclosure
Request of the Individual
31 | QUERY_PAT_NAME | VARCHAR | No |
Patient name used for the query
32 | QUERY_PAT_STATE | VARCHAR | No |
State used for the patient query
33 | QUERY_PAT_ZIP | VARCHAR | No |
Zip code used for the patient query
34 | QUERY_PAT_SEX_C_NAME | VARCHAR | No |
Sex used during the patient query
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Nonbinary
X
Other
35 | QUERY_PAT_DOB_DT | DATETIME | No |
Date of birth used for the patient query
36 | QUERY_PAT_SSN | VARCHAR | No |
SSN used for the patient query
37 | QUERY_PAT_HOME_PH | VARCHAR | No |
Home phone number used for the patient query
38 | QUERY_PAT_WORK_PH | VARCHAR | No |
Work phone number used during the patient query
39 | QUERY_PAT_CELL_PH | VARCHAR | No |
Cell phone number used during the patient query
40 | MYCHART_HNO_ID | VARCHAR | No |
Note ID for a message that is a result of a 3rd party questionnaire being submitted.
41 | PEF_MSG_TYP_C_NAME | VARCHAR | No |
Type of a patient-entered flowsheet message, either Alert or Notification.
May contain organization-specific values: No
Category Entries:
Notification Message
Alert Message
42 | PEF_EPISODE_ID | NUMERIC | No |
For patient-entered flowsheet messages, the episode ID that the flowsheet is a part of.
43 | PEF_LAST_NOTIF_DAT | DATETIME | No |
Last notification date of a patient-entered flowsheet message.
44 | PEF_INSTANT_SVD_TM | DATETIME (Local) | No |
For patient-entered flowsheet messages, the date and time the patient entered the data that triggered this message.
45 | NCS_ID | NUMERIC | No |
This column extracts the linked Customer Relationship Management record (NCS master file).
46 | DENTAL_TRT_PLAN_ID | VARCHAR | No |
Stores dental treatment plan ID.
47 | DTP_PMT_PLAN_LINE | INTEGER | No |
Stores orthodontic payment plan line.
48 | DEFICIENCY_TYPE_C_NAME | VARCHAR | No |
The deficiency type category number for the In Basket message.
May contain organization-specific values: Yes
Category Entries:
Surgery Report
Admission Diagnosis
Discharge Summary
Anesthesiology Report
Transfer Report
Result
Image
Verbal/Cosign Order
Initial Assessment
Work List Task
H&P
Dictation
Consult
HB Final Diagnosis
Pre-Op Diagnosis
Discharge Diagnosis
Medications Not Administered
DRG Code
ICD Codes
CPT/HCPCS Codes
Post-Op Diagnosis
OR Nursing Report
Pre-Op Notes
Post-Op Notes
Progress Notes
Procedures
ED Notes
General Notes
Document
ED Navigator Data
ED Disposition
ED Chief Complaint
ED Clinical Impression
Coding/CDI Query
Processing Needed
ED Provider Notes
Scan Signature
Open Encounter
Clinic Transcription
ED Events
Flowsheet
ED Allergies Reviewed
Medications Reviewed
Medication List Status
History Reviewed
Narrator Sign Off
Problem List - Present on Admission
Incomplete Note
Patient Learning Assessment
Analysis Needed
Gallery Document Signature
Problem List - Additional Dx Data
Problem List - Specialty Episode Linkage
Any Note
ED Triage Notes
ED DBC Clinical Episode Link
Verbal Treatment Plan
Preliminary Cause of Death
Study Review
HH Encounter OASIS and POC Integration
HH Order
HH Encounter OASIS Integration
HH Attestation
HH Encounter No Integration
Home Care Supervisory Visit
Home Care Pended Orders
Hospice Non-Covered Documentation
HH Specialty Plan of Care - Manually Created
HH EVV Encounter
HH OASIS Item Issue
HH Care Plan Issue
HH Visit Set Issue
HH Medication Issue
HH Other Issue
Specialty Plan of Care - Signature
Specialty Plan of Care - Contribution
HH High Visit Set Orders
Encounter Cosign
AN Ready for Procedure
AN Attestation
AN Event
AN Staff
AN Preprocedure Note
AN Postprocedure Note
AN Close Encounter Check Failed
DBC Info Reviewed
AN Procedure Note
ED Course Review Needed
ED Course SmartLink Missing
Ready to View
AN Blood
Chart Correction Task
Informed Consent
49 | TRANSCRIPT_NOTE_ID | VARCHAR | No |
The unique ID of the note that this In Basket deficiency creation error occurred for.
50 | LAB_RESULT_ID | VARCHAR | No |
The unique ID of the result record of the In Basket message.
51 | LAB_HOLD_LN | INTEGER | No |
The line number of the hold of the specimen associated with this In Basket message.
52 | LAB_REQ_ID | NUMERIC | No |
Stores a pointer to a requisition record (REQ). The REQ record may be a requisition, a case, or both.
53 | LAB_AP_CASE_NUM | VARCHAR | No |
The case number is the Anatomic Pathology accession number.
54 | AN_MSG_REASON_C_NAME | VARCHAR | No |
The reason the message was sent from Anesthesia.
May contain organization-specific values: Yes
Category Entries:
Need Relief
55 | FREE_TEXT_SIG | VARCHAR | No |
Free text sig received from a pharmacy interface.