PROBLEM_HX_EVENT_LIST
Description:
This table contains the master list of events for a patient's problem histories.

Primary Key
Column Name Ordinal Position
PAT_ID 1
GROUP_LINE 2
VALUE_LINE 3

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2 GROUP_LINE INTEGER No
The line number for the information associated with this record.
3 VALUE_LINE INTEGER No
The line number of one of the multiple values associated with a specific group of data within this record.
4 PROBLEM_HX_EVENT_NOTE_ID VARCHAR No
The unique ID of the note for the event in this row of the patient's problem history.