IB_MESSAGES_2

Description: |
The IB_MESSAGES_2 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 task record.
2 | CCR_NOTE_ID | VARCHAR | No |
This is the note ID for a coding query message.
3 | ORDER_DAT | NUMERIC | No |
This column stores the contact date (DAT) of the order record linked to the message.
4 | ATTCHD_NOTE_REC_ID | VARCHAR | No |
Stores the note record attached to this message.
5 | NOTIF_SEND_TO_C_NAME | VARCHAR | No |
Stores the Send To Information for the Notification
May contain organization-specific values: No
Category Entries:
Patient
Referred By Provider
Referred To Provider
Referred To Vendor
PCP
Other
Vendor
Provider
Subscriber of Coverage
Payer of Coverage
Referred By Location/POS
Referred To Location/POS
Referring Physician
Pool
Distribution Scheme
CRM Creator
CRM Current Recipients
CRM Task Owners
Admitting Provider
Attending Provider
Treatment Team
Current PCP
Primary Transporter
Secondary Transporter
Transport Manager
Transport Sending Unit
Transport Receiving Unit
MC Coverage PCP
MC Coverage Current PCP
Referred To Department
Referred To Specialty
Care Team
IP Sign In - Sending Unit User
IP Sign In - Receiving Unit User
IP Sign In - Current Unit User
Bed Planning IB Pager - Sending Unit
Bed Planning IB Pager - Receiving Unit
Emergency Contacts
Bed Request Admitting Provider
Bed Request Attending Provider
Billing Account
CC Receiver
Information Requester
Referred By Department
Transfer Center Request Owner
ADT Visit Contacts
Technician
Supervisor
Inspector
Manager
Start Location Unit Pager
End Location Unit Pager
Other Technicians
All Qualified Techs In Sector
Primary Qualified Techs In Sector
Authorized Representative
User Group Referred By Location
User Group Referred To Location
User Group Referred By Provider
User Group Referred To Provider
Operating Provider
Other Provider
Rendering Provider
Supervising Provider
Review Entity
Agency
Requesting Provider
Unified Communications Group - Sending Unit/Location
Unified Communications Group - Receiving Unit/Location
Unified Communications Group - Current Unit/Location
Unified Communications Group - Specific Group
Attached Chat Conversations
User Group Requesting Provider
Requesting Place of Service
Follow-Up Providers
Follow-Up Locations
Trading Partner
Subscribed Payer
Admitting Hospital UR Department
Prior Admission Last Attending Provider
Prior Admission Discharge Provider
Prior Admission Treatment Team
Provider Assigned to Bed
Nurse Assigned to Bed
Referred To Subspecialty
Referred For Treatment
Referred For Condition
First Contact
Appointment Staff
Patient Care Organizations
6 | NOTIF_PCP_TYPE_C_NAME | VARCHAR | No |
Stores the PCP type if send to is set to PCP for Notifications
May contain organization-specific values: Yes
Category Entries:
General
7 | NOTIF_NOTE_TYPE_C_NAME | VARCHAR | No |
Stores the note type for the Notification
May contain organization-specific values: Yes
Category Entries:
General
Phone Message
Letter
Message
Telephone Encounter
Provider Comments
RTF Letter
Routing Comments
Specialty Comments
Charting Text
MyChart Message
Eligibility Message
Criteria Review
AP Claim Code Edit
Patient Flag
Nurse Triage Message
Dental Soft Tissue Note
ABN INFORMATION
Progress Note
Nursing Note
Consult/Results - Findings
Consult/Results - Impression
Consult/Results - Recommendations/Plans
Chart Sync Patient Summary Report
Chart Sync Admission Summary Report
H&P Note
Procedure Note
Communication Body
Anesthesia
Department Message
Assessment & Plan Note
Problem Overview
Subjective & Objective
Care Coordination
Home Care Admit
Home Care Non-Admit
CTI Order
Bookmark
Hospice Discharge Remarks
Charge Homing Guarantor Inquiry
Patient Genomic Indicator Overview Note
Home Health Face to Face Attestation
Hospice Face to Face Attestation
Sticky Note
Coding Query
Address Verification Message
Intake Communication
Pharmacy Enrollment Note
Treatment Note
Patient Instructions
Discharge Attachment
Previous Reports
Date-Specific Sticky Note
PA Denial Reason
Result Order Report
Home Care Intervention
Home Health Plan of Care Header
Dermatology Finding Description
Specimen Tracking Comments
Radiology Study Results
Translation
Auth/Cert Update
Phenotype Comment
VECOZO Authorization Update
OR Instructions
Dermatology Skin Cancer History
In Basket Conversation
Incoming Message Pend Notes
Xtenity Patient Portal Message
Outside Organization Note
Outside Organization Update
Outside Organization Document
Cosign with Attestation Text
Simple Med Note
Medication History
Electronic Authorization Information
History Overview
ED Disposition Edit Trail
Lab
Intervention Data from External System
Event Note
Treatment Summary
Rehabilitation Potential
Discharge Plans
History Event Details
Referral Transaction Record
Happy Together Result Transcription
Group Note
Care Advice Text
Infection Case
Prior Auth Decision Note
Clinical Note Summary
Transplant
Organ
Reg History Event
Interfaced Result
Outside Organization Coverage Information
8 | NOTIF_JOB_TYPE_C_NAME | VARCHAR | No |
Stores the Job Type in the Batch Print Utility for the Notification
May contain organization-specific values: Yes
Category Entries:
All
9 | CAS_CREAT_SRC_TYP_C_NAME | VARCHAR | No |
Case create source type.
May contain organization-specific values: No
Category Entries:
Referral
Claim
Order
10 | SORT_ORDER | VARCHAR | No |
Additional Sort order.
11 | OR_CASE_ID | VARCHAR | No |
The unique ID associated with the case record for In Basket messages of type case. This column is frequently used to link to the OR_CASE table.
12 | OR_CASE_ACTION_C_NAME | VARCHAR | No |
The category number representing the reason for the In Basket messages of type case.
May contain organization-specific values: Yes
Category Entries:
Approved
Denied
Request More Info
Moved
Removed
Canceled
Scheduled
Potential Procedure Mismatch Detected
13 | OR_LOG_ID | VARCHAR | No |
The unique ID associated with the log record for In Basket messages of type log. This column is frequently used to link to the OR_LOG table.
14 | OR_LOG_ACTION_C_NAME | VARCHAR | No |
The category number representing the reason for the In Basket messages of type log.
May contain organization-specific values: Yes
Category Entries:
Documentation Complete
Request More Info
15 | EPT_CSN_ID | NUMERIC | No |
The contact serial number (CSN) for a patient contact associated with the In Basket message. This column should be replaced with IB_MESSAGE_PAT_ENCS.PAT_ENC_CSN_ID instead. Historical records will still use this column, but all new data will populate the other table and column. This will still be populated but may not contain the full set of data available in the other column and table.
16 | LINKED_EPISODE_ID | NUMERIC | No |
This column store the episode of care record ID of a linked episode.
17 | GEN_OVERDUE_MSG_ID | VARCHAR | No |
Stores the original message of an overdue message.