RX_IVENT_NOTES

Description:

The intervention notes table contains one record for each intervention that has notes associated with it, and the text of those notes. Rich text is stored in database but it is extracted as plain text here. The primary key for the intervention type table is INTERVENTION_ID, LINE.

Primary Key

Column Name	Ordinal Position
INTERVENTION_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	INTERVENTION_ID	NUMERIC	No
	The unique ID of the intervention.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	NOTES_TEXT	VARCHAR	No
	Text of the intervention notes (if any). The text will be in plain text, that is, no formatting information besides blank lines and possibly extra spaces will appear in the text. This column will automatically be truncated at 4000 characters.