omr table
The Online Medical Record (OMR) table contains miscellaneous information from the EHR.
Hosp
The Hosp module provides all data acquired from the hospital wide electronic health record. Information covered includes patient and admission information, laboratory measurements, microbiology, medication administration, and billed diagnoses.
The hosp module contains data derived from the hospital wide EHR. These measurements are predominantly recorded during the hospital stay, though some tables include data from outside the hospital as well (e.g. outpatient laboratory tests in labevents). Information includes patient and admission details (patients, admissions, transfers), laboratory measurements (labevents, d_labitems), microbiology cultures (microbiologyevents), provider orders (poe, poe_detail), medication administration (emar, emar_detail), medication prescription (prescriptions, pharmacy), hospital billing information (diagnoses_icd, d_icd_diagnoses, procedures_icd, d_icd_procedures, hcpcsevents, d_hcpcs, drgcodes), and hospital service related information (services).
provider table
The provider table lists deidentified provider identifiers used in the database.
admissions table
Detailed information about hospital stays.
d_hcpcs
Dimension table for hcpcsevents; provides a description of CPT codes.
d_icd_diagnoses
Dimension table for diagnoses_icd; provides a description of ICD-9/ICD-10 billed diagnoses.
d_icd_procedures
Dimension table for procedures_icd; provides a description of ICD-9/ICD-10 billed procedures.
d_labitems
Dimension table for labevents provides a description of all lab items.
diagnoses_icd
Billed ICD-9/ICD-10 diagnoses for hospitalizations.
drgcodes
Billed diagnosis related group (DRG) codes for hospitalizations.
emar
The Electronic Medicine Administration Record (eMAR); barcode scanning of medications at the time of administration.
emar_detail
Supplementary information for electronic administrations recorded in emar.
hpcsevents
Billed events occurring during the hospitalization. Includes CPT codes.
labevents
Laboratory measurements sourced from patient derived specimens.
microbiologyevents
Microbiology cultures.
patients table
Patients' gender, age, and date of death if information exists.
pharmacy
Formulary, dosing, and other information for prescribed medications.
poe
Orders made by providers relating to patient care.
poe_detail
Supplementary information for orders made by providers in the hospital.
prescriptions
Prescribed medications.
procedures_icd
Billed procedures for patients during their hospital stay.
services
The hospital service(s) which cared for the patient during their hospitalization.
transfers table
Detailed information about patients' unit transfers.
Feedback
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.
Last modified
November 13, 2022
: update hosp with changes in v2.0 and v2.1 (0c81de8)