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	NUMERIC	No
	The unique id of the care advice record associated with this row. This column is frequently used to link to the ADVICE_BASIC table and the PAT_ENC_CALL_CA table.
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.