Transfer Ready Access database

This article refers to a legacy project, this was not pursued further.

Purpose

ICU transfer tracking paper log – (implemented by Dr. Gray and Dr. Garland as an attempt to find a possibly more reliable way to get transfer ready dates for ICU). If more reliable then administration will approve that data collector's stop collecting this information from the ICU charts.

The Process

1. HSC_ICU calls admitting department when patient is transfer ready.
2. Admitting clerk records transfer ready on form.
3. Denise Felbel faxes form to Wendy Sebastianowich (Perry Gray’s admin assist). Form faxed when page is full.
4. Wendy faxes form to data processing office, JJ387.
5. Date is entered into an Access Database on our share drive X (Transfer_Ready_Tracker.mdb)

\\HSC1MSfP001\Med_CCMDB_Special_Projects\Transfer_READY_Tracker--TOstryzniuk 17:58, 30 November 2009 (CST) GO TO: ICU transfer ready discussion

Start Date

• March 2.09

Analysis

• March 2-April 24, 2009. Quality of data poor. For more information contact: JMojica
  • Form change recommended and implemented. Date: May 20, 2009
    • data has not be further reviewed by Mojica, Gray, Garland, Roberts, Rock

Stop Date

• May 3, 2010 - trial stopped.
• It has been agreed by the Database Steering Committee to stop the transfer/discharge ready tracking logs that are being sent to our database program from the admitting department here at HSC. We have trialed this process since March 1.09 on the recommendation from the ICU Database Task Group that transfer/discharge ready information that is being collected by data collectors was not reliable or precise enough and that we should stop collecting it. We were looking for an opportunity to also decrease some of the collection workload on a data collector.
• This alternate process and source of transfer/discharge ready information did not prove to be more reliable or precise than what the data collector picks up in charts in the ICU. The efforts spent in deciphering and manually entering the information was extremely time consuming due to the poor hand writing and incomplete information that was written on these forms. Data entry staff had to look up the patient names on these forms in the hospital ADT or in the ICU database before they manually entering info into an electronic format that the Statistician could analyze. There were many name spelling errors, blank fields, fields with incorrect information, patient information duplicated on the forms. 21% of patients were missing from the tracking log. (this is an earlier analysis).
• Betty Lou Rock has asked Linda Hathout to attend the Critical Care Coordinating team meeting and explore with this team further ideas that ICU would like to pursue to gather this information.

Data Entry

• March 2. 2009 to to Jan 10. 2010