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	NUMERIC	No
	The unique ID for the care advice given.
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.