LPL_RELATED_PROBS
Description:
The LPL_RELATED_PROBS table contains information regarding related problems from a patient's problem list.

Primary Key
Column Name Ordinal Position
PROBLEM_LIST_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 PROBLEM_LIST_ID NUMERIC No
The internal ID of the problem.
2 CONTACT_DATE_REAL FLOAT No
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 RELATED_PROBLEM_ID NUMERIC No
List of related problem IDs.