PROBLEM_NOTE_PROPS

Description:

Contains all related properties to assessment & plan notes which are stored in the PROBLEM_NOTES clarity extract.

Primary Key

Column Name	Ordinal Position
PROBLEM_LIST_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PROBLEM_LIST_ID	NUMERIC	No
	The unique identifier for the problem record.
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	GENERATED_NOTE_ID	VARCHAR	No
	This item stores the note the assessment & plan note has been generated into. If null then the corresponding assessment & plan note has not been generated into a note.
4	AP_NOTE_SERVICE_C_NAME	VARCHAR	No
	This item stores the service for which the assessment and plan note was written. May contain organization-specific values: Yes