Overstay Predictor Project: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(89 intermediate revisions by 7 users not shown)
Line 1: Line 1:
{{Project
|ProjectActive=legacy
|ProjectProgram=Med
|ProjectRequestor=Mary Ann Lynch and Dr Eberhard Renner
|ProjectCollectionStartDate=2012-11-05
|ProjectCollectionStopDate=2019-10-01
|Project={{PAGENAME}}
}}
{{LegacyContent
|explanation= no more [[overstay]] as of October 1, 2019
|content=


==Data collectors requirements==
'''''See [[Overstay Predictor Project Collection Instructions]] for collection instructions for this project.'''''


The data collectors on the unit will be asked to attend a general presentation to understand the transition coordinator role and plan. They will also be met with separately to discuss the following:
'''STOP DATE''': for any new admissions as of October 1, 2019.  Outstanding admission prior to October 1.19 must have overstay completed.--[[User:TOstryzniuk|Trish Ostryzniuk]] 16:50, 2019 November 18 (CST)


*how to use the additional data collection tool on their laptops
A small number of patients overstays for a significant amount of time after they are medically ready for discharge. Though the number of patients is small, a significant proportion of bed-days is wasted in the process. The Overstay Predictor Project uses an [[Overstay Predictor Project Algorithm | algorithm]] to that uses data collected by the Critical Care and Medicine Database to predict an overstay risk. This risk is communicated to ward staff using a red sticker on charts and a direct communication to the unit manager.
*where to find the Discharge planning screening tool
*implementing the sticker code on the charts
*documenting the patients name on the transition coordinators assignment sheet
*time frames for chart reviews


==Legacy==
see [[Overstay Project Start Stop dates | Implementation Dates]]


== Purpose ==
{{Data Integrity Check List|}}
A small number of patients overstays for a significant amount of time after they are medically ready for discharge. Though the number of patients is small, a significant proportion of bed-days is wasted in the process. We are piloting a process at the Grace where an "overstay coordinator" will be assigned to patients at risk of overstaying. Whether a patient is at risk is determined by the ward nurse assessing risk factors on a form, and by an assessment algorithm that takes into account the values mentioned as mandatory above; the combination of these results in a chart being assigned a colour sticker, and the transition coordinators monitor these chart stickers.
==Primary Investigator==
Primary Investigator: [[Dr. Dan Roberts]]
*Overstay Predictor Project for Medicine [http://ccmdb.kuality.ca/index.php/Minutes_Team_Meeting_December_5,_2011 - Dec 5.11 collection team meeting discussion item 6]
Contact Person:  Linda Hathout  391-5434 or LHathout@exchange.hsc.mb.ca
 
== Pilot Information ==
===Start Date ===
Actual Start Date: July 23rd 2012
=== End Date ===
there is no end date for the project at present; the committee will review results after 3 months and make adjustments at that time
 
== Instructions ==
For every '''medicine''' patient admitted to the Grace 5N, '''as soon as possible''', but definitely '''within 48 business hrs of admission''':
#Find the new white [[Media:Nursing_Discharge_Screening_Tool Nursing_Discharge_Screening_Tool.pdf|Nursing Discharge Screening Tool form]] on the chart. It will be with the admission documentation.
#*the form is to be dated and time stamped
#*For the first 6 check boxes on the form, create a record for each in tmp entries and check the check box if the answer is Yes.  (one to one from the form, no interpretation necessary)indicated if no answer is provided.
#*re question 4 (managing independently), if any of the boxes within question 4 are checked "no" or "x", the answer to question 4 should be checked "no"; all boxes within the question must be unmarked or given a check mark in order for question 4 to be checked "yes".
#the form is to be completed within 24 hours of admission; if it is not possible at time of admission, the admitting nurse will pass the responsibility for completion to the next duty nurse
#*The nurse can update the form within the first 24 hours after admission if, for example they receive information from the patients family that contradicts the patients answers. It is possible that depending on when you review that document these changes are not captured. This a known risk that has to be accepted.
#*If the form is '''not completed''' within the first 24 hours the data collector is to check with the bedside nurse and remind them to complete it?
*The information used in the predictor calculation is based on the minimal data set plus a handful of diagnostic codes that need to be checked for within the first 24 hours. The following as part of minimal data set:
#'''DOB'''
#'''Admit Date'''
#'''ADL'''
#'''CVA''' know or speculated as the admitting
#'''Dementia''' as an admitting reason or comorbid
#''whether there was a [[Overstay Predictor Diagnosis Code Used | permanent & severe neurological or spinal]] insult as an admitting diagnosis       
 
Once this information has been entered click the new “Overstay” button on the patient viewer form next to the notes field and it will turn a colour (colours based on an underlying algorithm too complicated to get into here, but based on tmp entries, age, comorbids, admit dxs and ADLs):
** GREEN - low/no risk for discharge issues
** YELLOW - some risk for discharge issues
** RED - significant risk for discharge issues assign a transition coordinator.
** GRAY - if some needed data is missing
 
* Based on the color displayed put that colored sticker on the patients chart. Stickers will be located adjacent to the transition coordinator binder at the unit clerk desk.
*if the patient has been designated as "red" for purposes of overstay prediction, the data collector will assign a Transition Coordinator by placing the patients name beside the transition coordinator on call for the time period of the patients admission. The transition coordinators will be assigned to cover between Friday to Monday, the next shift will go to Wednesday, the last will be Wednesday to Friday. If the designation is made after 1500 on the day of entry, the assignment will be deferred to the next day's coordinator. The rotation of Coordinators is made up of Home Care, Social Work, Physio, And OTs.  After assignment, that service is responsible for following that patient throughout their hospital stay.
 
[[File:Transition_coordinator4.gif]]
 
== [[Overstay Predictor Diagnosis Code Used]] ==
June 12.12- the list of [[Overstay Predictor Diagnosis Code Used]] to be used for the overstay predictor algorithm was '''approved''' by [[Dr. Dan Roberts]].  Submitted to [[Julie Mojica]] & [[Linda Hathout]].--[[User:TOstryzniuk|Trish Ostryzniuk]] 17:03, 2012 June 12 (CDT)
*Julie has connect with Rodrigo and update him.  Rodrigo is the person working on algorhythm.--[[User:TOstryzniuk|Trish Ostryzniuk]] 16:25, 2012 June 12 (CDT)
**NOTE: Prior to above, on April 27.12-only CVA 505 is included in the algorithm to generate the colour only data pertaining to CVA 505 was given to Rodrigo (the programmer) for overstay analysis as per Tina.
 
=Outstanding Issues & Questions=
 
=== If you can't find data  Question===
'''Clarify with the bedside nurse.'''
--[[User:LHathout|Linda Hathout]] 21:45, 2012 July 5 (CDT)
 
==== working diagnoses Question====
 
Occasionally the working diagnosis written by the MD is CVA but this has not been confirmed by CT; should this be coded in admission diagnosis anyway and then removed later if not confirmed?
*'''yes indicate the CVA if it is suspected even if not confirmed.'''--[[User:LHathout|Linda Hathout]] 21:48, 2012 July 5 (CDT)
 
===Programming Stuff===
==== testing for consistent data ====
{{Discussion}}
I intentionally left out one of the overstay questions in the temp file expecting to get a gray overstay predictor score indicating missing information but am getting yellow-is this correct?
* Program should not have let this through, I'll need to look into that. [[User:Ttenbergen|Ttenbergen]] 12:02, 2012 May 2 (CDT)
 
==== button colour persistence ====
#Every time I exit the Database and then reenter, I have to repress the overstay button as it has gone gray; reported on May 8.12.--[[User: SCortilet | Stephanie Cortilet]].
#*Will confirm process.--[[User:Ttenbergen|Ttenbergen]] 12:02, 2012 May 2 (CDT)
#**''This still an issue as of July 6.12''. [[User: SCortilet | Stephanie]]. {{Discussion}}
#Is the DX code for '''violent behaviour secondary to dementia''' included in the list?
#*I would say yes. Linda? --[[User:TOstryzniuk|Trish Ostryzniuk]] 13:03, 2012 July 6 (CDT){{Discussion}}
#Would it be helpful for us to note the reason the pt has stayed past the date it is noted they are medically stable somewhere; the chart usually notes whether the pt is being panelled, waiting for services or assessments etc. or whether the pt becomes "unstable" again while waiting for d/c (discharge).
#*'''The [[media:!Transition_Coordinator_June_27th.pdf]] will be documenting reasons for overstay.''' --[[User:LHathout|Linda Hathout]] 21:51, 2012 July 5 (CDT)
#*this link doesn't go anywhere, it goes to another WIKI with Homer Simpson on it, but none of us can log into it. [[User: SCortilet | Stephanie]]. {{Discussion}}
#Does the algorithm include age, and/or whether the patient originally came from a nursing home? Patients from an existing nursing home bed will not overstay as frequently as those from home.
#*'''All these factor have been considered. See [[Media:Two_Stage_Predictive_Model_of_Patients_in_Need_of_a_Transition_Coordinator.pdf]] Twostagepredictivemodel.pdf] for details'''--[[User:LHathout|Linda Hathout]] 21:51, 2012 July 5 (CDT)
#Is it possible for the 6 overstay requirements in the temp file to be generated automatically like the postal code is rather than having to add the 12 items manually?  we then would just have to check the box to answer each question
#*''? Can I get this resolved or answered please''?--[[User: SCortilet | Stephanie]].{{Discussion}}
#**?????
 
== Other Questions==
=== location of form and sticker ===
 
#Where on the chart will this new form be and will it be a colored form?--[[User:TOstryzniuk|Trish Ostryzniuk]] 10:43, 2012 April 24 (CDT)
#*''The form will be in the same section as the nursing database. Not sure about the colour. The sticker is 3/4 inch in diameter and needs to be placed on the spine of the chart. There is currently a small red dots used to indicate long term chart. This practice is being phased out''.--[[User:LHathout|Linda Hathout]] 22:04, 2012 July 5 (CDT)
#What is the purpose of putting the sticker on the chart; will this be looked for by other disciplines to identify the need for their intervention?
#*''see'' [[#Purpose]] ''at top of this article''. --[[User:Ttenbergen|Ttenbergen]] 11:56, 2012 May 2 (CDT)
 
=== no need to document sticker colour changes ===
#Will it be necessary to document a difference in sticker colours if we need to change the colour once the algorithm has run?
#* ''No need. The original colour is based on the items you enter into tmp, so we can go back from that if needed''. [[User:Ttenbergen|Ttenbergen]] 12:47, 2012 April 27 (CDT)
 
=== test scenarios for colours ===
#How can I test the yellow colour?-I can only get the overstay button to be red or green using multiple different combinations of the check boxes
#* ''Yellow would be based on a combination of comorbids and ADLs and age. Make a patient a little less sick and they will become yellow. Sorry, can't give you exact instructions, the algorithm is pretty messy''. [[User:Ttenbergen|Ttenbergen]] 12:47, 2012 April 27 (CDT)
 
=== admission times and conditions at admission ===
#The time we use as the time of admission will be different than the time of admission to the unit, and often significant time has passed between the 2 times so the information collected is different e.g. pt is confused at our admission time but by the time the patient goes to the unit, the patient is now A & O etc or vice versa.  Will this affect the algorithm?
#*''Use the data as you would have entered before as that is what the algorithm was based on. I hope that helps, since I know some collectors used to collect this much later''.--[[User:Ttenbergen|Ttenbergen]] 12:47, 2012 April 27 (CDT)
#**''Pls let me know if you need more info''.--[[User:Ttenbergen|Ttenbergen]] 12:47, 2012 April 27 (CDT)
#What if our assessment differs from that of the admitting nurse e.g. they ask the pt/family on admission if they have fallen within the past 6 months and are told no or the information is not available, and we see from looking through the chart that falls have been documented within this timeframe?
#*''Use the answer the nurse provides even if you disagree. We will be testing the answers provided by the nurses to determine if they are a better predictor of transition support needs or can be used in conjunction with existing admission data to improve the effectiveness of the prediction tool''.--[[User:LHathout|Linda Hathout]] 22:11, 2012 July 5 (CDT)
#Is the admission information the only source used or will the complications be taken into consideration e.g. if the pt develops a new cva as a complication do we redo the overstay predictor?
#*''Only data upon admission to the unit should be used''.--[[User:LHathout|Linda Hathout]] 22:11, 2012 July 5 (CDT)
#If the patient is transferred from one medical unit to another within the facility, is their overstay predictor redone or do they carry the one from the original admitting ward with them?
 
{{Discussion}}


== Related Articles ==
{{Related Articles}}


[[Category: OverstayProject]]
[[Category: OverstayProject]]
[[Category: All Projects]]
}}

Latest revision as of 12:32, 2020 April 9

Projects
Active?: legacy
Program: Med
Requestor: Mary Ann Lynch and Dr Eberhard Renner
Collection start: 2012-11-05
Collection end: 2019-10-01

Legacy Content

This page contains Legacy Content.
  • Explanation: no more overstay as of October 1, 2019
  • Successor: No successor was entered

Click Expand to show legacy content.

See Overstay Predictor Project Collection Instructions for collection instructions for this project.

STOP DATE: for any new admissions as of October 1, 2019. Outstanding admission prior to October 1.19 must have overstay completed.--Trish Ostryzniuk 16:50, 2019 November 18 (CST)

A small number of patients overstays for a significant amount of time after they are medically ready for discharge. Though the number of patients is small, a significant proportion of bed-days is wasted in the process. The Overstay Predictor Project uses an algorithm to that uses data collected by the Critical Care and Medicine Database to predict an overstay risk. This risk is communicated to ward staff using a red sticker on charts and a direct communication to the unit manager.

Legacy

see Implementation Dates

Data Integrity Checks (automatic list)

 AppStatus
Query check tmp generate allowedCCMDB.accdbimplemented
Query check overstay no colourCCMDB.accdbretired
Query check overstay pt from our medCCMDB.accdbretired
Query check overstay not enteredCCMDB.accdbretired

Related Articles

Related articles: