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.