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.