Overstay Predictor Project Collection Instructions
This article explains how to collect data in the CCMDB.mdb for the Overstay Predictor Project.
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 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".
- Template:Discussionthe above instructions are very unclear: should the boxes be checked if the pt is independent or not independent?
- When I look at the form, the statement seems clear to me: if they have support, check. if they have supports for all, then the main box becomes a "y" checked. Are you maybe referring to an earlier version of the form? Ttenbergen 16:45, 2012 July 12 (CDT)Template:Discussion
- Template:Discussionthe above instructions are very unclear: should the boxes be checked if the pt is independent or not independent?
- 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; also, there will be a tmp table entry added to track this (Tina To Do) Template:Question IT
- The information used in the predictor calculation is based on the Minimal Data Set 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 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.
If you can't find data
Clarify with the bedside nurse.
If occasionally there is a working diagnosis written by the MD as "CVA" but this has not been confirmed by CT, then record the DX as CVA if it is suspected even if not confirmed.--Linda Hathout 21:48, 2012 July 5 (CDT)
location of form and sticker
- Where on the chart will this new form be and will it be a colored form?--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.--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. --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. 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. 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.--Ttenbergen 12:47, 2012 April 27 (CDT)
- Pls let me know if you need more info.--Ttenbergen 12:47, 2012 April 27 (CDT)
- 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.--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.--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.--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?
- so will these no longer be coded in comorbids? Stephanie
- you will still continue to code comorbid conditions the same way as you do now. The list of admit and acquired complications is only for the the predictor algorithm. Trish Ostryzniuk 14:29, 2012 June 12 (CDT)
Programming Stuff
testing for consistent data
Template: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. 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.-- Stephanie Cortilet.
- Will confirm process.--Ttenbergen 12:02, 2012 May 2 (CDT)
- This still an issue as of July 6.12. Stephanie. Template:Discussion
- Will confirm process.--Ttenbergen 12:02, 2012 May 2 (CDT)
- Is the DX code for violent behaviour secondary to dementia included in the list?
- I would say yes. Linda will check with Julie Mojica--Trish Ostryzniuk 13:03, 2012 July 6 (CDT)Template:Discussion
- Would it be helpful for us to note the reason the patinet 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 Transition Coordinator will be documenting reasons for overstay.--Linda Hathout 21:51, 2012 July 5 (CDT)
- Trish is getting and internet explorer run time error when she tries to open above link.Trish Ostryzniuk 15:51, 2012 July 12 (CDT) Template:Discussion.
- The Transition Coordinator will be documenting reasons for overstay.--Linda Hathout 21:51, 2012 July 5 (CDT)
- 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--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?-- Stephanie.Template:Discussion
- ?????
- ? Can I get this resolved or answered please?-- Stephanie.Template:Discussion
- 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