PROBLEM_LIST_ALL

Description:

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. May contain organization-specific values: No Category Entries: Problem List Allergy Immunization Chronic Meds Wound System Problem History Adverse Event