Key Populations Dashboard

[hessionra]

Q1 Timeline

• Q1 Initial Data Entry Period (1/7-2/15)
• Datasets become available in Genie (2/15)
• Datasets becomes available on Panorama (2/22)

Q1 Entry Checklist:

• [x] Finalize tool [template] in preparation for Q1 initial data population (2/11)
• [x] Populate tool (2/18)
• [x] QA/QC tool (2/20)
• [x] Submit final tool(s) to PEPFAR.net (2/26)

[vanamala-narasimhan]

QC Complete

[hessionra]

Thank you @vanamala-narasimhan @wvp3 @Yabayabadoo , great work!

[hessionra]

Q1 Clean Timeline

• Q1 Clean Data Entry Period (3/4-3/22)
• Datasets become available in Genie (3/22)
• Datasets becomes available on Panorama (3/29)

Q1 Clean Checklist:

• [x] Finalize tool [template] in preparation for Q1 clean data population (3/18)
• [x] Populate tool (3/25)
• [x] QA/QC tool (3/27)
• [x] Submit final tool(s) to PEPFAR.net (4/2)

[hessionra]

@wvp3 @vanamala-narasimhan @Yabayabadoo Please let us know if this will be ready for submission on 4/2!

Looping in @jb3436

[vanamala-narasimhan]

Tool population complete, on QC step

[hessionra]

Thank you @vanamala-narasimhan ! Once it is uploaded to pepfar.net, please move the ticket to "Huddle Ready" in the project.

[kkale25]

QC completed (Mala and Kashmira) on 4/5. Email from Mala sent on 4/5 confirming ready for Huddle population.

SUBJECT: Key Pop Dashboard - in QC and Ready by COB Hello,

Here is the link to the most updated version of the Key Pop dashboard. We will be completing QC this afternoon and it should be ready for huddle by COB.

https://www.pepfar.net/OGAC-HQ/icpi/Products/Forms/AllItems.aspx?RootFolder=%2FOGAC%2DHQ%2Ficpi%2FProducts%2FICPI%20Approved%20Tools%20%28Most%20Current%20Versions%29%2FKey%20Populations%20Dashboard&FolderCTID=0x0120004DAC66286D0B8344836739DA850ACB95&View=%7B58E3102A%2DC027%2D4C66%2DA5C7%2D84FEBE208B3C%7D

Thank you!

Mala

[hessionra]

Q2 Initial Timeline

• Q2 Initial Data Entry Period (4/1-5/15)
• Datasets become available in Genie (5/15)
• Datasets becomes available on Panorama (5/22)

Q2 Initial Checklist:

• [x] Finalize tool [template] in preparation for Q2 initial data population (5/13)
• [x] Populate tool (5/16)
• [x] QA/QC tool (5/20)
• [x] Submit final tool(s) to PEPFAR.net (5/24

[hessionra]

@wvp3 @Yabayabadoo @vanamala-narasimhan checking on the status of KP and if it will be ready for the Huddle today!

[vanamala-narasimhan]

Tool population complete, on QC step.

[vanamala-narasimhan]

Final tool submission complete

[hessionra]

Q2 Clean Timeline

• Q2 Clean Data Entry Period (6/3-6/21)
• Datasets become available in Genie (6/21)
• Datasets becomes available on Panorama (6/28)

Q2 Clean Checklist:

• [x] Finalize tool [template] in preparation for Q2 clean data population (6/17)
• [x] Populate tool (6/24)
• [x] QA/QC tool (6/26)
• [x] Submit final tool(s) to PEPFAR.net (7/2)

[wvp3]

https://www.pepfar.net/OGAC-HQ/icpi/Products/ICPI%20Approved%20Tools%20(Most%20Current%20Versions)/Key%20Populations%20Dashboard/ICPI_KP%20Tool_FY19Q2_Clean_Jul10.xlsx

Requesting the following QC assignments, one person per tab:

• Clinical cascade = Yaa
• Progress to target = Mala
• Yield modality / kp = Jenny
• PREP = Jasmine

I recommend testing a couple OUs (One LTS country and one regional program country) and comparing vs. Panorama for example the additional disaggregates dossier. At the OU level and then maybe just a handful of PSNUs and mechanisms combinations.

Please ignore the recency and self-testing tabs for now. I still have to do my own check of those and I don’t think they are correct.

If it’s possible, please send me any identified bugs or data issues by 3pm today so I can try to fix them by COB.

[wvp3]

Done update and passed standard QC. Uploaded for FY2019Q2.

[hessionra]

Q3 Initial Timeline

• Q3 Initial Data Entry Period (7/1-8/15)
• MSD Pre-Release (7/25)
• Datasets become available in Genie (8/15)
• Datasets becomes available on Panorama (8/22)

Q3 Initial Checklist:

• [x] Finalize tool [template] in preparation for Q3 initial data population (8/12)
• [x] Populate tool (8/16)
• [x] QA/QC tool (8/20)
• [x] Submit final tool(s) to PEPFAR.net (8/26)

[hessionra]

@vanamala-narasimhan @wvp3 @Yabayabadoo Please let us know if this will be ready for submission COB today!

Looping in @jb3436

[hessionra]

Q3 Clean Timeline

• Q3 Clean Data Entry Period (9/2-9/20)
• Datasets become available in Genie (9/20)
• MSD Pre-Release (9/23)
• Datasets becomes available on Panorama (9/27)

Q3 Clean Checklist:

• [x] Finalize tool [template] in preparation for Q3 clean data population (9/16)
• [x] Populate tool (9/23)
• [x] QA/QC tool (9/25)
• [x] Submit final tool(s) to PEPFAR.net (10/2)

[kkale25]

Questions for POCs to answer by EOD 11/8 Please write your responses next to the question.

• Will this tool be updated for Q4? Yes
• When will the tool be retired (expected quarter)? Depends on full KP dossier approval, at least Q2
• Who is the ICPI POC/Owner of this tool? @vanamala-narasimhan
• Who will QC this tool for Q4? @imujawar @oyd6 and LaChandra if needed
• Do you need additional support for QCing the tool for Q4? Yes if available but we will have atleast 2
• Will this tool be ready for the Huddle on 11/27? Yes
• Is there a Dossier equivalent for this tool in Q4? No
• What is the name of the Dossier? N/A
• Who is the POC/Owner of this Dossier? N/A
• Who will QC the Dossier (if relevant)? N/A
• Other comments? Tested Q4 tool with updates and with Moz/Esw data, awaiting MSDs on 11/21 due to MSD optimized tool and code; update to be completed 11/21 with QC sent out COB 11/21

Q4 Initial Timeline

• Q4 Initial Data Entry Closes 11/15
• Test Datasets for Eswatini and Mozambique available 11/18
• Analysts QC Dossiers 11/19 and 11/20
• MSD Available on SP 11/21
• Analysts populate ICPI Tools 11/22
• Analysts QC ICPI Tools 11/25
• Tools due 11/26
• Huddle released 11/27

[kkale25]

@vanamala-narasimhan Can you please update the questions listed above ASAP?