MEDS_REV_LAST_LIST

Description: |
This table lists the patient's current medications from the last time a user reviewed the patient's medications.
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 current at each review instance is in the MEDS_REV_HX_LIST table.
Reviewing user and other information about each medication's review instance is in the MEDS_REV_HX 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. This column is frequently used to link to the PATIENT table.
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 | MEDICATION_ORDER_ID | NUMERIC | No |
The unique ID of one of the patient's current medication orders at the most recent time of review.
4 | TAKING_YN | VARCHAR | No |
Indicates whether the associated medication order was marked as taking at the most recent time of review.
May contain organization-specific values: No
Category Entries:
No
Yes