Requested CCMDB changes for the next version

From CCMDB Wiki
Jump to navigation Jump to search

see the Development Documentation Category for other development logs


Bug Fix Requests

Peer Audit

What do you suggest I do to fix these?

ICU auditing med and vice versa
  • There was no TASK item sent to TASKS_1_audit.mdb for peer audit GRA_111. Location was GRA_N5 but should of been GRA_N3. Regardless of location booboo there should be TASKS data in TASKS_1_audit.mdb. I think the reason no TASK data in TASKS_1_audit.mdb is because Marylou sent peer audit file 111 with non peer audit batch instead of sending it by itself as a 'a' peer audit file. Nothing to do with ICU. I understand that MaryLou, is picking up hours to cover because both Donna and Stephanie are away. If this is the case then Marylou needs to review Peer audit Wiki page. Interesting things show up when testing. --TOstryzniuk 18:50, 30 November 2009 (CST)
    • What does no task item have to do with location? Are we getting an ICU collector to collect on medicine or vice versa? That is not something we had in the design for the peer audit. The only way a collector would be able to send then would be to change the settings to CC/Med when sending audit data, and even that may not work because the checks are so different.
Exclusions in the audit
  • HSC_SICU - ... No audit number should go ... into tmpv2_1_audit.mdb. We are not auditing any of the special project for ICU. We are only including MOVE data for medicine in tmpV2_1_audit.mdb.
    • It will need to be stated for any future tmp studies if they are not included in the audit data. Otherwise the tmp audit checks will try to force entries.
    • pushy tmp files. SEE: TmpV2_1_audit.mdb. --TOstryzniuk 18:50, 30 November 2009 (CST)

Pending Testing / Answers

wrong location / Peer audit partner table

Create a table in ccmdb so We can change the partner at any time so that the put label would be ward that was actually audited. If implemented, would collectors have to select this when they send in the audit file? --TOstryzniuk 17:06, 24 November 2009 (CST)

  • Collectors were able to send patients with R_Location <> audit_location
    • added table "peer_audit_partners" and query "check_peer_audit_location_bad" to limit which patients can be sent as audits.Ttenbergen 11:18, 1 December 2009 (CST)
Pharmacy Check
  • pharmacy check for NO pharm not working in CCMDB. Email sent to Tina.
    • This happens because HSC doesn't collect Pharmacy and Trish and I both use HSC as the test location. If a different location is used, having no pharmacy entry will launch an error. See PharmCheck. Do you think that article should be linked into any of the collection instructions? Not really necessary since it will give proper errors, but up to you. Ttenbergen 15:51, 30 November 2009 (CST)
Admit 1 missing
  • STB MICU was able sent a profile with the admit 1 diagnosis blank. We are not sure who she was able to achieve this. Email sent to Tina and also Laura. --TOstryzniuk 20:35, 26 November 2009 (CST)
    • Found out in troubleshooting that Laura had tried to send a non-infection diagnosis with a pathogen. Trish was trying to find out the story from Laura to see if we can replicate the problem. Waiting to hear details. Ttenbergen 10:22, 30 November 2009 (CST)
Exclude peer audit serials from regular tmp sending query
  • Fix built as per Log. TtenbergenTtenbergen 11:35, 1 December 2009 (CST)
  • There should not be any data in TmpV2_1.mdb for audit file 111 HSC_SICU. How did it get in there is really the question. --TOstryzniuk 18:50, 30 November 2009 (CST)
    • actually, I think I understand now and it should be fixed. Ttenbergen 11:32, 1 December 2009 (CST)

Any tmp entries being sent immediately rather than upon finalcheck will send for audit as well.

  • Required Fix: fix the regular audit query to exclude serials < 111 and serials > 140.--TOstryzniuk 14:40, 30 November 2009 (CST)

The following are entry errors for which I can't think of a check. Suggestions anyone?

  • Missing MOVE date in TmpV2_1_ audit.mdb because audit file was sent with CSV batch.
    • sorry, still no idea what that means; was only the date missing? What does that have to do with the audit file being sent in csv batch? Are they not all sent in a csv batch? Ttenbergen 14:56, 30 November 2009 (CST)
      • A Peer Audit patient was sent with REGULAR batch of non Peer Audit files. It was not sent by itself. I suspect because it was not sent as an 'a' for audit batch by itself, that is why no move data made it into TmpV2_1_audit.mdb.--TOstryzniuk 18:50, 30 November 2009 (CST)
        • I suspect this is another case of mixing audit patients into regular and vice versa. The queries should now take care of that.
pending.mdb
  • Audit numbers should not go into pending.mdb--TOstryzniuk 19:21, 26 November 2009 (CST)
  • changed queries "pending_julie" and "pending_pagasa" to exclude audit serial numbers, see Log Ttenbergen 16:23, 30 November 2009 (CST)

Improvement Requests

Batch File Update - make versions

Change "News and backup" batch file and Updt all.bat to create a total of 20 previous versions for each location to retain data. Ttenbergen 12:21, 30 November 2009 (CST)

"Add Patient" button for patient list

Add a button that launches the view for a new patient (i.e. with the serial number dialog.)

Cancel for Settings

change the settings form to have a save and a cancel button...

Soft checks for Apache

Add warnings for values in the 1st and 99th percentile.

Changes Under Discussion

These requested changes can not be processed until the questions about them have been answered.

ARF & CRF & ARI Integrity Check

Implement rule as per Renal Coding Considerations

Template:Discussion

Discussion

There is a discussion about that rule in that article, so this check can't be implemented until the discussion is completed. Please continue discussion there to keep all in one place. Ttenbergen 11:00, 23 April 2009 (CDT)

VAP in medicine

VAP should not be coded as a complication in medicine.

Discussion

see VAP#Discussion - Coding VAP in Medicine


Wikis onto laptop

  • look into possibility of automatically downloading WIKI guide to laptop each day that it is synch'd. (portable version of guideline)--TOstryzniuk 20:11, 4 April 2009 (CDT)
  • As moved from Diagnosis Coding:
A suggestion has been put forth to Tina is to find a away to allow a downloaded copy of the WIKI guide on laptops, the collection tool we are moving to soon. I think this would be an excellent solution if she can do this. Collectors would then be able to search for info no matter where they are in the collection field and each time they synch there laptop, they would get updated WIKI items. That is the plan............but waiting to here from IT support.
It is challenge right now in that the guideline information is not easily and quickly accessible while you are doing your work in the unit or in medical records. Most collectors must run back to their office or find a free computer to log in and look up guide info.
Keep in mind, guide information changes regularily, so what you print out one day is outdated the next for a number of articles. TOstryzniuk 11:25, 29 April 2009 (CDT)


QA Functionality

Facilitate exchange of patient discharge times

DCs have to know the discharge times for patients arriving at their wards from another collected ward. We should automate that rather than have them exchange manually. Might be an extension of the status file for Julie...Ttenbergen 16:05, 3 February 2009 (CST)

Logging errors in the CCMDB.mdb

Add a table to the CCMDB that records every time an error is generated with the following details:

  • Date/time of error
  • patient ID (Hosp Loc Serial)
  • Field Identifier
  • error descriptor (text)
  • erroneous value

Make that table sync to a central repository on send.


After-Laptop changes

Improve Data Entry for Tasks

make tasks easier to enter, e.g. a checklist

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Requested_CCMDB_changes_for_the_next_version&oldid=16025"