Date change bug

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.

• Has anyone else had any weird occurrences with dates since the last roll-out? Ttenbergen 10:35, 28 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 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 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)
      • From Hazel: 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. --[Hrona|Hazel Rona]]--TOstryzniuk 13:05, 29 July 2011 (CDT)
        • 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)
          • Template:DiscussionIs this just happening on SENT files that have not been deleted from laptop or is it also happening randomly on any files already on laptop or only new patient added to laptop?--TOstryzniuk 13:27, 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’. [Hrona]
            • Laura has noticed also, that when she view 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.

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

• Error likely started in files ADDED ON or AFTER July 25 so data sent before this date is likely not affected.

• Pagasa has put ALL the SENT csv files on the Regional Server from July 13.11 to date.
  • CC_Date_Repair - contains all the ICU batches sent to date.
  • Med_Date_Repair - contains all Med batches sent to date.

• DATA COLLECTORS: Please check all your sent CSV files on the Regional Server against your paper ADMIT LOG. Also, for any data SENT or ADDED to laptop ON or AFTER the roll out of version on July 25.11, check all dates.
  • For any data files send BEFORE July 25th, do a random check of dates. It is likely these files are not be affected.
• Make any required DATE corrections directly on the CSV file on the Regional Server.

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

--TOstryzniuk 15:46, 28 July 2011 (CDT)