KPCO- HIPAA date/time and Consent date/time not the same in dev

[brotzmanmj]

Looking at Dev testing that KPCO is doing, the date/time of HIPAA authorization is not the same as the date/time consent submitted. It is showing up as the next day. Those agreements are always submitted at the exact same time the Connect app so it's not clear why to me why the date/time stamp should differ by as much as several hours or a day. Can you check with Brian or Bhaumik if there is a reason for this? If so, I may have forgotten what it is. Thanks.

[bhaumik55231]

Hi Michelle @brotzmanmj, Do you have those concepts which are collecting incorrect datetime?

[brotzmanmj]

Hi Bhaumik @bhaumik55231 Looking at it now, I no longer see this issue in dev. I don't know if any change has been made that might account for this. If I see it again, I'll let you know and will grab the Connect IDs as examples.

[FrogGirl1123]

According to the Master Data Dictionary, 982402227 is supposed to be autogenerated when consent is completed for the purpose of populating the date in the PDF version of the consent form. If it was set up as described, then changing the format would only affect new data. If it's derived from the consent time stamp (454445267) instead as @bhaumik55231 mentioned in the email thread, I would think that changing the format/derivation in prod would correct the year, month, day order for current as well as future participants. But we should test in stage before moving to prod.

The HIPAA time stamp, 262613359, is autogenerated when the HIPAA is authorized. The consent time stamp, 454445267, is autogenerated when the consent form is submitted. I'm not sure if at some point in the development of the workflow there was a separate check box for the HIPAA and that's why we collected a separate or if we wanted to collect the date for both even if they were autogenerated from the same submit so that we had a time stamp record for each form.

Hope this helps. Let me know if you have any follow-up questions.

[brotzmanmj]

@bhaumik55231 @FrogGirl1123 @abhinavjonnada82 Good morning, I'm elevating this issue to High Priority since it is impacting the production data and I know you're planning to discuss at prep meeting this morning. Here is one example but there are more, and not limited to one site: See Connect ID 1660672658 in the prod data and look at the dates on the All Participants page and also on the download of the forms from the Participant Summary. Amelia and I do not have full visibility because we can only see two date/time stamp variables in the study manager dashboard and not the third one Nicole mentioned above. @abhinavjonnada82 can you please look into this from your perspective before the prep meeting today? And @FrogGirl1123 is it possible to compare all of the consent and HIPAA date/time stamps in prod to see the scope of the issue and if there is any pattern, and should that be added to the recruitment QC going forward? Thanks!

[FrogGirl1123]

@mnataraj92 , could you run a proc compare between the time stamps for Consent and HIPAA in prod? @brotzmanmj when I checked the ids from the email yesterday those had all aligned, but I agree comparing across all consented individuals is one of the next steps.

[FrogGirl1123]

@mnataraj92 never mind as discussed on the punch list meeting, the issue is the conversion of time zone on the SM dashboard.

[Davinkjohnson]

related to https://github.com/episphere/connectApp/issues/285

[brotzmanmj]

@abhinavjonnada82 @Davinkjohnson Hi Abhinav and Davin, I understand there was a resolution decided on for this date issue. So now we just need to iterate this out to the Study Manager Dashboard. Please let us know when it's done and Amelia and I will check it. Thanks.

[brotzmanmj]

@abhinavjonnada82 @Davinkjohnson Just making sure this one is still on our radar. This has not yet been addressed in dev. It just needs the consent date on the All Participants list of variables to be changed from the one that currently displayed (that was retired) to the one that the team decided to use instead. Hopefully this is documented in the data dictionary or perhaps Nicole will recall which one we decided to keep.

[robertsamm]

@abhinavjonnada82 Hi Abhinav, just checking to see if this was changed in the all participants bubble fields so that we can close this out? @mnataraj92 can you check to see if you know what the variable is that should be used from the DD?

[mnataraj92]

262613359 Autogenerated date/time stamp for HIPAA Authorization 454445267 Time consent submitted

[sonyekere]

@robertsamm @mnataraj92 @abhinavjonnada82 Can this issue be closed ?