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 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 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 Patient Instructions Discharge Attachment Previous Reports 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 ANSI 278 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.