TREATMENT_PLAN_NOTES

Description:

The TREATMENT_PLAN_NOTES table contains the note text from Treatment Plan Notes (I TPL 50) as written in the properties window of a Treatment Plan. The text from Treatment Plan Notes is first converted to plain text. The formatting information in RTF note text or HTML note text is removed. The plain text is then broken up into lines of 4000 characters or fewer.

Primary Key

Column Name	Ordinal Position
TREATMENT_PLAN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TREATMENT_PLAN_ID	NUMERIC	No
	The record ID for the treatment plan.
2	LINE	INTEGER	No
	The line number for the note text associated with this treatment plan. The note text is first converted to plain text, then broken into lines of 4000 characters or fewer. Words and line breaks are not split across different lines. This column ("LINE") indicates the line number of the processed text.
3	NOTES_TEXT	VARCHAR	No
	The text of the treatment plan note. The note text is first converted to plain text, then broken into lines of 4000 characters or fewer. Words and line breaks are not split across different lines.