CAL_REFERENCE_PAT

Description:

The patients and encounters referenced by the communication.

Primary Key

Column Name	Ordinal Position
COMM_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	COMM_ID	VARCHAR	No
	The unique ID for the Communication Tracking record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	REF_PAT_CONTEXT_C_NAME	VARCHAR	No
	The category number for the context of the patient encounter which is referenced by the communication. May contain organization-specific values: Yes Category Entries: Cadence Confirm Report Cadence Follow-Up Report Cadence Reschedule Report Cadence Wait List Report Cadence Recall Report Cadence Prerequisite Report Cadence Schedule Orders/Appt Requests Cadence Quick Reminder Patient Update Message Appointment Automatic Notices Snapboard Recall Letter Batch Manually Printed Recall Recall Phone Reminders Ready to Book Phone Reminder Ready to Book Letter Reminder Cadence Dental Visit Automatic Arrival Kiosk Self-Service Email Appointment Reminder Cadence Appointment Desk Case Reminder Referral Reminder Waiting List Letter Automatic Day of Surgery Notifications Visit Messaging Other Bed Planning Environmental Services Transport Patient Event Notification Appointment Event Notification Event-Triggered Patient Message Transfer Center Admission-Related Patient Visit Contacts Notification Logistics Cadence Batch Notifications Appointment Request Notification Registration Patient Workqueue Follow Up Cosmos Teleport eCheck-In Tickler Kiosk Remote Check In Ticket Pass Offer Fast Pass Offer Mass Closure Referral Preauthorization Case Scheduling Patient Notification Block Utilization Notification Launch Outreach Tapestry Appeal or Grievance Imaging Actionable Finding Management Imaging Actionable Finding Escalation NemSMS Enrollment Query NemSMS Enrollment Request
4	REF_REFERRAL_ID	NUMERIC	No
	The unique ID of the referral that is referenced by the communication.
5	REF_WAITING_LIST_ID	NUMERIC	No
	The unique ID of the Waiting List that is referenced by the communication.
6	REF_ADT_EVENT_ID	NUMERIC	No
	ADT event in regards to which this communication was sent.
7	REF_PEND_EVENT_ID	VARCHAR	No
	The ID number of the pending event for which this communication was sent.
8	REF_CLEANING_ID	NUMERIC	No
	The bed management event for which this communication was sent.
9	REF_TXPORT_ID	NUMERIC	No
	The ID number of the transport request for which this communication was sent.
10	REF_DEPT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
11	REF_MSG_ID	VARCHAR	No
	The ID number of the specific In Basket message that caused this email messages to be sent.
12	REF_HLR_ID	NUMERIC	No
	The unique ID associated with the logistics job record associated for this row of this patient encounter communication interaction.
13	REF_TECH_ID	NUMERIC	No
	The unique ID associated with the logistics technician record for this row of this patient encounter communication interaction.
14	REF_APPEAL_GRV_ID	NUMERIC	No
	The health plan appeal or grievance record associated with this call.