Requested CCMDB changes for the next version
see the Development Documentation Category for other development logs
Bug Fix Requests
Pharmacy Check
- pharmacy check for NO pharm not working in CCMDB. Email sent to Tina.
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)
Peer Audit
SEE Peer Audit output problem table - this just summarizes testing problems.--TOstryzniuk 19:55, 26 November 2009 (CST)
Exclude peer audit serials from regular tmp sending query
Any tmp entries being sent immediately rather than upon finalcheck will send for audit as well.
- Question: What is an appropriate max serial for audits? Would 149 work? Should there ever be more than 38 audit patients on the same PC at the same time?
- Required Fix: fix the regular audit query to exclude serials < 111 and serials > ???.
pending.mdb
- Audit numbers should not go into pending.mdb--TOstryzniuk 19:21, 26 November 2009 (CST)
What do you suggest I do to fix these?
The following are entry errors for which I can't think of a check. Suggestions anyone?
- No MOVE date it tmpv2 audit because audit sent with CSV batch.
- no idea what that means Ttenbergen 10:22, 30 November 2009 (CST)
- Joyce must have had location of audit 111 as SICU instead of MICU then she fixed that is why there is data sent to tmpv2 audit.
- no idea what that means Ttenbergen 10:22, 30 November 2009 (CST)
wrong location
- Grace LOCATION for audit 111 was GRA_N5. Should be GRA_N3. Collectors default location to their sites and when doing an audit and forget to change location for the patient they are auditing to the site that is being audited.
- STB_MICU sent second audit today. Location for patient audited was STB_MICU but should be STB_CCU.
ICU auditing med and vice versa
- No TASK item in audit mdb because LOCATION is wrong for audit GRA_111.
- 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.
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
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)
- moved a note into Admit, Transfer and Discharge date and time, as this is unrelated to updates to the program. Ttenbergen 09:27, 11 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