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

From CCMDB Wiki
Jump to navigation Jump to search
 
(33 intermediate revisions by 6 users not shown)
Line 1: Line 1:
We are changing the collection and storage of TISS data to enter it directly into the [[CCI Picklist]] form.
We are changing the collection and storage of TISS data to enter it directly into the [[Patient Viewer Tab CCI_Pick]].  
 
'''We have not set a change date for this yet. Tentatively Dec 1, 2020.''' Read the instructions, and even try to enter one of these to see how that would work for collectors, just delete them before sending.  


== Collection instructions ==
== Collection instructions ==
=== First entry per day ===
See [[Collection of TISS data in CCI Picklist]] for current collection instructions. This page is about the changes that were made, so not the place for current instructions.  
* 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 ===
=== Making it easier to enter these... ===
* '''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''.
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.
* 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 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).
==== Tools that have been added ====
I 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).
* Buttons to enter TISS items
** click to enter a new Acquired px for that TISS item
** hover over the button to see the description


=== Making it easier to enter these... ===
* Filter buttons
[[TISS Item List|TISS items]] 2, 3, 4 are commmonly used so good for testing.
** Click the "TISS" button in the bottom right corner to filter the CCI Pick tab to only TISS items. Click the "CCI" button to only see CCI entries. Click either toggled button to again see all CCI Picklist items.
* 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) 
** possibly a second drop-down, but I am not sure how that would best work.  


* buttons?  
==== Tools that were not added and why ====
** we will probably add some tools to CCMDB to make it a bit easier to enter them; some things that come to mind would be some buttons at the bottom for the most common TISS items (what are those). Depending on what we want this will need to come later when there is time to implement it.
* display as spreadsheet in similar format to how TISS sheet looks now?  
*** I was actually thinking about adding buttons down the left side to generate an acquired px of that number TISS with one click - 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)
** 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)


{{Discuss |
* own tab?
* other suggestions to speed up entering these?
** several people suggested putting these in their own tab;
}}
*** added filter button instead, which essentially turns that tab into a TISS tab as needed


{{TT | when settled we need to update [[L CCI Picklist subform]] page }}
== Phase-out of TISS scanning process ==
The TISS scanning is phased out '''July 31, 2021'''.


== Phase-out of TISS scanning process ==
Pagasa scanned forms for admissions before Dec 7, 2020 where the form was available before July 31, 2021. For any data only available after '''July 31, 2021''' the data will be entered in CCI even for TISS items before Dec 7, 2020. We will combine this data programmatically in our data.
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 ==
== Change date ==
* a line for each item in [[TISS Item List]] has been added to the [[S CCI Picklist table]]
*Start date to enter TISS as CCI: '''Dec 7, 2020'''
*Last date for TISS form entries: Dec 6, 2020
**Some data even before this change over might only be available in CCI, see [[#Phase-out of TISS scanning process]]


== To Do ==
== Cross checks ==
{{TT|
[[TISS quality checks#TISS checks run in Data Processing]] were reviewed and use new data structure now.
When this is settled, [[TISS28 Collection Guide]] and many pages in [[:Category:TISS28]] will need to be updated. }}


== Background ==
== Background ==

Latest revision as of 16:01, 2023 October 31

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

Collection instructions

See Collection of TISS data in CCI Picklist for current collection instructions. This page is about the changes that were made, so not the place for current instructions.

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 buttons
    • Click the "TISS" button in the bottom right corner to filter the CCI Pick tab to only TISS items. Click the "CCI" button to only see CCI entries. Click either toggled button to again see all CCI Picklist items.

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

The TISS scanning is phased out July 31, 2021.

Pagasa scanned forms for admissions before Dec 7, 2020 where the form was available before July 31, 2021. For any data only available after July 31, 2021 the data will be entered in CCI even for TISS items before Dec 7, 2020. We will combine this data programmatically in our data.

Change date

  • Start date to enter TISS as CCI: Dec 7, 2020
  • Last date for TISS form entries: Dec 6, 2020

Cross checks

TISS quality checks#TISS checks run in Data Processing were reviewed and use new data structure now.

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: