Change to collect TISS data in CCI Picklist

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
  • Some data even before this change over might only be available in CCI, see #Phase-out of TISS scanning process

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.