LCA_COMM_SENT
Description:
Table for LCA routing record that contains general information applicable to the entire route job. Essentially no add single response items.

Primary Key
Column Name Ordinal Position
COMMUNICATION_ID 1

Column Information
Name Type Discontinued?
1 COMMUNICATION_ID NUMERIC No
LCA routing record id
2 COMM_INSTANT DATETIME (Local) No
Time that the record was created
3 SEND_STATUS_C_NAME VARCHAR No
Sending status of the LCA communication record. Indicates whether sent or not.
May contain organization-specific values: Yes
Category Entries:
Ready to Send
Sent
Sent to Pool
Generating PDF
Failed to Send
Created
Informational Only
Voided
4 COMM_PAT_ENC_CSN_ID NUMERIC No
Patient Contact ID (CSN) associated with the message.
5 COMM_SENT_INST_UTC_DTTM DATETIME (UTC) No
Instant the communication is sent.
6 REP_DOCUMENT_CSN_ID NUMERIC No
Store the DXR CSN that is being replied to by this message.