USAID-OHA-SI / WeekendSpecial

SA weekly data munging
0 stars 1 forks source link

Facility name changes #55

Open achafetz opened 6 years ago

achafetz commented 6 years ago

Facilities in the sheets don't contain UIDs. We need to map the hierarchy onto the facility name, not UID, which is prone to error. There are a few misspellings that need to be corrected in the sheets so we can properly map. Names need to be changed in the partner sheets to reflect what is in DATIM.

Partner Sheets Facility Name DATIM Facility Name
gp Alexandra East bank Clinic gp Alexandra East Bank Clinic
gp Mercy Winterveldt NGO Clinic gp Winterveldt Clinic
wc District Six wc District Six CDC
wc Browns Farm (Inzame Zabantu) CDC wc Inzame Zabantu CDC

These are the indicator/tabs affected.

partner indicator
ANOVA HTS_TST_POS_DIRECT
FPD HTS_TST_POS_DIRECT
FPD HTS_TST_ART
FPD APPT_EARLY_MISSED
FPD ART_WAITING
FPD LTFU_UNCONFIRMED
FPD IPT
FPD HTS_TST
FPD HTS_TST_POS
FPD TX_NEW
FPD TX_CURR
KI HTS_TST_POS_DIRECT
KI IPT
KI HTS_TST
KI HTS_TST_POS
KI TX_NEW
KI TX_CURR