Change to collect TISS data in CCI Picklist: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 22: Line 22:
=== Making it easier to enter these... ===
=== Making it easier to enter these... ===
We will add some tools to [[Patient Viewer Tab CCI_Pick]] to make it a bit easier to enter TISS items. [[TISS Item List|TISS items]] 2, 3, 4 are commonly used so good for testing.
We will add some tools to [[Patient Viewer Tab CCI_Pick]] to make it a bit easier to enter TISS items. [[TISS Item List|TISS items]] 2, 3, 4 are commonly used so good for testing.
 
==== Tools that have been added ====
* Buttons to enter TISS items
** click to enter a new Acquired px for that TISS item
** hover over the button to see the description
 
* Filter button
** Click the "TISS" button in the bottom right corner to filter the CCI Pick tab to only TISS items. Click it again to see all.
 
==== Tools under discussion ====
* dropdown?  
* dropdown?  
** I suggest to  show up the 21 subset TISS items first in the down list and the others not in the subset after or last. --[[User:JMojica|JMojica]] 09:18, 2020 November 25 (CST)   
** I suggest to  show up the 21 subset TISS items first in the down list and the others not in the subset after or last. --[[User:JMojica|JMojica]] 09:18, 2020 November 25 (CST)   
** possibly a second drop-down, but I am not sure how that would best work.  
** possibly a second drop-down, but I am not sure how that would best work.  
{{Discuss |
* How strongly do people feel that a dropdown would be better? Unlike the buttons it would require additional clicking, scrolling and mouse movements. Please convince me why this would be better. [[User:Ttenbergen|Ttenbergen]] 12:11, 2020 December 3 (CST)
}}


* buttons?
==== Tools that were not added and why ====
** a set of buttons at the bottom of [[Patient Viewer Tab CCI_Pick]] for the all TISS items
*** I just am not sure if that is really helpful because I don't know if people have these memorized. alternatively, a second dropdown with just TISS stuff, but that would be trickier to set up. [[User:Ttenbergen|Ttenbergen]] 22:58, 2020 November 25 (CST)
 
* own tab?
** several people suggested putting these in their own tab; for now I made a filter button in the [[Patient Viewer Tab CCI_Pick]] instead, which essentially turns that tab into a TISS tab as needed
 
* display as spreadsheet in similar format to how TISS sheet looks now?  
* display as spreadsheet in similar format to how TISS sheet looks now?  
** That would be neat, but there are two problems: (1) there is limited space on our screen, and TISS is sparsely entered, so this would waste a lot of space, but more importantly (2) we store the TISS info in a way that makes it basically impossible to show it in a two dimensional format like that and yet have it editable. [[User:Ttenbergen|Ttenbergen]] 09:36, 2020 December 1 (CST)
** That would be neat, but there are two problems: (1) there is limited space on our screen, and TISS is sparsely entered, so this would waste a lot of space, but more importantly (2) we store the TISS info in a way that makes it basically impossible to show it in a two dimensional format like that and yet have it editable. [[User:Ttenbergen|Ttenbergen]] 09:36, 2020 December 1 (CST)


 
* own tab?
{{Discuss |
** several people suggested putting these in their own tab;
* other suggestions to speed up entering these?
*** added filter button instead, which essentially turns that tab into a TISS tab as needed
* I think the TISS data should have it's own tab (perhaps next to the Tmp tab).  When the TISS tab would be accessed the whole page should open up, like a spreadsheet.  The date (time if needed) and all the TISS entries would be completed on this spread sheet daily.  This would be easier to follow instead of being mixed in with the CCI pick, for the data collectors and Pagasa.[[User:Gens|Gens]] 12:14, 2020 November 27 (CST)gens
** That would be neat, but there are two problems: (1) there is limited space on our screen, and TISS is sparsely entered, so this would waste a lot of space, but more importantly (2) we store the TISS info in a way that makes it basically impossible to show it in a two dimensional format like that and yet have it editable. BTW, Pagasa doesn't view TISS using the same tool as collectors, and I will work separately with her on what tools will be needed now that TISS will no longer come in on forms. [[User:Ttenbergen|Ttenbergen]] 09:36, 2020 December 1 (CST)
* Steph 27Nov2020 -
**please put in a separate tab  
*** I have added a button to just filter to TISS items instead of making a new tab; a new tab would mean maintaining two tabs, and as long as the only thing we are doing different is to limit the list to TISS items, a filter will do the same. [[User:Ttenbergen|Ttenbergen]] 09:36, 2020 December 1 (CST)
** please prioritize/list first the 21 we are doing the majority of the time
*** I have no idea which those are, that was all agreed on while I was away and the wiki has not been updated with the info [[User:Ttenbergen|Ttenbergen]] 09:36, 2020 December 1 (CST)
 
}}


