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.