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 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 Patient Coverage Linking Payer Coverage Finder - Foreground Claim Status - Foreground Claim Status - Background 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 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
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.