DP_FAC_COMMUNICATIONS

Description: |
This table contains communications sent in the Continued Care and Services Coordination workflow. This stores the sender, communication instant and the communication status.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ENC_CSN_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | CM_CT_OWNER_ID | VARCHAR | No |
The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
6 | SENDER_USER_ID | VARCHAR | No |
User who sent the communication from Continued Care and Service Coordination workflow
7 | SENDER_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
8 | SENT_LOCAL_DTTM | DATETIME (Local) | No |
Instant the communication was sent from Continued Care and Services Coordination workflow
9 | COMM_SUCCESS_FAIL_C_NAME | VARCHAR | No |
Status of the communication sent from Continued Care and Services Coordination workflow
May contain organization-specific values: No
Category Entries:
PENDING
SUCCESS
FAILED