|
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 |
CONTACT_SERIAL_NUM |
NUMERIC |
No |
|
|
|
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI). |
|
|
3 |
LINE_COUNT |
INTEGER |
No |
|
|
|
The line number of the associated instance of medication review in the patient's record. Together with PAT_ID, this forms the foreign key to the MEDS_REV_HX table. |
|
|
4 |
VALUE_COUNT |
INTEGER |
No |
|
|
|
The line number of one of the multiple medication orders that are associated with the patient and the instance of medication review from the MEDS_REV_HX table. |
|
|
5 |
MEDICATION_ORDER_ID |
NUMERIC |
No |
|
|
|
The unique ID of one of the patient's current medication orders at the time of review. |
|
|
6 |
TAKING_YN |
VARCHAR |
No |
|
|
|
Indicates whether the associated medication order was marked as taking at the time of review. |
|
|