CUST_SVC_MYC_LETTER_AUDIT

Description:

This table contains the history of when Customer Relationship Management (CRM) letters were released to the patient portal or retracted from the patient portal.

Primary Key

Column Name	Ordinal Position
COMM_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	COMM_ID	NUMERIC	No
	The unique ID of the communication record that the audit trail is for.
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	LETTER_AUD_NOTE_ID	VARCHAR	No
	The unique ID of the note that was released or unreleased from the patient portal.
4	LETTER_AUD_USER_ID	VARCHAR	No
	The unique ID of the user that released or unreleased the letter from the patient portal.
5	LETTER_AUD_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
6	LETTER_ACTION_C_NAME	VARCHAR	No
	The category ID for an action that indicates if the letter was released to or removed from the patient portal. May contain organization-specific values: No Category Entries: Sent to Portal Retracted from Portal
7	CHANGE_UTC_DTTM	DATETIME (UTC)	No
	The date and time when the letter was released or unreleased from the patient portal.