The personmedicationtable represents recent activity for a curated set of RxNorm VA Drug Classes and RxNorm ATC classes.
Each row represents one person. This table is a pivoted representation of the medicationprofile table (pivot on medicationprofile.rxnormclasscode); the date in each column is the medicationprofile.stopdate.
Source Concepts
Table Schema
| Name |
Type
|
Description |
| personid |
VARCHAR(38) GUID |
Unique identifier representing a unique person that may include data from several sources that have been linked. This identifier is the person_id of a HIEBus recordgroup.
|
| BL110 |
TIMESTAMP |
The most recent stop date for medications related to: VA Drug Class ANTICOAGULANTS.
|
| BL117 |
TIMESTAMP |
|
| CN101 |
TIMESTAMP |
|
| CN601 |
TIMESTAMP |
|
| CN609 |
TIMESTAMP |
|
| CV100 |
TIMESTAMP |
|
| CV150 |
TIMESTAMP |
|
| CV200 |
TIMESTAMP |
|
| CV400 |
TIMESTAMP |
|
| CV490 |
TIMESTAMP |
|
| CV701 |
TIMESTAMP |
|
| CV702 |
TIMESTAMP |
|
| CV800 |
TIMESTAMP |
|
| CV805 |
TIMESTAMP |
|
| HS051 |
TIMESTAMP |
|
| HS502 |
TIMESTAMP |
|
| HS509 |
TIMESTAMP |
|
| MS102 |
TIMESTAMP |
|
| RE101 |
TIMESTAMP |
|
| RE102 |
TIMESTAMP |
|
| RE103 |
TIMESTAMP |
|
| RE104 |
TIMESTAMP |
|
| RE105 |
TIMESTAMP |
|
| RE107 |
TIMESTAMP |
|
| computedate |
TIMESTAMP |
The reference date for the last90d computed columns that follow.
|
| prescribercountlast90d |
INTEGER |
|
| profilecountlast90d |
INTEGER |
|
| medcountlast90d |
INTEGER |
|
| BL110ds90d |
DECIMAL |
|
| BL117ds90d |
DECIMAL |
|
| CN101ds90d |
DECIMAL |
|
| CN601ds90d |
DECIMAL |
|
| CN609ds90d |
DECIMAL |
|
| CV100ds90d |
DECIMAL |
|
| CV150ds90d |
DECIMAL |
|
| CV200ds90d |
DECIMAL |
|
| CV400ds90d |
DECIMAL |
|
| CV490ds90d |
DECIMAL |
|
| CV701ds90d |
DECIMAL |
|
| CV702ds90d |
DECIMAL |
|
| CV800ds90d |
DECIMAL |
|
| CV805ds90d |
DECIMAL |
|
| HS051ds90d |
DECIMAL |
|
| HS502ds90d |
DECIMAL |
|
| HS509ds90d |
DECIMAL |
|
| MS102ds90d |
DECIMAL |
|
| RE101ds90d |
DECIMAL |
|
| RE102ds90d |
DECIMAL |
|
| RE103ds90d |
DECIMAL |
|
| RE104ds90d |
DECIMAL |
|
| RE105ds90d |
DECIMAL |
|
| RE107ds90d |
DECIMAL |
|
Back to Tables
