The prescriptions table

Table source: Hospital provider order entry database.

Table purpose: Contains medication related order entries, i.e. prescriptions.

Number of rows: 4,156,450

Links to:

• PATIENTS on SUBJECT_ID
• ADMISSIONS on HADM_ID
• ICUSTAYS on ICUSTAY_ID

Important considerations

• The table does not specify if an order was later cancelled as of MIMIC-III v1.0.

Table columns

Name	Postgres data type
ROW_ID	INT
SUBJECT_ID	INT
HADM_ID	INT
ICUSTAY_ID	INT
STARTDATE	TIMESTAMP(0)
ENDDATE	TIMESTAMP(0)
DRUG_TYPE	VARCHAR(100)
DRUG	VARCHAR(100)
DRUG_NAME_POE	VARCHAR(100)
DRUG_NAME_GENERIC	VARCHAR(100)
FORMULARY_DRUG_CD	VARCHAR(120)
GSN	VARCHAR(200)
NDC	VARCHAR(120)
PROD_STRENGTH	VARCHAR(120)
DOSE_VAL_RX	VARCHAR(120)
DOSE_UNIT_RX	VARCHAR(120)
FORM_VAL_DISP	VARCHAR(120)
FORM_UNIT_DISP	VARCHAR(120)
ROUTE	VARCHAR(120)

Detailed Description

SUBJECT_ID, HADM_ID, ICUSTAY_ID

Identifiers which specify the patient: SUBJECT_ID is unique to a patient, HADM_ID is unique to a patient hospital stay and ICUSTAY_ID is unique to a patient ICU stay.

STARTDATE, ENDDATE

STARTDATE and ENDDATE specify the date period for which the prescription was valid.

DRUG_TYPE

DRUG_TYPE provides the type of drug prescribed.

DRUG, DRUG_NAME_POE, DRUG_NAME_GENERIC

These columns are various representations of the drug prescribed to the patient.

FORMULARY_DRUG_CD, GSN, NDC

These columns provide a representation of the drug in various coding systems. GSN is the Generic Sequence Number. NDC is the National Drug Code

PROD_STRENGTH

DOSE_VAL_RX, DOSE_UNIT_RX

FORM_VAL_DISP, FORM_UNIT_DISP

ROUTE

The route prescribed for the drug.