PatientFollow Project

Our database collects patient ward stays, which means the data of a patient may be processed by several collectors during the admission. This leads to extra, wasted work of different collectors familiarizing themselves with the same patient. We are looking at ways to reduce this waste.

Specifically, we are looking into having a single collector/laptop follow a patient for their whole admission, and how our processes would need to change to accommodate this, and what extra tools we might need.

Pilot

• one or two collectors at HSC will do collection like this for specific patients in coordination with main office to better understand how this would work

prerequisites for pilot participation

For a collector to be able to follow to another ward and enter that as a Service/Location we need to add the additional wards to the laptop's S locations allowed collection table entries in CCMDB.mdb. This has been done for:

• HSC H4 laptop

Identifying admissions / Starting collection

Currently patients are assigned to collectors/laptops based on where they are admitted. To change to the new system, we would need to identify patients who enter a given site and then assign them to the collector pool equitably.

Currently, our thought is that this will be done based on the last two digits of the chart number. We think chart numbers would work because

• determine if those last digits are equally distributed
• determine total EFT per site, and percentage of total of a given collector
• assign a portion of last digits of charts to each collector
• for example, if a site has 3 collectors that are each a .5EFT, each collector would get 33% of that site's new admissions, so collector A might get charts ending in 00-33, collector B 34-66, and collector C 67-99

Tina has taken a basic look at the distribution of these numbers and emailed Julie and Trish for feedback. Ttenbergen 17:31, 2019 August 1 (CDT)

Entering into the laptop

The initial ward would need to be entered as usual. For stays on subsequent wards the Patient copier button can be used to create the next record.

Additional things we might be able to copy in the future are (not implemented now to allow general use of the copier button):

• Visit Admit Date and time
• import dispo and dispo_dttm (+ 5 min) into the previous location and arrive_dttm automatically

Thoughts?

As usual, if you have thoughts or ideas about this, please post them here.

• I think this is a good starting strategy to allocate patients among the data collectors proportionately in each site. This strategy also implies that a DC can do ICU/Med patients. The one thing which is unclear yet to me is how to make sure we will not miss any patient in a given ward(Med/ICU) using this strategy. Who will be responsible to check or monitor that all patients who were admitted in a given ward are already entered in all laptops? How long will the DC run after that patient who left the ward but still in the hospital? How easy to catch those transfers from other service who haven't been in ICU/Med and now have been admitted to ICU/Med service? For now, these are my thoughts. --JMojica 15:32, 2019 August 6 (CDT)