search

episphere / connect

Connect API for DCEG's Cohort Study
10 stars 5 forks source link

Add variables to be retained in the stub record #1122

Closed mnataraj92 closed 1 month ago

mnataraj92 commented 1 month ago

@jhflorey These new variables from the participants table should be retained in the stub record upon data destruction:

d_320303124 (3-month Quality of Life (PROMIS) survey completion flag) d_843688458 (Autogenerated date/time when PROMIS survey completed) d_956490759 (2024 Connect Experience Survey Status) d_199471989 (Autogenerated date/time stamp for Completion of 2024 Connect Experience Survey)

jhflorey commented 1 month ago

@mnataraj92 My changes are ready on dev. Do we need to test in dev or we will test in stage?

brotzmanmj commented 1 month ago

Hi, I don't see a response to the question, @mnataraj92 was this tested in dev?

mnataraj92 commented 1 month ago

@brotzmanmj this will be part of today's dev testing.

mnataraj92 commented 1 month ago

This will be tested in stage.

mnataraj92 commented 1 month ago

Tested in stage, and the variables were retained as expected!

However, it seems that the Connect Experience Survey data still needs to be configured from firestore to BigQuery so we were not able to check that the 2024 Connect Experience Survey data has been deleted since the table is not yet in BQ.

mnataraj92 commented 1 month ago

Looks good in stage! Ready for prod