MEDS_REV_HX

Description: |
This table lists all of the times that a user reviewed a patient's medication list.
The list of medications current at each review instance is in the MEDS_REV_HX_LIST table.
Reviewing user and other information about the most recent review of medications is in the PATIENT table in columns MEDS_LAST_REV_TM, MEDS_LST_REV_USR_ID, and MEDS_LAST_REV_CSN.
The list of medications at the most recent review instance is in the MEDS_REV_LAST_LIST table.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ID | 1 |
LINE_COUNT | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this row.
2 | LINE_COUNT | 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_REV_INSTANT | DATETIME (Local) | No |
The date and time that the patient's medication list was marked as reviewed.
4 | MEDS_HX_REV_USER_ID | VARCHAR | No |
The unique ID associated with the user that marked the patient's medication list as reviewed.
5 | MEDS_HX_REV_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | MEDS_HX_REV_CSN | NUMERIC | No |
The unique contact serial number of the contact in which the patient's medication list was reviewed. This number is unique across all patient encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI).
7 | MEDS_HX_REV_COUNT | INTEGER | No |
Count of how many meds are found in the medication history review list (I EPT 17229).