Requested CCMDB changes for the next version: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
Line 5: Line 5:
== Bug Fix Requests ==
== Bug Fix Requests ==


=== Peer Audit ===
===Pathogen deleted will not send DX===
==== What do you suggest I do to fix these? ====
[[User:TOstryzniuk|TOstryzniuk]] 12:03, 22 December 2009 (CST)
===== ICU auditing med and vice versa =====


**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.
===Make sure setting delete checks if settings are present===
***(rephrase:)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. --[[User:TOstryzniuk|TOstryzniuk]] 18:50, 30 November 2009 (CST)
[[User:TOstryzniuk|TOstryzniuk]] 12:03, 22 December 2009 (CST)


***I think I answered your question Tina, if so you can remove this one.--[[User:TOstryzniuk|TOstryzniuk]] 20:42, 1 December 2009 (CST)
=== Peer Audit ===


===== Exclusions in the audit =====
==== 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.  
*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.
** 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]]. --[[User:TOstryzniuk|TOstryzniuk]] 18:50, 30 November 2009 (CST)
***Tina please take the tmps out for the peer audits.  Catheter 09.---[[User:TOstryzniuk|TOstryzniuk]] 12:03, 22 December 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? --[[User:TOstryzniuk|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.[[User:Ttenbergen|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. [[User:Ttenbergen|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.  --[[User:TOstryzniuk|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. [[User:Ttenbergen|Ttenbergen]] 10:22, 30 November 2009 (CST)
 
===== Exclude peer audit serials from regular tmp sending query =====
* '''Fix built as per [[Log]]. [[User:Ttenbergen|Ttenbergen]]'''[[User:Ttenbergen|Ttenbergen]] 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. --[[User:TOstryzniuk|TOstryzniuk]] 18:50, 30 November 2009 (CST)
** actually, I think I understand now and it should be fixed. [[User:Ttenbergen|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'''.--[[User:TOstryzniuk|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? [[User:Ttenbergen|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]].--[[User:TOstryzniuk|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--[[User:TOstryzniuk|TOstryzniuk]] 19:21, 26 November 2009 (CST)
* changed queries "pending_julie" and "pending_pagasa" to exclude audit serial numbers, see [[Log]] [[User:Ttenbergen|Ttenbergen]] 16:23, 30 November 2009 (CST)


== Improvement Requests ==
== Improvement Requests ==

Revision as of 13:03, 22 December 2009

see the Development Documentation Category for other development logs


Bug Fix Requests

Pathogen deleted will not send DX

TOstryzniuk 12:03, 22 December 2009 (CST)

Make sure setting delete checks if settings are present

TOstryzniuk 12:03, 22 December 2009 (CST)

Peer Audit

Exclusions in the audit

  • 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.
      • Tina please take the tmps out for the peer audits. Catheter 09.---TOstryzniuk 12:03, 22 December 2009 (CST)

Improvement Requests

batch file checks

make sure the batch file complains noisily if it does not have a server connection. Ttenbergen 09:47, 18 December 2009 (CST)

Final Check into drop-down

Make final check into a drop down to comply with requirement for stating the status within the process of data once we store data on U of M. Ttenbergen 13:25, 8 December 2009 (CST)

Batch File Update - make versions

Change batch files 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=16378"