Requested CCMDB changes for the next version

see the Development Documentation Category for other development logs

Pharmacy change request

folks are having trouble with the "hovering" feature in pharm ccmdb. Not always working. Some are suggesting to have a printouts or pharm list cards rather than the away it is set up currently in CCMDB. Laura & Marie have some suggestion. Could both of you please address with Tina. Trish Ostryzniuk 19:51, 2013 April 4 (EDT)

1. I emailed Tina about a concern regarding the pharmacy list. Currently it does not indicate on the laptops which of the drugs are cont infusions only. (It does have this on the wiki). I think it should indicate this on the laptop list. Heparin is listed as cont. inf. Need to have this also for opioids, benzos, furosemide, propofol, insulin, etc. The risk in not saying "cont inf" is that people may tick them off even if they only receive a bolus or single doses of the drug. --LKolesar 12:15, 2013 April 5 (EDT)
   • I agree with above. It is important that route is CLEAR on laptop because staff will FORGET. It has to be clear on collectin too for not only current staff but new staff. Tina, please address this one as a priority with pharm changes.--Trish Ostryzniuk 18:08, 2013 April 5 (EDT)
2. The LMWH hover feature does not work, possibly because it is at the bottom of the screen. --LKolesar 12:15, 2013 April 5 (EDT)
   • I suggest that the drug list that is tick off only be situated at the top of the screen and then put the counted antibiotic drug list at the bottom. --LKolesar 12:15, 2013 April 5 (EDT)
   • Marie had a suggestion to not have the hover feature (as it is sketchy to use). Instead, she suggested having a reference sheet pop-up with all the drug names on it. (like the apache cheat lists that pop-up with ranges). She can elaborate on this suggestion. --LKolesar 12:14, 2013 April 5 (EDT)

Transfer Tracker

• Marie had ID'd that if she changes a date (admit or discharge date) on her laptop, that it is not updated in transfer tracker. She was made aware that transfer tracker updates itself everyday overnight. Laura suggested that she test pressing the update button to see if profile date is changed in tracker. Date should be updated if auto update to tracker is being done. Not sure if overwriting and changing the date if already in transfer tracker.-Trish Ostryzniuk 19:51, 2013 April 4 (EDT)

New change request

• implement Chart_number#CCDMB Data Integrity Checks Ttenbergen 17:57, 2013 March 18 (EDT)
• implement PHIN field#CCDMB Data Integrity Checks Ttenbergen 18:03, 2013 March 18 (EDT)
• implement Admit,_Transfer_and_Discharge_date_and_time#CCDMB_Data_Integrity_Checks_2 (admit date no earlier than one month before today) Ttenbergen 18:07, 2013 March 18 (EDT)
• Admit,_Transfer_and_Discharge_date_and_time#Discharge_Date_and_Time_CCDMB_Data_Integrity_Checks (disch not after today) Ttenbergen 18:12, 2013 March 18 (EDT)
• Drugs Collected - change to drug collection list to be implemented and rolled out bye the end of first week of March before vacation start. 00:25, 2013 March 1 (EST)~
• VIC N4- remove this from the LOCATION dropdown list in ccmdb.mdb. This is not a location we collect on at the VIC. Julie found 14 VIC LOCATIONS mislabelled as VIC N4 that should be VIC N5. She found this while fishing in TMPV2 for allied health stuff. Joycelynn fixed this today on VIC laptop. ThankTrish Ostryzniuk 18:22, 2013 February 26 (EST)
• change MR forms: "It is better if the patients’ last names are listed first. It would also be helpful if the list included the name of the laptop printing the list (ie MICU) that way when we find the list on the MR shelf we immediately would know who’s charts have been pulled"
• there was also talk about deleting the "other" sorted MR forms... where, and did it get resolved? Template:Discussion Ttenbergen 13:14, 2013 February 28 (EST)
• Yes,there is no reason to have 3 views for the MR list. Please just put one list and just label it "MR list" (the oldest first list should be used). Also, for the format of the form, please put the MR # first, then the pt's last name, then the first name, then the dates, etc. The serial # is OK to be on the form but if you can put it later it would be better. This form is for MR staff to use and it would be easier for them if the MR # is first, not the serial #. --LKolesar 09:09, 2013 March 7 (EST)-Trish Ostryzniuk 19:36, 2013 March 7 (EST)
• change for Nephrectomy if no concerns. Ttenbergen 17:22, 2013 March 14 (EDT)

checks for minimal data admit/discharge

• Admit date_time should not be at most one month before the TODAY date; soft check, can click past this one;
  • the check would be run only at edit/entry time, so having a patient who was admitted last year sometime would not be triggered unless you try to edit the box
• disch date_time should not be after the TODAY date; this would be a hard check since it should never happen

Bug Fixes

• Joyce described: When there is a discharge date and no discharge time, the pharmacy day count checker will give an error when there should not be an error. Ttenbergen 15:47, 2013 February 25 (EST)

• Category:Ready-to-fix bug

• with reg already checked, was able to change discharge date to a future date and it didn't uncheck initially; it did catch on trying to final-check, so this is a low-grade bug, just should be fixed eventually. Only way for a bad date to go through is if it were changed after final-check had already been set. Ttenbergen 20:37, 2012 November 1 (EDT)

• able to uncheck checkboxes without finalcheck unchecking. Need to determine if this could lead to bad data going through. Ttenbergen 14:45, 2012 May 22 (CDT)

• if an error handler turns the dx tab yellow this is not automatically reset when a new patient is opened. Ttenbergen 13:15, 2012 October 31 (EDT)

• DX Delete Bug

• do additional error checking on the overstay questions to make sure one of each is present, or corresponding "missing"s. Ttenbergen 17:04, 2013 March 14 (EDT)

Collection tool improvement requests

• For the MR list. We don't need 3 views of this list. Only one is sufficient (the oldest first list is OK) but it doesn't have to be labeled as such if we only have one view. Also, please put the patients' last name first on the form. Also include the name of the laptop in the printout as this is also helpful especially when covering multiple units who all have chart requests in MR. Thanks, Laura--LKolesar 10:06, 2013 February 26 (EST)
  • hello Dats........Now that we have MR sorting by PRIORITY lastest discharge, we don't need MR list sorted by 2 other options available. Does anyone have a case for keeping other sorting MR list options? We would like to remove them. thanksTrish Ostryzniuk 17:31, 2013 February 26 (EST)
    • Flagging this for discussion. If no one replies by the time I do the next update I will delete the extra buttons. Ttenbergen 16:29, 2013 March 11 (EDT) Template:Discussion

Next Round of Data Changes

None currently Ttenbergen 15:03, 2013 March 11 (EDT)

Bugs that need replicating

See Category:Bugs needing input. In order to troubleshoot bugs in the program we need to know how they happen. There are a number of articles about known bugs we are trying to fix in Category:Bugs needing input. Any further feedback on these bugs might be the piece of the puzzle that allows me to fix the bug. If you find a new bug, you please document it.

Changes Under Discussion

There are some possible changes identified that either need to be flagged as needing to be done, or where there is still a discussion going on.

See Category:Potential Change as well, this are only changes without a home article.

apache check no longer yellowing fields

apache check is no longer yellowing fieldsTtenbergen 10:09, 10 January 2012 (CST)

• yes, it is no longer yellowing the field, just the error box below. Can't find trace of the code, and not sure when it was changed. Ponder whether to re-instate, error checking is still being called and still prevents sending... Ttenbergen 17:13, 2012 January 31 (CST)
  • Do we want to re-implement this? Would take a few days of coding I think, so I haven't done it. Ttenbergen 16:58, 2012 October 1 (CDT)
    • not sure what you mean no longer yellowing fields. Do you mean where there is an error (limit) or missing data that is not yellowing? --Trish Ostryzniuk 19:13, 2013 January 28 (EST)
      • been a while, I'll review and let you know what this is about. Ttenbergen 13:55, 2013 January 29 (EST)

Pharmacy Tally

• Would it be possible to have a line showing the cumulative totals of treatment days for the Pharm drugs collected in this field? (as in Labs)10:04, 2012 December 21 (EST)
  • How would this help with collection? I am asking to find out if there might be more to it. For example, are you trying to compare the summary to something else, maybe that can be built in as well. I just need to understand how you would use this. Ttenbergen 10:14, 2012 December 21 (EST)
    • moved this request here. If there are no further comments on it within 2 weeks then this section can please be delete by whoever stumbles on it next. Ttenbergen 16:28, 2013 March 11 (EDT)

Previous requests that were not addressed (with reasons)

Default location field to main collection location

There have been requests to default the location field to the main (or only) collection location. I could set this up, but defaulting these would increase the chances of the data just being left in there if a patient is an exception. Upon consultation with Trish it was decided not to risk an increase in errors to make this more convenient.

• "There are a number of site collecting on 2 or more units using the same laptop. We get ward location entry error when there is a default location set." ... "--TOstryzniuk 12:25, 20 October 2010 (CDT)"

PS: If I enable defaulting for anywhere then I would not be able to disable defaulting for other locations, so it was decided not to have defaulting. Ttenbergen 12:44, 12 January 2011 (CST) I have, though, reduced the location list to only those wards at a given laptop's site. Ttenbergen 18:09, 14 July 2011 (CDT)

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.

Off-line copy of wiki for laptop

see Wiki onto laptops

APACHE lab value limit change request

• Apache upper limit for creatinine is 2968, which is based on the highest APACHE that was ever in database. STB has one pt with a creat of 3000 and has requested to change upper limit. Laura K. --TOstryzniuk 12:12, 6 July 2010 (CDT)
  • Decided to leave limits be and have collectors enter limit values and email Pagasa with real values when extreme values are encountered. Contacted Pagasa to let us know if such emails become too frequent. Ttenbergen 08:53, 12 July 2010 (CDT)