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.