QC of Uninvited Records

[jacobmpeters]

Paraphrase of instructions from Nicole in Weekly Analytics Meeting:

• QC of Uninvited Records?
  • There is a flag for uninvited participants
  • Reach out to Tech Review to enquire about this
  • Make sure that none of the people from the uninvited list are still in PROD
  • If flag is yes, then they will be deleted
    • check to see if anyone that had a flag

Run check —> get connect_ids
Run again —> Make sure those connect_ids are not in prod

[jacobmpeters]

@FrogGirl1123

There were 538 uninvited participants (with tokens but no Connect_IDs) in PROD as of 9/6/23.
The list of tokens stored in Box: uninvited_recruits_prod_2023-09-06.csv

Query used:

SELECT token, Connect_ID, d_288972510 
FROM `nih-nci-dceg-connect-prod-6d04.FlatConnect.participants_JP` 
WHERE d_288972510='353358909'

[jacobmpeters]

I reran this query on 11/20/2023 and no records were returned.

As an independent check, I queried the data for all participants in uninvited_recruits_prod_2023-09-06.csv by their "token" and no results were returned.