Requested CCMDB changes for the next version

see the Development Documentation Category for other development logs

Isolation-Task

• Isolation-Task - add the "glove and gown" option to the PDA and to CCMDB.Ttenbergen 16:08, 29 May 2009 (CDT)
• fix the task output queries to accommodate this

Updates required for Laptops

• automate the backup to the Regional Server
• automate a backup to the SD card
• automate checking for new front-end on every log in to the network
• Must be able to enter new files into Access

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)

Core Functionality

Stop checking for Greensheet compliance data

says it all Ttenbergen 22:47, 4 May 2009 (CDT)

Comorbid output order

set secondary sort parameter to comorbid code to ensure that the same list will always be output in the same order. Ttenbergen 13:36, 6 May 2009 (CDT)

Autopsy

Received go-ahead from Trish to make the output for "Autopsy" false always. Once the currently testing version is rolled out data collectors will be able to stop collecting autopsy. The option will remain on the books for now, but "expired - no autopsy" and "expired - autopsy" will now be treated the same. Change required:

• set the output for autopsy to a hard-coded "false"

Active Tx

Received go-ahead from Trish to get rid of Active Tx field. The field itself will need to stay due to its presence in HanDBase but I will make it invisible in CCMDB.mdb. Also, the output will be corrected to always state the negative. This will become active when the currently testing version rolls out. Change required:

• hide active tx field in CCMDB.mdb
• change output so that active tx is always negative

Discussion

• can someone tell me where this field is in ccmdb.mdb? I can't seem to find it. Ttenbergen 09:52, 27 April 2009 (CDT)
  • It is on the apache page opposite to the B/P value--FLindell 13:14, 28 May 2009 (CDT)--FLindell 13:14, 28 May 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.

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 CRF vs ARF, ARI, Renal Transplant

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)

Ensure that date/time formats are explicit

Make sure that Access explicitly looks for the format set out in Date and Time Format, rather than using the PC format. Template:Discussion

Discussion

• Right now CCMDB.mdb uses dd-mmm-yyyy, e.g. 12 Jan 2009. This is less ambiguous than the standard set out on the wiki. I think it's the better option since it eliminates the chance for transposition errors. I think we should use this format for collection. This does not affect how it is sent to Ed, or how it is stored in Ed's program. If Trish is OK with this, this section should be removed from the change log and Date and Time Format should be updated accordingly. Ttenbergen 12:58, 12 February 2009 (CST)
  • starting the one-week clock to accept this change since it has not been disputed. Ttenbergen 10:44, 23 April 2009 (CDT)

APACHE II ACTIVE TX-eliminate this

• ACCESS program is affected because it makes this a required field (though my understanding is that many data collectors have set default for boxed to be checked).
• PDA Reader or master database utility programs are not affected if this field is left BLANK
• needs to be approved by Critical Care before implementation of this change

TOstryzniuk 16:29, 12 December 2008 (CST)

• Approved, leave blank. TOstryzniuk 05:25, 19 January 2009 (CST)

Discussion

• are you saying that ccmdb.mdb will not allow sending a pt with unchecked active tx? Ttenbergen 14:25, 11 February 2009 (CST)
  • YES.TOstryzniuk 13:35, 9 March 2009 (CDT)
    • Where is this field in Access, I don't see it on the APACHE screen.Ttenbergen 10:44, 23 April 2009 (CDT)

After-Laptop changes

Improve Data Entry for Tasks

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