LCA_RECORD_STATUS

Description: |
Table for communication job record status.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
COMMUNICATION_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | COMMUNICATION_ID | NUMERIC | No |
LCA routing record id
2 | RECORD_STATUS_C_NAME | VARCHAR | No |
status of the record (hidden, deleted,....)
May contain organization-specific values: No
Category Entries:
ACTIVE
INACTIVE
DELETED
INACTIVE AND DELETED
Hidden
INACTIVE and Hidden
DELETED and Hidden
INACTIVE DELETED AND HIDDEN
3 | PAT_ID | VARCHAR | No |
Stores the patient record associated with this communication.