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

records set to sent that should not be

• some incomplete patients Record Status fields are being set to "sent" in centralized
  • those patients are not showing up in .csvs and are not set to "sent" in ccmdb.mdb
• 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.

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!

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)

moved description

Sending to centralized data.mdb - Record Status 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 Record Status 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 - 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.
  • Pat also 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)