This is a generic table that contains every Problem List (LPL) record regardless of its type. It also contains a link to the patient record that is associated with the LPL record, a column indicating the type of LPL record, and an optional link from a Problem History record (type 7) to the corresponding Problem record (type 1) that it describes.
Primary Key
Column Name
Ordinal Position
PROBLEM_LIST_ID
1
Column Information
Name
Type
Discontinued?
1
PROBLEM_LIST_ID
NUMERIC
No
The unique identifier for the problem record.
2
PAT_ID
VARCHAR
No
The unique ID of the patient record associated with this problem list.
3
HX_SOURCE_ID
NUMERIC
No
Stores the ID of the problem record that this history record describes.
4
RECORD_TYPE_C_NAME
VARCHAR
No
Indicates the type of information stored in this record, such as Problem List, Allergy, Immunization, etc.