SPOC_COMM_SENT

Description: |
This table contains information about communication sent for a plan of care.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
RECORD_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | RECORD_ID | NUMERIC | No |
The unique identifier for the plan of care 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 | COMM_SENT_TYPE_C_NAME | VARCHAR | No |
The communication type category ID for the plan of care.
May contain organization-specific values: No
Category Entries:
Letter
Call
Secure Chat
In Basket
MyChart
4 | COMM_SENT_UTC_DTTM | DATETIME (UTC) | No |
Stores the date the communication was sent
5 | COMM_SENT_PROV_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.
6 | LETTER_SENT_JOB | VARCHAR | No |
Stores the Job ID of the letter communication sent
7 | LETTER_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number of the patient encounter in which the letter was sent.
8 | SENT_COMM_CMT | VARCHAR | No |
The comment associated with the communication sent for the plan of care.
9 | SENT_COMM_USER_ID | VARCHAR | No |
Stores the user who sent the communication.
10 | SENT_COMM_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
11 | COMM_SENT_PAT_RELATIONSHIP_ID | NUMERIC | No |
Stores the patient contact (RLA ID) who received the communication. Not used for the letter type.
12 | COMM_SENT_MYPT_ID | VARCHAR | No |
Stores the proxy (WPR ID) who received the communication. Not used for the letter type.