DataMergeR

ICU DataMergeR 

ICU DataMergeR – is a program that assembles large datasets into the 1 patient : 1 row format (1:1).

The dataset is assembled based upon days – such as Day 1, 2, 3, 7, 14, 21

Currently DataMergeR can assemble the following tables:

• Admissions (1 patient : 1 row)
• Labs (1 patient : n row)
• Fluids (1 patient : n row)
• Vitals (1 patient : 1 row per day)
• Nursing (1 patient : 1 row per day)
• TISS (1 patient : 1 row per day)
• Treatments (1 patient : 1 row per day)

Datasets:

DataMergeR handles the following types of datasets:

1 patient : 1 row (i.e. Admissions table)

1 patient : n row (i.e. Labs, Fluids table)

• This data needs to be aggregated on a daily basis
• Aggregation – there are 10 standard aggregation types that can be done is SQL: (count, mean, SD, variance, mode, median, lower quartile, upper quartile, min, max)

1 patient : 1 row per day (i.e. Vitals, Nursing, TISS, Treatments)

Performance:

• Takes about 90 seconds to assemble 1 Patients worth of data (Day 1, 2, 3, 7, 14, 21)

Outstanding Tasks/Issues:

1 patient : 1 time spanning row (i.e. Pharmacy, Microbiology, Radiology)

First 24 hours, 24-48 hours, 48-72 hours
This would only affect Labs and Pharmacy

Increase/Decrease Values

Performance (how to optimize)

Clinic DataMergeR

Clinic DataMergeR – is a program that assembles clinic data (where the results may be recorded over days, weeks or months).  It then assembles the data into a 1 patient : 1 row format (1:1).