Hosp

The Hosp module provides all data acquired from the hospital wide electronic health record. Information covered includes 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 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 service related information (services).


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 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.

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.