Bug #7593
Unknown HIV Status for Caregiver on all Exports
| Status: | Closed | Start date: | 04/06/2024 | |
|---|---|---|---|---|
| Priority: | Immediate | Due date: | 03/07/2024 | |
| Assignee: |  Nimrod Munatsi | % Done: | 0% | |
| Category: | - | Spent time: | - | |
| Target version: | - |
Description
Please see attached. The "UNK" variable is appearing on all caregiver exports which then shows UNK for the children exposure status as well.
Data source: Adult consents (exported csv name = "SubjectConsent")
Date pulled: 2024-05-31
Anomaly: 5 matpid's associated with hiv_status = "UKN"
- B142-040990227-6
- B142-040990631-9
- C142-040990642-6
- C142-040990903-2
- B142-040990962-8
Attachment: Adult consent records for the five matpid's listed above.
History
#1
Updated by Nimrod Munatsi 7 months ago
- Due date set to 13/06/2024
- Assignee set to Nimrod Munatsi
#2
Updated by Nimrod Munatsi 7 months ago
- Due date changed from 13/06/2024 to 19/06/2024
#3
Updated by Nimrod Munatsi 7 months ago
- Status changed from New to Resolved
#4
Updated by Debbie Bitran 7 months ago
- File PRODUCTION_CaregiverChildConsent-2024-06-26.csv
added - File PRODUCTION_SubjectConsent-2024-06-26.csv added
- File DEV_CaregiverChildConsent-2024-06-25.csv added
- File DEV_SubjectConsent-2024-06-26.csv added
- Status changed from Resolved to Feedback
I pulled the following CRFs from both the test and the production EDC (just in case):
- CaregiverChildConsent (Flourish Caregiver > Caregiver Consent On Behalf Of Child)
- SubjectConsent (Flourish Caregiver > Adult Participation Consents)
Feedback¶
UKN hiv status or hiv exposure value still present in data from production and test EDCs.
Code to reproduce issue¶
# PLEASE REPLACE FILE PATHS ACCORDING TO YOUR DIRECTORY
child_consent_prod = pd.read_csv("/PRODUCTION_CaregiverChildConsent-2024-06-26.csv")
child_consent_dev = pd.read_csv("/DEV_CaregiverChildConsent-2024-06-25.csv")
cg_consent_prod = pd.read_csv("/PRODUCTION_SubjectConsent-2024-06-26.csv")
cg_consent_dev = pd.read_csv("/DEV_SubjectConsent-2024-06-26.csv")
cg_consent_prod.hiv_status.value_counts()
cg_consent_dev.hiv_status.value_counts()
child_consent_prod.hiv_exposure.value_counts()
child_consent_dev.Hiv_exposure.value_counts()
Attachments:¶
Attachments prefixed with "DEV_" are from the test EDC and attachments prefixed with "PRODUCTION_" are from the production EDC.
#5
Updated by Nimrod Munatsi 7 months ago
- Due date deleted (
19/06/2024)
#6
Updated by Nimrod Munatsi 7 months ago
- Due date set to 03/07/2024
#7
Updated by Nimrod Munatsi 7 months ago
- Status changed from Feedback to Resolved
#8
Updated by Sara Schenkel 6 months ago
- Priority changed from High to Immediate
UNK on PennCNB. Still on exports. Please address
#9
Updated by Sara Schenkel 4 months ago
- Status changed from Resolved to Closed