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.