The prescriptions table provides information about prescribed medications. Information includes the name of the drug, coded identifiers including the Generic Sequence Number (GSN) and National Drug Code (NDC), the product strength, the formulary dose, and the route of administration.
- pharmacy on
- emar on
|Name||Postgres data type|
||INTEGER NOT NULL|
||INTEGER NOT NULL|
||VARCHAR(20) NOT NULL|
||VARCHAR(255) NOT NULL|
subject_id is a unique identifier which specifies an individual patient. Any rows associated with a single
subject_id pertain to the same individual.
hadm_id is an integer identifier which is unique for each patient hospitalization.
An identifier which links administrations in emar to pharmacy information in the pharmacy table.
The prescribed start and stop time for the medication.
The component of the prescription which the drug occupies. Can be one of ‘MAIN’, ‘BASE’, or ‘ADDITIVE’.
A free-text description of the medication administered.
The Generic Sequence Number (GSN), a coded identifier used for medications.
The National Drug Code (NDC), a coded identifier which uniquely identifiers medications.
A free-text description of the composition of the prescribed medication (e.g. ‘12 mg / 0.8 mL Oral Syringe’, ‘12.5mg Tablet’, etc).
The container in which the formulary dose is delivered (e.g. ‘TABLET’, ‘VIAL’, etc).
The prescribed dose for the patient intended to be administered over the given time period.
The unit of measurement for the dose.
The amount of the medication which is contained in a single formulary dose.
The unit of measurement used for the formulary dosage.
The number of doses per 24 hours for which the medication is to be given. A daily dose would result in
doses_per_24_hrs: 1, bidaily (BID) would be 2, and so on.
The route of administration for the medication.
Was this page helpful?
Glad to hear it! Please raise an issue here to tell us how we can improve.
Sorry to hear that. Please raise an issue here to tell us how we can improve.