PAT_MEDS_HX
Description:
This table extracts the medication history for patient (EPT) records.
Primary Key
Column Name
Ordinal Position
PAT_ID
1
LINE
2
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
LINE
INTEGER
No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3
MEDS_HX_ID
NUMERIC
No
The ID of the medication order for the patient.