PAT_ENC_CALL_CA
Description:
This table contains the Care Advice (LPA) records given to the Patient in a Call Center call.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 LINE INTEGER No
The line number for the patient call care advice.
2 CONTACT_DATE DATETIME No
The date for the encounter in standard date format.
3 CARE_ADVICE_GIVEN_CARE_ADVICE_NAME VARCHAR No
The name of the care advice record.
4 CA_GIVEN_DAT FLOAT No
The version number of the care advice given.
5 CA_GIVEN_BY VARCHAR No
The unique ID of the user giving the care advice.
6 CA_GIVEN_BY_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 CA_GIVEN_DATE DATETIME (Local) No
The date when the care advice was given.
8 PAT_ENC_CSN_ID NUMERIC No
A unique serial number for this encounter. This number is unique across all patients and encounters in the system.
9 CARE_ADVICE_HNO_ID VARCHAR No
The Note ID that contains the modified care advice.
10 CARE_ADVICE_PROTOCOL_ID NUMERIC No
Stores the Protocol ID that the given care advice is associated with.
11 CARE_ADVICE_PROTOCOL_ID_PROTOCOL_NAME VARCHAR No
The display name of the protocol.