MozART IP Quarterly Submission FY19Q4

[vanamala-narasimhan]

Submission Quarter: FY19 Q4 POCs: @orrinft @nehakamat (temp: @vanamala-narasimhan) Description: Implementing Partners submit quarterly Access DBs/MySQL to PEPFAR-MZ. This should be the last time that ACCESS files are submitted for the MozART database, using this double submission we have this quarter to ensure that future submissions only need to be MySQL, saving time and improving data quality!

CDC IPs: ARIEL, CCS, EGPAF, FGH, ICAP

ARIEL

• [x] Initial submission of Access File on 10/21
• [x] PEPFAR-Moz runs Access QC report
• [ ] Initial submission of MySQL File on 10/31
• [ ] PEPFAR-Moz runs MySQL QC report
• [x] PEPFAR-Moz returns feedback on Access submission by 10/28
• [x] Re-submission (if applicable) within 7 days by 11/4
• [ ] PEPFAR-Moz runs QC reports again, feedback (if applicable)
• [ ] Process continues (if applicable)

• [ ] Final submission confirmed by 11/10

  CCS

• [x] Initial submission of Access File on 10/21
• [x] PEPFAR-Moz runs Access QC report
• [ ] Initial submission of MySQL File on 10/31
• [ ] PEPFAR-Moz runs MySQL QC report
• [x] PEPFAR-Moz returns feedback on Access submission by 10/28
• [ ] Re-submission (if applicable) within 7 days by 11/4
• [ ] PEPFAR-Moz runs QC reports again, feedback (if applicable)
• [ ] Process continues (if applicable)

• [ ] Final submission confirmed by 11/10

  EGPAF

• [ ] Initial submission of MySQLFile on 10/21
• [ ] PEPFAR-Moz runs MySQL report
• [ ] PEPFAR-Moz returns feedback on MySQL submission by 10/28
• [x] Initial submission of Access File on 10/31
• [x] PEPFAR-Moz runs Access QC report
• [x] PEPFAR-Moz returns feedback on Access submission by 11/7
• [ ] Re-submission (if applicable) within 7 days by 11/14
• [ ] PEPFAR-Moz runs QC reports again, feedback (if applicable)
• [ ] Process continues (if applicable)
• [ ] Final submission confirmed by 11/21

FGH

• [ ] Initial submission of Access File on 10/31
• [ ] PEPFAR-Moz runs Access QC report
• [ ] Initial submission of MySQL File on 10/31
• [ ] PEPFAR-Moz runs MySQL QC report
• [x] PEPFAR-Moz returns feedback on Access submission by 11/7
• [ ] Re-submission (if applicable) within 7 days by 11/14
• [ ] PEPFAR-Moz runs QC reports again, feedback (if applicable)
• [ ] Process continues (if applicable)
• [ ] Final submission confirmed by 11/21

ICAP

• [x] Initial submission of Access File on 10/21
• [x] PEPFAR-Moz runs Access QC report
• [ ] Initial submission of MySQL File on 10/31
• [ ] PEPFAR-Moz runs MySQL QC report
• [x] PEPFAR-Moz returns feedback on Access submission by 10/28
• [x] Re-submission (if applicable) within 7 days by 11/4
• [ ] PEPFAR-Moz runs QC reports again, feedback (if applicable)
• [ ] Process continues (if applicable)
• [ ] Final submission confirmed by 11/10

USAID Partner Submission

• [ ] Sites verified according to SOP @Green-EyE @josephlara

PEPFAR-MOZ & INS

• [ ] All QC reports run
• [ ] All feedback and correspondence with IPs complete
• [ ] Final CDC files compiled and saved
• [ ] USAID protected files loaded to the external
• [ ] Submission to INS on 11/22
• [ ] INS completes cleaning/validation & provides feedback by 11/29
• [ ] INS transfers final data set by 25th (no errors) If errors,
• [ ] Re-submission by PEPFAR-Moz within 5 working days (if applicable) - 12/5
• [ ] INS transfers final data set by 12/11 (with resubmission)

[nehakamat]

@Green-EyE @josephlara This is the schedule that CDC is proposing for MozART Q4 submission. I'll be working on cleaning the submissions for the CDC side. Look forward to working with you! :)

[orrinft]

@dchavana you should have the ACCESS datasets to INS on Nov 22 for processing, @nehakamat @Green-EyE will be managing the IP submission review process at PEPFAR with support form @vanamala-narasimhan and @orrinft

[nehakamat]

Errors encountered in CDC submissions this quarter:

• HFs with the same code (EGPAF - Dindiza and Massangena) of 1091006
• HFs that aren't new but aren't in the EPTS xlsx file (Chichongue, Nteolele)
• Duplicated HDD codes (CS Ocua, Namachaa CS)
• Hospitals double reporting with the same HDD code; Adult and Pediatric hospitals, but reporting the same patient count - (CCS Hospital Central)
• HDD codes not properly included (ICAP - CS Yapala-Monapo)

[orrinft]

FGH Problems for future awareness

1. HDD 1041411 (CS Naciaia) appears in the R output as having 176 patients, but I can’t find it in the EPTS list – for reference, it’s line 111 in the R output (file “FGH.patientcounts.11.22.NK” in the R outputs folder)
2. According to the EPTS file: a. 7 HFs decreased in patient counts, the most notable being CS Mocuba (HDD 1041106) which went from 24,655 in Q3 to 8,630 in Q4 (noted as “decreased?” in Column V for Q4 comments) b. 5 HFs reported in Q4, but not in Q4 (noted as “Missing??” in Column V for Q4 comments) c. 2 HFs had the same patient count – it was CS Muzo (HDD 1040961) and CS Muanaco (HDD 1041136) - (noted as “No new patients?” in Column V for Q4 comments) d. 3 HFs were listed as having reported in Q3, but there was no Q3 patient count to refer to (noted as “count in Q3?” in Column V for Q4 comments)