‹ Back


The PROBLEM table contains diagnoses and other conditions that are associated with the patient.

Field Name Field Description
PROBLEM_ID The unique primary identifier of the problem table
ENCOUNTER_ID The foreign key linking the record to the encounter table
PROBLEM A de-normalized or annotated description of the problem. This is defaulted from the display term of the selected codified problem, and can be extended (annotated) by the clinician.
PROBLEM_DT_TM The date and time for which this problem becomes effective. Normally, this will be the date and time the problem is added, but could be a past or future date and time.
PROBLEM_ONSET_DATE Date of onset of the problem
PROBLEM_STATUS Indicates if the problem is active
PROBLEM_CONFIRMATION Indicates if the problem has been confirmed
PROBLEM_CLASSIFICATION Indicates if the problem is a medical diagnosis or alert