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.