Dimension table for hcpcsevents; provides a description of CPT codes.
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).
Dimension table for diagnoses_icd; provides a description of ICD-9/ICD-10 billed diagnoses.
Dimension table for procedures_icd; provides a description of ICD-9/ICD-10 billed procedures.
Dimension table for labevents; provides a description of all lab items.
Billed ICD-9/ICD-10 diagnoses for hospitalizations.
Billed DRG codes for hospitalizations.
The Electronic Medicine Administration Record (eMAR); barcode scanning of medications at the time of administration.
Supplementary information for electronic administrations recorded in emar.
Billed events occurring during the hospitalization. Includes CPT codes.
Laboratory measurements sourced from patient derived specimens.
Formulary, dosing, and other information for prescribed medications.
Orders made by providers relating to patient care.
Supplementary information for orders made by providers in the hospital.
Billed procedures for patients during their hospital stay.
The hospital service(s) which cared for the patient during their hospitalization.
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.