Date change bug: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
mNo edit summary
 
(38 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Hazel from the Vic just reported (Thanks for letting me know! [[User:Ttenbergen|Ttenbergen]] 10:35, 28 July 2011 (CDT)) that she has had dates change on their own after [[Log#ver_2011-07-25 |ver_2011-07-25]] went out. This may be related to the buttons I added to the date fields in [[[[Log#ver_2011-07-13 |ver_2011-07-13]]
{{fixed bug}}
{{Collapsable
| always= this was only relevant at the time, CCMDB was changed to prevent the accidental click that messed this up
| full= 
Hazel from the Vic just reported (Thanks for letting me know! [[User:Ttenbergen|Ttenbergen]] 10:35, 28 July 2011 (CDT)) that she has had dates change on their own after [[Log#ver_2011-07-25 |ver_2011-07-25]] went out. This may be related to the buttons I added to the date fields in [[Log#ver_2011-07-13 |ver_2011-07-13]]


Apparently Hazel sent data Jul 27, and when she looked at the data this morning some of the dates had changed. Some of them had changed to dates that our error checker should not have let through, which is even more concerning.  
Apparently Hazel sent data Jul 27, and when she looked at the data this morning some of the dates had changed. Some of them had changed to dates that our error checker should not have let through, which is even more concerning.  


{{discussion}}
== Solution (hopefully) ==
* Has anyone else had any weird occurrences with dates since the last roll-out? [[User:Ttenbergen|Ttenbergen]] 10:35, 28 July 2011 (CDT)
* '''I think the cause of this might be that people are double-clicking the binoculars to open the patient. That second click isn't necessary, so the program processes it once the patient viewer is open. If the location of the binocular button happens to be the same as one of the +/- buttons it will change the date.'''
** OK, can make an error happen if I enter a date that would be rejected (e.g. dis. dt before adm. dt) manually (no buttons), and then click the exit door without exiting the field first. For me that error means I can't exit at all, so I am not sure if that would be how bad data gets in... [[User:Ttenbergen|Ttenbergen]] 10:58, 28 July 2011 (CDT)
** I moved the dates over to the right by a few pixels so they no longer overlap with the binocular buttons. Rolled out as [[CCMDB.mdb_Change_Log_2011#ver_2011-07-29]]
**I have noticed that some of my admit dates have changed. When I look at the profile the next day I notice that the date is either a day earlier or a day later than what I originally entered.  I thought I was just making a lot of entry errors but now I think it is a glitch.  I correct the date and hopefully the ones I sent are OK. I checked with Pagasa a few random ones which seem OK.  The output files had already been deleted so I couldn't view my sent files.  Anyway when Pagasa cross references the tiss, these errors will be evident.  --[[User:LKolesar|LKolesar]] 11:16, 28 July 2011 (CDT)
 
*** I think it was a problem with the order in which the program writes and checks values. I made some changes and '''hope that the problem is resolved with [[CCMDB.mdb_Change_Log_2011#ver_2011-07-28]]'''. Please do a News&backup to download, and '''let me know if this problem persists.''' [[User:Ttenbergen|Ttenbergen]] 12:45, 28 July 2011 (CDT)
*'''Let me know if this appears to still be a problem.'''
 
*Good work!!  That is great. --[[User:TOstryzniuk|TOstryzniuk]] 16:44, 29 July 2011 (CDT)  
 


==The Plan to FIX Admit, transfer & Discharge Date errors==
== The Plan to FIX Admit, transfer & Discharge Date errors ==
DATE errors could be present from any files sent from July 13.11 to date. (admit, transfer, discharge).
IMPORTANT: Please do the following to fix the fall-out of this bug:
*Error likely started in files sent on or after July 25 so data sent before this date may not have been affected.
* '''make sure you download ver 2011-07-29 or newer using news-and-backup'''(you see the version date by the reset button on your main screen when you open CCMDB.)


*Pagasa has put ALL the SENT csv files on the Regional Server from July 13.11 to date.
* check that dates are correct for '''all patients currently on your laptop'''
**CC_Date_Repair - contains all the ICU batches sent to date.
* check over all the files Pagasa has uploaded on Regional Server to:
**Med_Date_Repair - contains all Med batches sent to date.
** CC_Date_Repair - contains all the ICU batches sent to date
** Med_Date_Repair - contains all Med batches sent to date
* fix any admit, transfer or discharge dates that are incorrect in these sent files


*DATA COLLECTORS: Please check all your sent CSV files on the Regional Server against your paper ADMIT LOG. For any data sent this week after the roll out of version July 25.11, check all dates.  For any data files sent  ON or BEFORE July 25th, do a random check of dates.  They may not be affected.
* Let [[p:Julie Mojica]] know by EMAIL, when you have completed all corrections for your location
*Make any required DATE corrections '''directly on the CSV file on the Regional Server'''.
** let her know which files (if any) you corrected so that Pagasa doesn't have to re-append files that had no errors.  


*Let JULIE know by EMAIL, when you have completed all corrections for your  location.
* Pagasa will re-append and overwrite erroneous data into the master database repository.
* Pagasa will not correct these DATE errors manually. The Collectors will have to fix the CSV files on Regional Server.
* TISS will be scanned in after all correction to DATES are completed.


*Pagasa will re-append and overwrite erroneous data into the master database repository.
*Pagasa will not correct these DATE errors manually.  The Collectors will have to fix the CSV files on Regional Server. 
*TISS will be scanned in after all correction to DATES are completed. 
--[[User:TOstryzniuk|TOstryzniuk]] 15:46, 28 July 2011 (CDT)
--[[User:TOstryzniuk|TOstryzniuk]] 15:46, 28 July 2011 (CDT)
--- updated by [[User:Ttenbergen|Ttenbergen]] 16:31, 29 July 2011 (CDT)
== Summary ==
* there are errors in the admit, transfer or discharge dates
** need to keep in mind that some of these could be actual entry errors, need to find a way to make this happen.
* errors seem to be mostly a day earlier or later
* error seems to be happening as records are opened and closed
* some collectors are getting errors others appear not to be; could this be related to ''how'' patients are opened and closed?
* change is '''not''' happening during send, it is happening to data on the laptops, complete or not
* error does '''not''' only affect sent data


== Discussion ==
* Has anyone else had any weird occurrences with dates since the last roll-out? [[User:Ttenbergen|Ttenbergen]] 10:35, 28 July 2011 (CDT)
**I have noticed that some of my admit dates have changed. When I look at the profile the next day I notice that the date is either a day earlier or a day later than what I originally entered.  I thought I was just making a lot of entry errors but now I think it is a glitch.  I correct the date and hopefully the ones I sent are OK.  I checked with Pagasa a few random ones which seem OK.  The output files had already been deleted so I couldn't view my sent files.  Anyway when Pagasa cross references the tiss, these errors will be evident.  --[[User:LKolesar|LKolesar]] 11:16, 28 July 2011 (CDT)
**I was auditing my ICU dates and observed my dates '''changed again''' without my prompting. I had closed the database yesterday. Opened it today with Serial #5052 for instance with different dates from last time checked. I corrected and closed the database. Viewed Serial #5052 and again, dates changed. This is after updating with newest version.'''I wonder if this problem is limited to just ‘sent’ patients?''' Hazel has not used the new added buttons for dates.  --[[User: Hrona|Hazel Rona]]
**I would suggest that no one SEND in files until Tina resolves this. Tina could you not go back to the pre July 25 version and only have one person test latest version? Pagasa is on vacation for the next two weeks and there will be no other person to monitor this problem further. Collectors will have to check their send files on the Regional Server and check ALL the DATES against their paper log and fix any errors on regional server until Tina confirms problem is fixed.  --[[User:TOstryzniuk|TOstryzniuk]] 13:05, 29 July 2011 (CDT)
** I’ve audited my files. Dates are altered not only on sent files but also on incomplete files. This means that before the bug is expunged, our dates may be likely inaccurate, despite checking ‘reg’ or ‘temp’ or even ‘complete’. --[[User: Hrona|Hazel Rona]]
** Laura has noticed also, that when she views the '''Patient List''', she see an admit date and when she goes directly into the individual profile (registry screen) the admission date is changed.  She thinks it changes when you go into patient files. 
**Audit: 1. Vic ICU & N5/S5. Dates per csv are accurate (and crosschecked against Medical Records). No changes made. 2. Date bug troubleshooting: Observed discrepancies between logsheets and csv dates on Medicine file. This was a transcribing error from recording dates on Thursday vs. Wednesday when I sent. This means that dates changed in the database between Wednesday and Thursday without user intervention. I’ve audited my files. Dates are altered not only on sent files but also on incomplete files. This means that before the bug is expunged, our dates may be likely inaccurate, despite checking ‘reg’ or ‘temp’ or even ‘complete’.--[[User: Hrona|Hazel Rona]]
**I checked Batch #29 sent July 26,11 N3 The only date or time I changed is serial #7285 it appeared to be an entry error for the admit time. For Batch # 30 sent July 26,11 for W3 Serial #3585 the admit date was blank I entered Sept 13,11 at 1220 hrs. The date for serial # 3989 was wrong (1 day earlier) and time wrong I corrected these. Please contact me if you have any questions. [[User: SDowson2|Sheila Dowson]]


[[Category: Bugs]]
== Debugging notes ==
[[Category: IT Instructions]]
I will put here what I am doing or testing. [[User:Ttenbergen|Ttenbergen]] 15:27, 29 July 2011 (CDT)
* OK, can make an error happen if I enter a date that would be rejected (e.g. dis. dt before adm. dt) manually (no buttons), and then click the exit door without exiting the field first. For me that error means I can't exit at all, so I am not sure if that would be how bad data gets in... [[User:Ttenbergen|Ttenbergen]] 10:58, 28 July 2011 (CDT)
* I think it was a problem with the order in which the program writes and checks values. I made some changes and '''hope that the problem is resolved with [[CCMDB.mdb_Change_Log_2011#ver_2011-07-28]]'''. Please do a News&backup to download, and '''let me know if this problem persists.''' [[User:Ttenbergen|Ttenbergen]] 12:45, 28 July 2011 (CDT)
*problem not resolved in July 28 version.
*problem seemed to be resolved in July 29 version. [[CCMDB.mdb_Change_Log_2011#ver_2011-07-29]]
}}

Latest revision as of 10:37, 2020 December 23


this was only relevant at the time, CCMDB was changed to prevent the accidental click that messed this up   

Hazel from the Vic just reported (Thanks for letting me know! Ttenbergen 10:35, 28 July 2011 (CDT)) that she has had dates change on their own after ver_2011-07-25 went out. This may be related to the buttons I added to the date fields in ver_2011-07-13

Apparently Hazel sent data Jul 27, and when she looked at the data this morning some of the dates had changed. Some of them had changed to dates that our error checker should not have let through, which is even more concerning.

Solution (hopefully)

  • I think the cause of this might be that people are double-clicking the binoculars to open the patient. That second click isn't necessary, so the program processes it once the patient viewer is open. If the location of the binocular button happens to be the same as one of the +/- buttons it will change the date.
  • Let me know if this appears to still be a problem.
  • Good work!! That is great. --TOstryzniuk 16:44, 29 July 2011 (CDT)


The Plan to FIX Admit, transfer & Discharge Date errors

IMPORTANT: Please do the following to fix the fall-out of this bug:

  • make sure you download ver 2011-07-29 or newer using news-and-backup(you see the version date by the reset button on your main screen when you open CCMDB.)
  • check that dates are correct for all patients currently on your laptop
  • check over all the files Pagasa has uploaded on Regional Server to:
    • CC_Date_Repair - contains all the ICU batches sent to date
    • Med_Date_Repair - contains all Med batches sent to date
  • fix any admit, transfer or discharge dates that are incorrect in these sent files
  • Let p:Julie Mojica know by EMAIL, when you have completed all corrections for your location
    • let her know which files (if any) you corrected so that Pagasa doesn't have to re-append files that had no errors.
  • Pagasa will re-append and overwrite erroneous data into the master database repository.
  • Pagasa will not correct these DATE errors manually. The Collectors will have to fix the CSV files on Regional Server.
  • TISS will be scanned in after all correction to DATES are completed.

--TOstryzniuk 15:46, 28 July 2011 (CDT) --- updated by Ttenbergen 16:31, 29 July 2011 (CDT)

Summary

  • there are errors in the admit, transfer or discharge dates
    • need to keep in mind that some of these could be actual entry errors, need to find a way to make this happen.
  • errors seem to be mostly a day earlier or later
  • error seems to be happening as records are opened and closed
  • some collectors are getting errors others appear not to be; could this be related to how patients are opened and closed?
  • change is not happening during send, it is happening to data on the laptops, complete or not
  • error does not only affect sent data

Discussion

  • Has anyone else had any weird occurrences with dates since the last roll-out? Ttenbergen 10:35, 28 July 2011 (CDT)
    • I have noticed that some of my admit dates have changed. When I look at the profile the next day I notice that the date is either a day earlier or a day later than what I originally entered. I thought I was just making a lot of entry errors but now I think it is a glitch. I correct the date and hopefully the ones I sent are OK. I checked with Pagasa a few random ones which seem OK. The output files had already been deleted so I couldn't view my sent files. Anyway when Pagasa cross references the tiss, these errors will be evident. --LKolesar 11:16, 28 July 2011 (CDT)
    • I was auditing my ICU dates and observed my dates changed again without my prompting. I had closed the database yesterday. Opened it today with Serial #5052 for instance with different dates from last time checked. I corrected and closed the database. Viewed Serial #5052 and again, dates changed. This is after updating with newest version.I wonder if this problem is limited to just ‘sent’ patients? Hazel has not used the new added buttons for dates. --Hazel Rona
    • I would suggest that no one SEND in files until Tina resolves this. Tina could you not go back to the pre July 25 version and only have one person test latest version? Pagasa is on vacation for the next two weeks and there will be no other person to monitor this problem further. Collectors will have to check their send files on the Regional Server and check ALL the DATES against their paper log and fix any errors on regional server until Tina confirms problem is fixed. --TOstryzniuk 13:05, 29 July 2011 (CDT)
    • I’ve audited my files. Dates are altered not only on sent files but also on incomplete files. This means that before the bug is expunged, our dates may be likely inaccurate, despite checking ‘reg’ or ‘temp’ or even ‘complete’. --Hazel Rona
    • Laura has noticed also, that when she views the Patient List, she see an admit date and when she goes directly into the individual profile (registry screen) the admission date is changed. She thinks it changes when you go into patient files.
    • Audit: 1. Vic ICU & N5/S5. Dates per csv are accurate (and crosschecked against Medical Records). No changes made. 2. Date bug troubleshooting: Observed discrepancies between logsheets and csv dates on Medicine file. This was a transcribing error from recording dates on Thursday vs. Wednesday when I sent. This means that dates changed in the database between Wednesday and Thursday without user intervention. I’ve audited my files. Dates are altered not only on sent files but also on incomplete files. This means that before the bug is expunged, our dates may be likely inaccurate, despite checking ‘reg’ or ‘temp’ or even ‘complete’.--Hazel Rona
    • I checked Batch #29 sent July 26,11 N3 The only date or time I changed is serial #7285 it appeared to be an entry error for the admit time. For Batch # 30 sent July 26,11 for W3 Serial #3585 the admit date was blank I entered Sept 13,11 at 1220 hrs. The date for serial # 3989 was wrong (1 day earlier) and time wrong I corrected these. Please contact me if you have any questions. Sheila Dowson

Debugging notes

I will put here what I am doing or testing. Ttenbergen 15:27, 29 July 2011 (CDT)

  • OK, can make an error happen if I enter a date that would be rejected (e.g. dis. dt before adm. dt) manually (no buttons), and then click the exit door without exiting the field first. For me that error means I can't exit at all, so I am not sure if that would be how bad data gets in... Ttenbergen 10:58, 28 July 2011 (CDT)
  • I think it was a problem with the order in which the program writes and checks values. I made some changes and hope that the problem is resolved with CCMDB.mdb_Change_Log_2011#ver_2011-07-28. Please do a News&backup to download, and let me know if this problem persists. Ttenbergen 12:45, 28 July 2011 (CDT)
  • problem not resolved in July 28 version.
  • problem seemed to be resolved in July 29 version. CCMDB.mdb_Change_Log_2011#ver_2011-07-29
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Date_change_bug&oldid=148194"