Patient Record + DRG | Tableau Exchange

Patient Record + DRG

by Tableau

Description

The Tableau Accelerator for Patient Record + DRG gives you a jumpstart to getting data-driven insights into patient records. You can use this Accelerator to better understand patient stays and how they have evolved.

LOS stands for length of stay (measured in days).

A diagnosis-related group (DRG) is a patient classification system that standardizes prospective payment to hospitals and encourages cost containment initiatives. In general, a DRG payment covers all charges associated with an inpatient stay from the time of admission to discharge. The DRG includes any services performed by an outside provider.

DRG-Inliers % represents the share of stays for which the LOS was between the two LOS thresholds recommended for this DRG.

Answer key business questions

  • How many stays do we handle? Which trends?
  • What it the typical LOS by specialty? How does it compare to the benchmark LOS?
  • What is the share of DRG-inliers?
  • How many discharges are done before noon?
  • What is the share of inpatient stays?
  • What is our average Cost-weight per stay? How does it evolve?

Monitor and improve KPIs

  • Nb of Stays
  • Nb of Inpatient Stays
  • LOS (days)
  • LOS (△ vs Benchmark)
  • Emergency Admissions
  • Deceases
  • Dead Patient Age
  • Nb of Patients
  • Patient Age
  • Discharges before midday
  • Total Cost-Weight
  • Cost-Weight per Stay
  • DRG - Nb of Inliers
  • DRG - Nb of Outliers
  • DRG - Nb of Low Outliers
  • DRG - Nb of Low Inliers
  • DRG - Nb of High Inliers
  • DRG - Nb of High Outliers
  • Inpatient Stays %
  • Emergency Admissions %
  • Deceases % on patients
  • Stays per Patient
  • Discharges before midday %
  • DRG - Inliers %
  • DRG - Outliers %
  • DRG - Low Outliers %
  • DRG - Low Inliers %
  • DRG - High Inliers %
  • DRG - High Outliers %

Required attributes

  • Facility (string)
  • Stay # (string)
  • Stay Type (string) ← expected values: 'Inpatient', 'Outpatient'
  • Inpatient Flag (string) ← expected values: 'Y', 'N'. 'Y' if Stay Type is Inpatient
  • Patient # (string)
  • Specialty (string)
  • Service (string)
  • Doctor (string)
  • Main Diagnosis (string)
  • Main Treatment (string)
  • Admission Date (date)
  • Discharge Date (date)
  • Birth Date (date)
  • Gender (string)
  • Admission Mode (string)
  • Admission - Emergency Flag (string) ← expected values: 'Y', 'N'. 'Y' means the admission was an emergency.
  • Discharge Mode (string)
  • Discharge - Decease Flag (string) ← expected values: 'Y', 'N'. 'Y' means the discharge is due to a decease.
  • DRG Code - Diagnosis Related Group (string)
  • DRG Status (string) ← expected values: 'Low Outliers', 'Low Inliers', 'High Inliers', High Outliers'
  • LOS (days) - Length of Stay (numeric)
  • DRG - LOS Benchmark (numeric)
  • DRG Cost-Weight (numeric)

Tech Specifications

Supported Layouts

Security and Legal

Accelerator