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
Express Reschedule
Cadence Department Appointments Report
Referral Preauthorization
Service Request
Case Scheduling Patient Notification
Block Utilization Notification
Launch Outreach
Automated 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.