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

Infection without pathogen subcode was sent to csv

Oaks - Patient coded for Cystitis Bladder Infection but no sub code? Admit date Jan 25/10-Jan. 30/10. Pagasa Torres.

Object With Variable - possible solution

Migth be a problem with the procedure that sets thisdb to be called wherever a dataset is opened. If the procedure setting this crashes, further code will not have access to the data. Found while working on the Audit DB. Ttenbergen 17:15, 28 January 2010 (CST)

Fix Unable to sent OR Dx Bug

If no priority is assigned to a diagnosis it defaults to priority 0. This means you end up with a duplicate priorities, which in turn means that the "order" of the diagnoses is not defined. So, even though the OR Dx might list first, it is not "first" as far as Access is concerned. I will need to make the order explicit (i.e. order by priority first and by dxcode second) for both the send_dxs table and the data source for the dx form.Ttenbergen 16:57, 28 January 2010 (CST)

Make Pathogens listing wider

Right now not the whole width of items is shown. Ttenbergen 14:54, 28 January 2010 (CST)

      • Is it possible to list everything alphabetically? It would just be more efficient. Perhaps this is only a laptop problem? NMiller 28 January 2010
        • I believe there was some reasoning for listing the pathogens in their numbered order. Trish? Ttenbergen 11:03, 29 January 2010 (CST)

WBC = 0 does not uncheck apache box

As per email from Pagasa, and confirmed by Tina, 28 jan 2010 Ttenbergen 14:32, 28 January 2010 (CST)

There may also still be a problem with sending very low numbers. Lois apparently thought she entered and sent WBC with a value of 0.02, which CCMDB.mdb should accept, but may not send properly. Ttenbergen 12:58, 29 January 2010 (CST)

Apache Score Helper

Make Apache score "helpers" to do those nasty calculations for AaDO2 and mean BP. Put ApPts with the other fields to help choose. (credit to Marie Laporte for suggestion)Ttenbergen 14:32, 28 January 2010 (CST)

extra "pathogens"

Put the "waiting for tests" and "review" into pathogens, make sure they would be caught as unacceptable, conditional-format them in orange. This is to eliminate one of the spots where people use paper/notes at this point to keep track, this could eliminate that need. (credit to Marie Laporte for suggestion)Ttenbergen 14:32, 28 January 2010 (CST)

ATN, Renal Transplant & CRF

Pathogen deleted will not send DX

TOstryzniuk 12:03, 22 December 2009 (CST)

Implemented as of CCMDB.mdb_Change_Log_2009#v_1.99

Make sure setting delete checks if settings are present

TOstryzniuk 12:03, 22 December 2009 (CST)

Implemented as of CCMDB.mdb_Change_Log_2009#Changes

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.
    • 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.


QA Septic Shock date

change end date as per QA_Septic_Shock#End DateTtenbergen 15:05, 8 February 2010 (CST)

Improvement Requests

Discharge Date & Pending.mdb

What I have noticed is when a data collector enters a discharge date but "no time", the PDA Status report shows the date with a time of 0:00 however, when these files get sent to Pending.mdb which is in the output folder on the Regional Server, the date field is totally blank. Julie would like the discharge date to show up in Pending.mdb even if the "time" is not yet available. She needs this information for occupancy report which she does monthly. --TOstryzniuk 13:02, 25 January 2010 (CST)

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...

No can do. There are is a sb-form in settings form that would not be cancelled, so having a cancel would be misleading.

This can be deleted. Ttenbergen 12:44, 23 December 2009 (CST)

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=17421"