== Phase-out of TISS scanning process ==
== Phase-out of TISS scanning process ==

Revision as of 13:11, 2020 December 3

We are changing the collection and storage of TISS data to enter it directly into the Patient Viewer Tab CCI_Pick.

Start Date: Dec 7, 2020.

Collection instructions

You can filter the Patient Viewer Tab CCI_Pick for only TISS entries using the "TISS" button in the bottom left corner.

The easiest way to enter a new TISS item is to use the corresponding button in the row of numbered buttons on the bottom of the screen. If you can't remember the item numbers, then (a) hovering over the button will give you the descriptions or (b) you can click on the wiki link just to the left of the numbered buttons to open the wiki page TISS Item List.

First entry per day

  • For every day of any item on the TISS Item List entered that item's CCI Picklist entry as Acquired Procedure. Enter the date but no time.
  • If no TISS item was done for a patient, enter a line "No TISS Item" and the date but no time.
  • To enter a TISS item of the same kind for the next day or unit, click the "x2" button and then the "+" for to increase the date.

Additional entries on a day

  • add the time: for the second and any additional TISS CCI entries on a day, enter as Px Date the full unit start date and time as per that unit's Boarding Loc entry.
  • If no TISS item was done on the second or succeeding location, enter a line "No TISS Item" with that location's Boarding Loc date and time for each

A patient may change locations (or units) during a day (a location or unit can be ER, Recovery Room, HSC MICU, HSC SICU, HSC IICU, STB ICMS, STB ACCU, STB ICCS, GRA ICU or any boarding location). If this happens, we need to be able enter a second TISS entry and to assign the TISS entry to a specific location (or unit). This is done by entering the unit start date and time into the Px Date (this is the only reason you would add a time to this field).

Making it easier to enter these...

We will add some tools to Patient Viewer Tab CCI_Pick to make it a bit easier to enter TISS items. TISS items 2, 3, 4 are commonly used so good for testing.

Tools that have been added

  • Buttons to enter TISS items
    • click to enter a new Acquired px for that TISS item
    • hover over the button to see the description
  • Filter button
    • Click the "TISS" button in the bottom right corner to filter the CCI Pick tab to only TISS items. Click it again to see all.

Tools under discussion

  • dropdown?
    • I suggest to show up the 21 subset TISS items first in the down list and the others not in the subset after or last. --JMojica 09:18, 2020 November 25 (CST)
    • possibly a second drop-down, but I am not sure how that would best work.
  • How strongly do people feel that a dropdown would be better? Unlike the buttons it would require additional clicking, scrolling and mouse movements. Please convince me why this would be better. Ttenbergen 12:11, 2020 December 3 (CST)
  • SMW


  • Cargo


  • Categories

Tools that were not added and why

  • display as spreadsheet in similar format to how TISS sheet looks now?
    • That would be neat, but there are two problems: (1) there is limited space on our screen, and TISS is sparsely entered, so this would waste a lot of space, but more importantly (2) we store the TISS info in a way that makes it basically impossible to show it in a two dimensional format like that and yet have it editable. Ttenbergen 09:36, 2020 December 1 (CST)
  • own tab?
    • several people suggested putting these in their own tab;
      • added filter button instead, which essentially turns that tab into a TISS tab as needed

Phase-out of TISS scanning process

Pagasa would scan any forms that are at least partly before the transition date. If forms later than that were scanned that would not harm anything, it would just be a waste of time. We would need to either exclude scanned data after the transition date, or write a query to delete it outright.

Implementation

To Do

When this is settled, there need to be wiki updates to many pages:

  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Cross checks

TISS quality checks#TISS checks run in Data Processing has a list, these need to be reviewed and some implemented in CCMDB.accdb

  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Background

It was decided at Task meeting that we would stop collecting TISS data on the pink sheets and instead enter it directly into CCMDB.accdb.

There are several reasons to do this:

  • now that we do all the collection of this, the TISS sheets have really just become a different place where our collectors enter data; if we are doing it anyway, might as well enter straight into electronic format
  • processing TISS forms relies on a complicated scanning, import and matching process; entering the data directly means we can drop that process
  • eliminating the TISS forms eliminates handling of paper forms from COVID zones
  • TISS items can be populated earlier and need not wait until the patient is discharged out of the hospital (as what was happening when having TISS forms) - availability of TISS data are sooner and lesser wait compared with having the TISS forms.

Related articles

Related articles: