EVENT_NOTIF_HX

Description:

The Event Notification History records notifications that were sent about a patient encounter.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ENC_CSN_ID	NUMERIC	No
	The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	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.
4	PAT_ENC_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
5	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
6	SENT_DTTM	DATETIME (UTC)	No
	This date/time when the notification was sent.
7	EVENT_TYPE_C_NAME	VARCHAR	No
	The event notification event type category number for the notification delivery. This indicates the type of event that triggered event notification. May contain organization-specific values: Yes Category Entries: Admission Discharge Transfer ED Arrival ED Dismissal L&D Assessment L&D Admission Newborn Admission Undo Admission Undo Discharge Undo Transfer Update Admission Update Discharge Update Transfer Preadmission Added Isolation Status Removed Isolation Status Insert Patient Update Update Patient Update Pending Event Created Bed Requested Ready to Plan Bed Request Assigned Bed Request Rejected Bed Request Approved Pending Event Updated HOV Confirm Pending Event Canceled Pending Event Completed Pending Event Restored Appointment Scheduled Appointment Signed In Appointment Checked In Appointment Checked Out Appointment Canceled Appointment Sign In Canceled Appointment Check In Canceled HOV Discharge Inpatient Admission Delivery Observation Admission After Merge ED Roomed Transport Request Put In Pending List Primary Transport Request Assigned Transport Request In Progress Primary Transport Request Completed Transport Request Delayed Primary Transport Request Canceled Transport Request Unassigned Secondary Transport Request Assigned Secondary Transport Request Completed Secondary Transport Request Canceled Transporter Request For Additional Help Transport Warning Escalation Transport Escalation Insert Transfer Transfer Failure - Patient Location Update Generated Primary Transport Request Acknowledged Secondary Transport Request Acknowledged Leave of Absence Return From Leave of Absence Undo Leave of Absence Undo Return From Leave of Absence Update Leave of Absence Update Return From Leave of Absence Convert Discharge to Leave of Absence Convert Leave of Absence to Discharge Bed Requested Bed Request Pre-assigned Bed Request Bed Ready Bed Request Requested Delay Bed Request Ready to Plan Delay Bed Request Pre-assigned Delay Bed Request Assigned Delay Bed Request Approved Delay Bed Request Rejected Delay Bed Request Bed Ready Delay Transport Request Linked Appointment Updated Transfer Failure - Transport Generated Discharge Failure - Transport Generated Provider Added to Treatment Team Provider Added As Attending Bed Request Ready to Move Bed Request Not Ready to Move Midnight Census Transport Ready to Move Transport Not Ready to Move Transport Bed Ready Transport Bed Not Ready Transport Source Location Changed Transport Destination Location Changed Discharge Failure - Patient Location Update Generated Transfer Canceled Discharge Time Delayed Discharge Canceled Patient No Longer Ready Other Patient No Longer Ready Bed Request Escalation Another Bed is Ready Dismiss Failure - Patient Location Update Generated ED Room Failure - Patient Location Update Generated Discharge Delay Added: Bed Planning Impacted Transfer Center Request Created Transfer Center Request Accepted Transfer Center Request Completed Transfer Center Request Canceled Transfer Center Request Patient Attached Undo Preadmission Order Reverted Bed Request Order Has Meaningful Bed Request Changes Order Was Discontinued Hold Bed Was Canceled Hold Bed Was Restored Bed Request Unassigned From Unit Case Tracking Event Transfer Failure - Patient Location Updated Logistics Request Planned Logistics Request Assigned Logistics Request At Start Location Logistics Request In Progress Logistics Request At End Location Logistics Request Completed Logistics Request Canceled Logistics Request Unassigned Logistics Request Delayed Logistics Technician Escalation Logistics Supervisor Escalation Logistics Manager Escalation Logistics Request Updated Logistics Request Postponed Logistics No Technician In The Sector Logistics Technician Not Returned From Break Logistics Technician Total Break Time Exceeded Logistics Update Patient Location Action Failed Logistics Request Bed Clean for Patient's Bed Action Failed Logistics Update Bed Status Action Failed Logistics Print Ticket To Ride Action Failed Logistics Complete Pending Discharge Action Failed Logistics Complete Pending Transfer Action Failed Logistics Break Started Logistics Update Bed Blocks Action Failed Logistics Break Ended Logistics Sign In Logistics Manual Sign Out Logistics Transport Link Appointment Updated Order Reverted Transfer Center Request Order Has Meaningful Transfer Center Changes Logistics Job Interrupted By Stat Logistics Request Acknowledged Logistics Job Skipped Bed Request Now Planned To New Unit Logistics Job Priority Upgraded to High Logistics Job Priority Upgraded to Stat Logistics Job Now Upcoming Logistics Automatic Transport Creation Failed Logistics Daemon Problem Encountered Discharge Milestone Completed Discharge Milestone Overdue Discharge Milestone Marked Incomplete Discharge Milestone Added Discharge Milestone Removed Logistics Break Time Over Logistics Daily Task not Completed Sector Level Logistics Auto Sign Out Logistics Inactive Technician Logistics Daily Task Job Interrupted Discharge Delay Resolved Discharge Delay Marked Unresolved Discharge Delay Added Discharge Order Signed Discharge Milestone Still Outstanding and Expected Discharge Date is Today Discharge Milestone Still Outstanding and Expected Discharge Date is Tomorrow Discharge Milestone Still Outstanding and Discharge Order Signed Discharge Milestone Still Outstanding and Medically Ready For Discharge Discharge Milestone Became Next Step Delay Still Unresolved and Expected Discharge Date is Today Delay Still Unresolved and Expected Discharge Date is Tomorrow Delay Still Unresolved and Discharge Order Signed Delay Still Unresolved and Medically Ready For Discharge Patient Medically Ready For Discharge Admission Failure - Patient Location Update Generated Bed Request Unassigned From Bed ADT Order Error Patient Verification Encounter Verification HAR Verification HAR 2 Verification Patient's PCP Notification Preference Changed Surgical Case Scheduled Hospital Coding Complete Appointment Canceled (Same Day) Appointment Roomed Close Nurse Triage Encounter
