Bug - Incomplete patients are being set to "sent" in Centralized data.mdb

From CCMDB Wiki
Revision as of 10:55, 2020 June 10 by Ttenbergen (talk | contribs) (Text replacement - "ccmdb.mdb" to "ccmdb.accdb")
Jump to navigation Jump to search


records set to sent that should not be

  • some incomplete patients RecordStatus fields are being set to "sent" in centralized
    • those patients are not showing up in .csvs and are not set to "sent" in ccmdb.accdb
  • collectors can send week after and do not get an error that the file is already sent
  • Only some sites affected, and CCMDB updates are not stuck on regional server
    • HSC: A4, D4, H4 GRA N3, N5.

troubleshooting

Setting to "sent" happens as one of the last steps in sending, after all data is sent, but before excel is opened etc. So, if Excel opens after sending, then the code that sets to "send" is being run. However, that code is set to not generate any errors because sending would be gopher central if it were not.

The code is such that local records are set to "Sent" first, and then the centralized ones. Setting the centralized records to "sent" is done using query "send_set_oLog_to_sent". Query was linking only on Pat_ID, not on location! Fixed. Rolling out with next version.

allowed to send records even though set to "sent" in centralized

  • Sometimes there are no errors trying to send patients already set to "sent" in centralized:
    • "Collector appear to be able to send file to CSV the following week, but we have not heard of error message that status is already SENT in centralized and they could not resend."

troubleshooting

  • query "send_check_centralized_is_owner"
    • lists any patients who exist in both CCMDB and Centralized (based on ID and location) and who are either "sent" or "vetted" in Centralized, and not "sent" in CCMDB.
  • confirmed the query Ttenbergen 10:16, 2014 May 1 (CDT)

I am not able to duplicate this problem. Any further input? Ttenbergen 10:17, 2014 May 1 (CDT)

moved descriptions

Sending to centralized data.mdb - RecordStatus field changes in centralized that seem to occuring when send files are uploaded to centralized.mdb. For some reason random files going into centralized, and RecordStatus field is changed to SENT, yet files had not been sent as complete to CVS for that date. They remain as Incomplete in record status field on their laptops. Collector appear to be able to send file to CSV the following week, but we have not heard of error message that status is already SENT in centralized and they could not resend. Sites affected: HSC: A4, D4, H4 GRA N3, N5.

Examples

Good example: HSC_D4. in centralized, 8 files are showing as SENT (as per PIVOT) April 17.14. There were actually 18 sent in CSV on this date. 3 of them, have record status SENT in centralized yet they were not sent to CSV on April 17. On April 23, Judy able to include the sending of 2 of the ones already marked SENT in centralized April 17, but she had no complaint of a ERROR message that we heard of. 2 patients 10669 & 10656 were sent CSV but date SENT remains in centralized as April 17. One record 10634, is marked as sent in centralized but record status field on her laptop is incomplete. So far not able to figure out issue in regards to how she could these 2 without error message. We will monitor this weeks send and see if we can clue in further.-Trish Ostryzniuk 20:03, 2014 April 30 (CDT)

  • April 30, 14: GRA_N5 was unable to send files today. 2 files in centralized have record status set as SENT, yet on laptop, they are incomplete and still in unit.Trish Ostryzniuk 11:10, 2014 April 30 (CDT)
  • April 30.14: HSC H4: Pat Stein - had a patient that record status field was set to SENT in centralized on April 26.14 at 1436, but on laptop record status remains incomplete because it is a MR pt. She could not send. I had to go into centralized and reset record status so she could send.
  • April 30.14: HSC_D4: Judy Kublick - could not send because serial 10657 record status was set to SENT on April 15.14 1803 hrs, yet on laptop, record status is Incomplete and for MR. Made the change in centralized to record status field so she could sent.Trish Ostryzniuk 20:09, 2014 April 30 (CDT)

Issue: RecordStatus field on laptop is INCOMPLETE but in centralized it is showing as SENT? Not sure how that is happening. This may have been going on for some time but we are just picking up on it more now. Following sites noted to be affected:

  1. HSC A4 -2 files. Not sent to CSV but in centralized.mdb, record status is SENT. (sent April 16.14) Not sure what happened and Con is away 2 weeks. Also, 7 files SENT and Vetted in Centralized but on laptop they are INCOMPLETE.
  2. GRA N3 - 2 files Laptop INCOMPLETE, centralized SENT?
  3. HSC D4 - 2 files Laptop INCOMPLETE, centralized SENT?
  4. STB CICU - 1 file Laptop INCOMPLETE, centralized SENT? Lois was unable to send, so she called Pagasa. Advised that she had not SENT it complete before.Trish Ostryzniuk 19:43, 2014 April 25 (CDT)

Separate Issues

error message about missing Minimal Data Set first send attempt today she had to enter fake admit "times". She said that this was not an issue for some time but the problem is back again.

    • Second issue she had today when going in and out of patient list, some of the patient with LOCATION HSC MICU were showing up on her laptop. When she would get out of patient list then go back in, LOCATION HSC MICU was not showing. Don't understand this one.