PAT_ENC_COMM_MGT

Description: |
The patient encounter communication management table stores communication details for a patient. It contains recipient, sender, and communication information for communications created and sent using the communication management module.

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_ENC_DATE_REAL | FLOAT | No |
A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the 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.
4 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | COMM_SENT_HOUSE_NO | VARCHAR | No |
Communication recipient house number
6 | COMM_SENT_DISTRCT_C_NAME | VARCHAR | No |
The category number for the district in the communication recipient's address.
May contain organization-specific values: Yes
7 | COMM_SENT_COUNTY_C_NAME | VARCHAR | No |
The category number for the county in the communication recipient's address.
May contain organization-specific values: Yes
8 | COMM_SENT_UID_ID | VARCHAR | No |
The unique ID of the user who sent the communication.
9 | COMM_SENT_UID_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
10 | COMM_SENT_INST | DATETIME (Local) | No |
The instant when the communication was sent.
11 | COMM_SENT_INI | VARCHAR | No |
The record type of the communication's recipient, for example SER for provider, DEP for department, etc.
12 | COMM_SENT_SER_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
13 | COMM_SENT_TO_NAME | VARCHAR | No |
Communication recipient name
14 | COMM_SENT_FAX | VARCHAR | No |
Communication recipient fax number
15 | COMM_SENT_PHONE | VARCHAR | No |
Communication recipient phone number
16 | COMM_SENT_ADDR | VARCHAR | No |
The street address of the communication recipient.
17 | COMM_SENT_CITY | VARCHAR | No |
Communication recipient city
18 | COMM_SENT_STATE | VARCHAR | No |
Communication recipient state.
19 | COMM_SENT_ZIP | VARCHAR | No |
Communication recipient zip code.
20 | COMM_SENT_COUNTRY | VARCHAR | No |
Communication recipient country
21 | COMM_SENT_METHOD_C_NAME | VARCHAR | No |
The category value for the method used to send the communication.
May contain organization-specific values: Yes
Category Entries:
In Basket
Fax
Mail
Phone Call
MyChart
Network Printer
Courier Service
Outside Provider Messaging
Print Locally
EDI
Opt Out
E-mail
FHIR
Save to File
Electronic Authorization Message
Suppress Result Routing
Payer Platform Notification
Internal Payer Notification
22 | COMM_SENT_LTR_NUM | VARCHAR | No |
Letter number of the communication sent
23 | COMM_SENT_RPT_ID | VARCHAR | No |
The unique ID of the report sent with the communication.
24 | COMM_SENT_RPT_ID_REPORT_NAME | VARCHAR | No |
The name of the report
25 | COMM_SENT_OTH_BLBID | VARCHAR | No |
Blob ID of the communication sent
26 | COMM_SENT_LTR_BLOB | VARCHAR | No |
Letter blob of the communication sent. Only applies to communications sent via fax.
27 | COMM_SENT_RPT_BLOB | VARCHAR | No |
Report blob of the communication sent. Only applies to communications sent via fax.
28 | COMM_SENT_STAT_C_NAME | VARCHAR | No |
Communication sent status category number for the communication.
May contain organization-specific values: No
Category Entries:
Not Ready
Ready To Send
Sent
New Job
Support Staff
Voided
Sent & Acknowledged
Preparing to Send
29 | COMM_SENT_JOB_ID | VARCHAR | No |
The unique ID of the communication job.
30 | COMM_SENT_BY_USR_ID | VARCHAR | No |
The unique ID of the user (EMP) who actually sent the communication from the communication management module.
31 | COMM_SENT_BY_USR_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
32 | COMM_SENT_SER_ADDR | VARCHAR | No |
Stores the selected address ID if the recipient is a provider
33 | COMM_ROUTING_MESSG | VARCHAR | No |
The routing message included when the communication is routed to support staff.
34 | OR_LOG_ID | VARCHAR | No |
The unique ID of the surgical log (ORL) record associated with the communication note.
35 | COMM_SENT_HNO_ID | VARCHAR | No |
The unique ID of the note (HNO) record associated with the communication note.
36 | COMM_SENT_EMP_ID | VARCHAR | No |
The unique ID of the user (EMP) record for the communication recipient.
37 | COMM_SENT_EMP_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
38 | COMM_IS_OVERDUE_YN | VARCHAR | No |
Indicates whether the communication has been waiting for either transcriptions, results, or both, and is now overdue. A Y indicates that it is overdue. N indicates that the communication is not overdue.
May contain organization-specific values: No
Category Entries:
No
Yes
39 | COMM_PREV_LETTER_YN | VARCHAR | No |
Indicates whether the communication is using a previously sent letter. A Y indicates that the communication is using a previously sent letter. N indicates that the communication is not using a previously sent letter.
The category values for this column were already listed for column: COMM_IS_OVERDUE_YN
40 | COMM_WAIT_FOR_TX_C_NAME | VARCHAR | No |
Indicates whether the communication is waiting for transcriptions. Yes indicates that the communication is waiting for transcriptions, No indicates that the communication is not waiting for transcriptions, and Resulted indicates that the communication was waiting for a transcription that has since been completed.
May contain organization-specific values: No
Category Entries:
Yes
No
Resulted
41 | COMM_WAIT_FOR_RES_C_NAME | VARCHAR | No |
Indicates whether the communication is waiting for results. Yes indicates that the communication is waiting for results, No indicates that the communication is not waiting for results, and Resulted indicates the communication was waiting for results that have since been resulted.
May contain organization-specific values: No
Category Entries:
Yes
No
Resulted
42 | COMM_SENT_DIR_ADDR | VARCHAR | No |
This is the Direct address to which a communication is sent.
43 | COMM_CREATED_MTH_C_NAME | VARCHAR | No |
This item stores the communication's creation method. "Automatic on Close Encounter" means the communication was created from an automatic communication when the encounter was closed and has not been sent yet. "ED Discharge" is for automatic communications created upon discharge from the emergency department. "IP Discharge" is for automatic communications created upon discharge from an inpatient admission. "Order Transmittal" is for automatic communications created based on order transmittal rules when an order is signed. "Referral Transmittal" is for automatic communications created with referral workqueue functionality. Otherwise, communications created with the Communication Management navigator section or activity will have the "Standard" value.
May contain organization-specific values: Yes
Category Entries:
Standard
Automatic on Close Encounter
Additional
By interface for full letter dictations
ED Discharge
Continued Care and Services Coordination
IP Discharge
Order Transmittal
Referral Transmittal
Event Notification
ED Event Change Filing Extension
Flowsheets
Payer Communication
ED Notification
Referral Notification
SC Decision Letter
Chart Abstraction
Bulk Letters
Waitlist Letters
Referral Fax with Attachment
Specialty Plan of Care
ED Excuse Letter
SOTE Patient Refusal Letter
Referral Notification w/ Consent
Medication Therapy Problem - Assign
Canto Regular Comms
Canto Quick Comms
Health Maintenance Reminders
Form Filler Auto Print
Outside Message
HOV Completion
Automatic Action Letter Notification
HH Plan of Care Update Message
Hospice Non-Covered Document
Imaging Reminder Letter
44 | COMM_CE_SUB_MTHD_C_NAME | VARCHAR | No |
This is the sub routing method when the routing method "Outside provider messaging" is used in a communication.
May contain organization-specific values: No
Category Entries:
None
Outgoing Direct Address
EpicCare Link Direct Address
MedCom
PCEHR
Kanta
Pika XML
45 | COMM_SENT_EMAIL | VARCHAR | No |
Communication recipient email
46 | COMM_PRIORITY_C_NAME | VARCHAR | No |
Communication priority
May contain organization-specific values: Yes
Category Entries:
High
Routine
Low
47 | COMM_SOURCE_RFL_ID | NUMERIC | No |
Stores a referral ID associated with a transition of care communication.
48 | COMM_SENT_INSTANT_UTC_DTTM | DATETIME (UTC) | No |
Communication sent instant in UTC format
49 | COMM_UPDATE_INST_UTC_DTTM | DATETIME (UTC) | No |
The instant (in UTC) at which the associated communication was last updated.
50 | COMM_VOID_REASON_C_NAME | VARCHAR | No |
Selected reason for voiding this communication
May contain organization-specific values: Yes
Category Entries:
Incorrect recipient; replacement needed
Incorrect recipient; no replacement needed
Wrong patient
Wrong encounter
Sent accidentally
Excuse letter removed
Excuse letter modified
Negative Acknowledgment
Missing Acknowledgment
Voided by utility
Invalid recipient; destination pool invalid
Returned to sender
Routing Failed
51 | COMM_VOID_USER_ID | VARCHAR | No |
User (EMP) ID of user who voided this communication
52 | COMM_VOID_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
53 | COMM_VOID_INSTANT_DTTM | DATETIME (UTC) | No |
The instant (in UTC) at which this communication was voided
54 | CONSENT_DOC_INFO_ID | VARCHAR | No |
The unique ID of the document (DCS) record which grants patient consent for sending the message.
55 | COMM_SENT_EAF_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
56 | COMM_SENT_HIP_ID | NUMERIC | No |
The unique ID of the registry (HIP) record for the communication recipient.
57 | COMM_SENT_HIP_ID_REGISTRY_NAME | VARCHAR | No |
The name of the In Basket registry in the HIP master file.
58 | COMM_SENT_DEP_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
59 | COMM_SENT_AGY_ID | VARCHAR | No |
The unique ID of the agency (AGY) record for the communication recipient.
60 | COMM_SENT_AGY_ID_AGENCY_NAME | VARCHAR | No |
The name of the agency.
61 | COMM_SENT_DXO_ID | NUMERIC | No |
The unique ID of the data exchange organization (DXO) record for the communication recipient.
62 | COMM_SENT_DXO_ID_EXTERNAL_NAME | VARCHAR | No |
Organization's external name used as the display name on forms and user interfaces.
63 | COMM_RES_CMT | VARCHAR | No |
Indicates what was done to resolve the negative or missing acknowledgment
64 | COMM_VOID_COMMENT | VARCHAR | No |
Comment for communication retraction reason.
65 | COMM_PRINT_STATUS_C_NAME | VARCHAR | No |
Stores status of print job attached to communication
May contain organization-specific values: No
Category Entries:
Completed
Submitted
Error
Deleted
Rerouted
Rescheduled
Start Processing on Generic Queue
Transfer requested from Epic Print Service
Transfer in progress to Epic Print Service
Submitted to Epic Print Service
Processing in Epic Print Service
Failed - Aborted in Epic Print Service
Failed - Timeout in Epic Print Service
Failed in Epic Print Service
Waiting for Pickup
Waiting for Batch
Failed - Fax Transmission Failure
Processing on fax server
Sent to Spooler
Failed - Printer Failure
Spooling Complete
Sent to Third Party
Pending Printout
Failed - Pending Print Timeout
Failed - Inactive User
Failed - No ALP Clients
Failed - Rendering Failed
No Printable Content
Rendering Started
Rendering Completed
Failed - Output Failed
Output Started
Output Completed
Failed - Third Party Error
Failed - Local Printing Failure
Batch Collecting Jobs
Batch Started Printing
Batch Finished Spooling
Batch Finished
Pending Printout
Retrieving Downtime Job Metadata
Retrieving Downtime Job Data
Processing Downtime Job
Failed - WBS Report Import
Waiting Downtime Job Pickup
Downtime Job Contains No Data
File Ready to Save
Expired
Failed - User Canceled
Waiting for Pickup - Flood Controlled
Submitted - Flood Controlled
66 | COMM_SENT_ORG_ID | NUMERIC | No |
The DXO ID of the organization associated with the recipient's address at the time the communication is sent.
67 | COMM_SENT_ORG_ID_EXTERNAL_NAME | VARCHAR | No |
Organization's external name used as the display name on forms and user interfaces.