An audio recording of today's call is available: https://archive.org/details/20161005PEPFAR30461901

Want to join the call?

Dial Toll Free Number:

US: 800-220-9875
Norway: 800-142-85
Ireland: 800-625-002
Canada: 800-221-8656
South Africa 0-800-982-555
International (Not Toll-free) 1-302-709-8332
For additional toll free country numbers click here.

Access Code 69593570#

**We can dial in any participants who are not able to connect through Skype or one of the above numbers, please email Angad.Dhindsa@icfi.com 24 hours in advance to be dialed in.

Notes

Attendees:

Lon Gowen, USAID CIO

Jacob Buehler, USAID

Kondwani Nkanaunena, CDC Malawi

Dana Juthe (SGAC PRIME - PwC)

Angad Dhindsa (MEASURE Evaluation)

Vlad Shioshvili (MEASURE Evaluation)

Mark DeZalia (S/GAC-PRIME)

Nega Gebreyesus (USAID/SGAC-PRIME)

Rachel Lucas (USAID)

Manish Kumar (MEASURE Evaluation)

Briana Lozano (CDC)

Mary Kratz (DOD)

Josephine Mungurere-Baker (BAO)

Jason Pickering (DATIM Development Team)

Michael Mwebaze (MEASURE Evaluation)

Christina Villella (MEASURE Evaluation)

Jim Grace (HISP US)

Audrey Knutson (Peace Corps)

HRSA Team

Aaron Aranas (CDC)

Alejandra Covarrubias (PwC/OGAC)

Sernita Lewis (NGC/CDC)

James Kariuki (CDC)

Vilma Thomas (NGC/CDC)

Materials:

Issue with SIMS 2.0 Assessments with the Same Period OU and IM: https://drive.google.com/open?id=0B-oCBOyBoll6VE92Y0NUMzJYakU

Agenda:

· PEPFAR Q4 MER Updates (Mark/Dana)

· SIMS Discussion: Proposed solution for resolving the issue with SIMS 2.0 Assessments with the Same Period, OU and IM

1. Brief recap of this issue (Mark)

2. Proposed solution: Develop a tool to identify assessments and replace the Period data (Vlad/Jason)

a. How to identify these assessment; agreement on the criteria and discussion of any other issues

b. Replacing the Period to make it unique:

i. How would this work

ii. Possible challenges

c. Tool specifications; preferred technology? SQL, R Script or something else.

d. Providing sample files:

i. Changes to the file format specifications; adding 3 additional fields i.e. "storedby","timestamp","comment"

e. Possible impact on data analysis; obscuring the period filed so it’s not used for any analysis.

f. Clarifications:

i. Period is a placeholder date

ii. Assessment date will remain unchanged

Minutes:

· PEPFAR Q4 MER Updates

· SIMS Discussion: Proposed solution for resolving the issue with SIMS 2.0 Assessments with the Same Period, OU and IM

There is no uniqueness between agencies, but there only needs to be uniqueness within an agency

c. Tool specifications; preferred technology? SQL, R Script or something else.

There is an availible R script to check for validations. If this R script manipulates CSV tables, it would be helpful to know what the file is changing

Cover sheet data elements are shared between elements

d. Providing sample files:

i. Changes to the file format specifications; adding 3 additional fields i.e. "storedby","timestamp","comment"

"Comment" would be where the AssessmentID would go.