Add Qualtrics consent data to the repository

[mbcann01]

Overview

On 2024-04-26, I emailed Sunil about two participants who appeared to be missing consent forms in FM Pro. He checked Qualtrics, which is where the consent forms are stored, and told me that they did have consent forms, but that the interviewer didn't properly indicate it in FM Pro. The brought to my attention that we have not previously downloaded and cleaned the Qualtrics consent data, but we should.

Links

• Qualtrics: DETECT Consent
• FM Pro
• Wiki

Tasks

• Download the Qualtrics consent data
• Add it to SharePoint
• Add it to the local repository
• Clean it
• Add cleaned data to SharePoint
• Check consent against FM Pro
• If you update the "incomplete" consent forms in FM Pro, download new files, add to SharePoint, and add to the local repository
• Rerun data_management/qaqc/check_consenting_participants.qmd
• Update the Wiki

[mbcann01]

2024-04-26

• Left off on line 98 of data_01_qualtrics_consent_import.qmd.
• Figure out if the multiple rows are a problem or not.
• Create a list of MedStar IDs that have given consent for the follow-up interview.
• Create a list of MedStar IDs that have given consent to be contacted.

Clean data_01_qualtrics_consent_import.qmd
#45 
- Raw data imported.

[mbcann01]

2024-04-29

• Left off on line 165 of data_01_qualtrics_consent_import.qmd.
• Figure out if the multiple rows are a problem or not.
• Create a list of MedStar IDs that have given consent for the follow-up interview.
• Create a list of MedStar IDs that have given consent to be contacted.

Clean data_01_qualtrics_consent_import.qmd
WIP #45