8	PEND_ID	VARCHAR	No
	The unique ID of the pending event or bed request that triggered Bed Planning Event Notification. Only notifications sent for Bed Planning events have a value populated for this column.
9	SEND_TO_C_NAME	VARCHAR	No
	The send to category number for the notification delivery. This indicates who was supposed to receive 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
10	PCP_TYPE_C_NAME	VARCHAR	No
	The category number of the type of primary care provider for the notification delivery. Only rows that have a Send To of PCP have a value populated for this item. This column indicates the type of PCP that was supposed to receive the notification. May contain organization-specific values: Yes Category Entries: General
11	SENT_TO_FAX_NUMBER	VARCHAR	No
	This is the fax number that a faxed notification was sent to.
12	SENT_TO_EMAIL_ADDR	VARCHAR	No
	This is the email address that was used when a notification was delivered via email. There may be multiple email addresses listed.
13	SEND_METHOD_C_NAME	VARCHAR	No
	The delivery method category number for the notification delivery. May contain organization-specific values: No Category Entries: Letter Fax Note EDI Notification In Basket Message Letter Review Extension ADT Autoprint using table ADT Autoprint a report Default Letter Default Fax Default In Basket Message Admission Notification E-mail CE Message Page Triage Immediate Transfer of Care Pend Transfer of Care Text MyChart Message MyChart Letter eReferral to PCEHR MyChart Scheduling Ticket Mobile App Notification Mobile App Notification and Page Mobile App Notification, fall back to Page Page, fall back to Mobile App Notification Discharge Notification Show In Bed Planning Generate Document Default MyChart Clinical Attachment Mail Direct Message Communication Management External Notification UM Notification Chart Abstraction Registry Payer Platform Notification Default Payer Platform Notification Automatically Determine CRM Letter Desktop Notification Desktop + Mobile Notification
14	EVENT_ID	VARCHAR	No
	This item holds the event notification record that was triggered
15	EVENT_ID_EVENT_NAME	VARCHAR	No
	The name of the event.