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