ADVICE_TEXT

Description:

This table extracts the text that was offered as care advice.

Primary Key

Column Name	Ordinal Position
CA_ID	1
VERSION_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	CA_ID_CARE_ADVICE_NAME	VARCHAR	No
	The name of the care advice record.
2	VERSION_DATE_REAL	FLOAT	No
	This is a numeric representation of the date of this version in your system. The integer portion of the number specifies the date of the version. The digits after the decimal point indicate multiple versions on one day.
3	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4	CA_TEXT	VARCHAR	No
	The text of the Care Advice given to a patient.