The MEDRECON table
On admission to the emergency departments, staff will ask the patient what current medications they are taking. This process is called medicine reconciliation, and the MEDRECON table stores the findings of the care providers.
Table source: Emergency department database.
Table purpose: Document medications a patient is currently taking.
Number of rows:
- MAIN on
|Name||Postgres data type|
||INT NOT NULL|
||SMALLINT NOT NULL|
An identifier which uniquely identifies a single emergency department stay for a single patient.
The time at which the medicine reconciliation was charted.
The name of the medication.
A code for the medication.
The National Drug Code (ndc) for the medication.
Medications are grouped using a hierarchical ontology. As more than one group may be associated with the medication,
etc_rn is used to differentiate the groups (there is no meaning to the order of
etccode provides the code and
etcdescription provides the description of the group.
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.