Create Kenya End Fund MDA Dashboards #1494

samkanga · 2021-02-11T12:37:07Z

National to Sub County Levels
As a program manager I would like to see data in a table form showing the number of people treated, broken down by gender and age. The data for the first table will come from the "SCH health worker supervisor summary form" which is sheet 1 on the document here. The coverages should then be calculated based on static population values which should be uploaded manually. The calculations are defined on the jira ticket here.

For Male & Female: If either drop below 80% of the other, it should turn red.
For coverage values: < 65% = Red, >65 & <80 = Yellow, >80

No. of people treated by Age and Gender

The second table should show the drug distribution. Its data will come from the "CDD drug distribution form" which is sheet 2 on the document here.

Drug Distribution

Color code: If Returned to Supervisor is < Remaining with CDD, turn returned to supervisor RED.

Ward Level
Apart from the tables from levels above, I would like to also see a table showing treatment by sex and age for each CDD. I would also want to see a map view when a ward name is clicked and opened (Additional information being sought on the presentation of the map).

moshthepitt · 2021-02-12T09:55:58Z

Some context https://onaio.slack.com/archives/C8ZNYCRFV/p1613053767080700

Specifically:

Feels like this involves two steps generally:

Need to set up migrations for Reveal Kenya 💪 - this would be the same basic stuff we have for the other countries and "set up" here could either mean do nothing, or copy the existing code to a new repo just for Kenya
Create Reveal Kenya-specific queries for the reports that we want
Ensure that everything performs as well as possible
Deploy & profit

moshthepitt · 2021-02-25T06:55:32Z

@Naima-Bashir here are the next steps as of yesterday

@lincmba will reach out to you and/or Richard to get samples of the events that we will be dealing with
You (@Naima-Bashir ) will provide a sample of an MDALite plan
@lincmba will look at the dashboard description with respect to the event and plan samples above and write a document describing how to arrive at the metrics to power the dashboard i.e. where is the data coming from for each indicator
I will review @lincmba's document before query-writing work starts

ETA is 1.5 days.

Rkareko · 2021-02-25T14:15:04Z

tablet_accountability

{
  "baseEntityId": "",
  "duration": 0,
  "entityType": "Structure",
  "eventDate": "2021-02-25T00:00:00.000+0300",
  "eventType": "tablet_accountability",
  "formSubmissionId": "86103288-1f97-4fb8-8510-21de84b8f045",
  "locationId": "17de7da3-217f-4e5d-b016-4be97dd49e77",
  "obs": [
    {
      "fieldCode": "location",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "location",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "c. bunyore"
      ]
    },
    {
      "fieldCode": "cdd_name",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "cdd_name",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "emuhayaCDD1:emuhaya CDD 1"
      ]
    },
    {
      "fieldCode": "health_worker_supervisor",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "health_worker_supervisor",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "emuhayaSupervisor1:emuhaya Supervisor 1"
      ]
    },
    {
      "fieldCode": "drug_distributed",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "drug_distributed",
      "humanReadableValues": [],
      "keyValPairs": {
        "MBZ": "Mebendazole (MBZ)",
        "PZQ": "Praziquantel (PZQ)",
        "ALB": "Albendazole (ALB)"
      },
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "Praziquantel (PZQ)",
        "Albendazole (ALB)",
        "Mebendazole (MBZ)"
      ]
    },
    {
      "fieldCode": "pzq_received",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "pzq_received",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "pzq_top_up",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "pzq_top_up",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "sum_pzq_received_and_top_up",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "sum_pzq_received_and_top_up",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "2"
      ]
    },
    {
      "fieldCode": "pzq_returned",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "pzq_returned",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "albendazole_received",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "albendazole_received",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "albendazole_top_up",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "albendazole_top_up",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "sum_alb_received_and_top_up",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "sum_alb_received_and_top_up",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "2"
      ]
    },
    {
      "fieldCode": "albendazole_returned",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "albendazole_returned",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "mebendezole_received",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "mebendezole_received",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "mebendazole_top_up",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "mebendazole_top_up",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "sum_mbz_received_and_top_up",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "sum_mbz_received_and_top_up",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "2"
      ]
    },
    {
      "fieldCode": "mebendazole_returned",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "mebendazole_returned",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "",
      "fieldDataType": "start",
      "fieldType": "concept",
      "formSubmissionField": "start",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "2021-02-25 16:38:42"
      ]
    },
    {
      "fieldCode": "",
      "fieldDataType": "end",
      "fieldType": "concept",
      "formSubmissionField": "end",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "2021-02-25 16:39:16"
      ]
    },
    {
      "fieldCode": "163149AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA",
      "fieldDataType": "deviceid",
      "fieldType": "concept",
      "formSubmissionField": "deviceid",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "358240051111110"
      ]
    },
    {
      "fieldCode": "163150AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA",
      "fieldDataType": "subscriberid",
      "fieldType": "concept",
      "formSubmissionField": "subscriberid",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "310260000000000"
      ]
    },
    {
      "fieldCode": "163151AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA",
      "fieldDataType": "simserial",
      "fieldType": "concept",
      "formSubmissionField": "simserial",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "89014103211118510720"
      ]
    },
    {
      "fieldCode": "163152AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA",
      "fieldDataType": "phonenumber",
      "fieldType": "concept",
      "formSubmissionField": "phonenumber",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "+15555215554"
      ]
    }
  ],
  "providerId": "ams1",
  "team": "Team Ams",
  "teamId": "9c65502f-591d-5c47-abdc-62fdd5310d9e",
  "version": 1614260382292,
  "clientApplicationVersion": 30,
  "clientApplicationVersionName": "5.3.20",
  "clientDatabaseVersion": 13,
  "dateCreated": "2021-02-25T16:39:42.292+0300",
  "type": "Event",
  "details": {
    "taskIdentifier": "",
    "taskBusinessStatus": "",
    "taskStatus": "",
    "location_id": "",
    "locationUUID": "",
    "locationVersion": 0,
    "appVersionName": "5.3.20",
    "form_version": "0.0.1",
    "planIdentifier": "6b485d4b-1043-40ed-ab8a-c64d24045ada"
  }
}

Rkareko · 2021-02-25T14:16:41Z

cdd_supervisor_daily_summary

{
  "baseEntityId": "6cb96ec5-a89f-4eb6-bb5e-83692687095e",
  "duration": 0,
  "entityType": "Structure",
  "eventDate": "2021-02-25T00:00:00.000+0300",
  "eventType": "cdd_supervisor_daily_summary",
  "formSubmissionId": "18a79479-b72e-447c-8d81-26beb29a673a",
  "locationId": "17de7da3-217f-4e5d-b016-4be97dd49e77",
  "obs": [
    {
      "fieldCode": "date",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "date",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "25-02-2017"
      ]
    },
    {
      "fieldCode": "cdd_name",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "cdd_name",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "emuhayaCDD1:emuhaya CDD 1"
      ]
    },
    {
      "fieldCode": "health_worker_supervisor",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "health_worker_supervisor",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "emuhayaSupervisor1:emuhaya Supervisor 1"
      ]
    },
    {
      "fieldCode": "ntd_treated",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "ntd_treated",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "STH"
      ]
    },
    {
      "fieldCode": "treated_male_5-14",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "treated_male_5-14",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "12"
      ]
    },
    {
      "fieldCode": "treated_male_above_15-14",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "treated_male_above_15-14",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "treated_female_5-14",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "treated_female_5-14",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "treated_female_above_15",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "treated_female_above_15",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "total_males",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "total_males",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "0"
      ]
    },
    {
      "fieldCode": "total_female",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "total_female",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "0"
      ]
    },
    {
      "fieldCode": "drugs",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "drugs",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "PZQ"
      ]
    },
    {
      "fieldCode": "received_when",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "received_when",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "Initial balance"
      ]
    },
    {
      "fieldCode": "received_number",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "received_number",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "adminstered",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "adminstered",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "damaged",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "damaged",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "adverse",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "adverse",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "1"
      ]
    },
    {
      "fieldCode": "data_verification",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "data_verification",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "Yes"
      ]
    },
    {
      "fieldCode": "task_complete",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "task_complete",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "No"
      ]
    },
    {
      "fieldCode": "business_status",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "business_status",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "In Progress"
      ]
    },
    {
      "fieldCode": "",
      "fieldDataType": "start",
      "fieldType": "concept",
      "formSubmissionField": "start",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "2021-02-25 16:54:24"
      ]
    },
    {
      "fieldCode": "",
      "fieldDataType": "end",
      "fieldType": "concept",
      "formSubmissionField": "end",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "2021-02-25 16:55:10"
      ]
    },
    {
      "fieldCode": "163149AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA",
      "fieldDataType": "deviceid",
      "fieldType": "concept",
      "formSubmissionField": "deviceid",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "358240051111110"
      ]
    },
    {
      "fieldCode": "163150AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA",
      "fieldDataType": "subscriberid",
      "fieldType": "concept",
      "formSubmissionField": "subscriberid",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "310260000000000"
      ]
    },
    {
      "fieldCode": "163151AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA",
      "fieldDataType": "simserial",
      "fieldType": "concept",
      "formSubmissionField": "simserial",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "89014103211118510720"
      ]
    },
    {
      "fieldCode": "163152AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA",
      "fieldDataType": "phonenumber",
      "fieldType": "concept",
      "formSubmissionField": "phonenumber",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "+15555215554"
      ]
    }
  ],
  "providerId": "ams1",
  "team": "Team Ams",
  "teamId": "9c65502f-591d-5c47-abdc-62fdd5310d9e",
  "version": 1614261338239,
  "clientApplicationVersion": 30,
  "clientApplicationVersionName": "5.3.20",
  "clientDatabaseVersion": 13,
  "dateCreated": "2021-02-25T16:55:38.240+0300",
  "type": "Event",
  "details": {
    "taskIdentifier": "7855b9a9-7924-44d3-8e4e-49ea52e08749",
    "taskBusinessStatus": "Not Visited",
    "taskStatus": "READY",
    "location_id": "6cb96ec5-a89f-4eb6-bb5e-83692687095e",
    "locationVersion": 0,
    "appVersionName": "5.3.20",
    "form_version": "0.0.1",
    "planIdentifier": "6b485d4b-1043-40ed-ab8a-c64d24045ada"
  }
}

Rkareko · 2021-02-25T14:17:53Z

Sample MDA lite plan

{
  "identifier": "6b485d4b-1043-40ed-ab8a-c64d24045ada",
  "version": "1",
  "name": "MDA-Lite-Test-1-2021-02-18",
  "title": "MDA-Lite Test 1 2021-02-18",
  "status": "active",
  "date": "2021-02-18",
  "effectivePeriod": {
    "start": "2021-02-18",
    "end": "2021-04-18"
  },
  "useContext": [
    {
      "code": "interventionType",
      "valueCodableConcept": "MDA-Lite"
    },
    {
      "code": "taskGenerationStatus",
      "valueCodableConcept": "internal"
    }
  ],
  "jurisdiction": [
    {
      "code": "ce13e7f4-6926-4be0-9117-519bd1cc4bb2"
    }
  ],
  "serverVersion": 1600361461193,
  "goal": [
    {
      "id": "CDD_Supervision",
      "description": "Submit one CDD Supervisor Daily Summary form per operational area per day",
      "priority": "medium-priority",
      "target": [
        {
          "measure": "Percent of forms submitted",
          "detail": {
            "detailQuantity": {
              "value": 100,
              "comparator": ">=",
              "unit": "Percent"
            }
          },
          "due": "2021-04-18"
        }
      ]
    }
  ],
  "action": [
    {
      "identifier": "3ef7e2b8-1a11-4a5f-8454-93babb0ae641",
      "prefix": 1,
      "title": "Submit CDD Supervisor Daily Summary form",
      "description": "Visit each operational area and submit one CDD Supervisor Daily Summary form",
      "code": "CDD Supervision",
      "timingPeriod": {
        "start": "2021-02-18",
        "end": "2021-04-18"
      },
      "reason": "Routine",
      "goalId": "CDD_Supervision",
      "subjectCodableConcept": {
        "text": "Location"
      },
      "trigger": [
        {
          "type": "named-event",
          "name": "plan-activation"
        }
      ],
      "condition": [
        {
          "kind": "applicability",
          "expression": {
            "description": "Structure type does not exist",
            "expression": "$this.is(FHIR.Location)"
          }
        }
      ],
      "definitionUri": "community_drug_distributor_supervisor_daily_summary_form.json",
      "type": "create"
    }
  ],
  "experimental": false
}

Rkareko · 2021-03-03T15:10:05Z

Here is a sample cdd_supervisor_daily_summary event with treated_male_1-4 and treated_female_1-4 fields

{
  "baseEntityId": "6cb96ec5-a89f-4eb6-bb5e-83692687095e",
  "duration": 0,
  "entityType": "Structure",
  "eventDate": "2021-03-03T00:00:00.000+0300",
  "eventType": "cdd_supervisor_daily_summary",
  "formSubmissionId": "0368efae-bdd7-4113-a922-5009ff24e83c",
  "locationId": "17de7da3-217f-4e5d-b016-4be97dd49e77",
  "obs": [
    {
      "fieldCode": "date",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "date",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "02-03-2021"
      ]
    },
    {
      "fieldCode": "health_worker_supervisor",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "health_worker_supervisor",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "emuhayaSupervisor4:emuhaya Supervisor 4"
      ]
    },
    {
      "fieldCode": "cdd_name",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "cdd_name",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "emuhayaCDD4:emuhaya CDD 4"
      ]
    },
    {
      "fieldCode": "ntd_treated",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "ntd_treated",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "SCH"
      ]
    },
    {
      "fieldCode": "treated_male_1-4",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "treated_male_1-4",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "12"
      ]
    },
    {
      "fieldCode": "treated_male_5-14",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "treated_male_5-14",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "12"
      ]
    },
    {
      "fieldCode": "treated_male_above_15-14",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "treated_male_above_15-14",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "12"
      ]
    },
    {
      "fieldCode": "treated_female_1-4",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "treated_female_1-4",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "12"
      ]
    },
    {
      "fieldCode": "treated_female_5-14",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "treated_female_5-14",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "12"
      ]
    },
    {
      "fieldCode": "treated_female_above_15",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "treated_female_above_15",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "12"
      ]
    },
    {
      "fieldCode": "total_males",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "total_males",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "0"
      ]
    },
    {
      "fieldCode": "total_female",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "total_female",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "0"
      ]
    },
    {
      "fieldCode": "drugs",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "drugs",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "MBZ"
      ]
    },
    {
      "fieldCode": "received_when",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "received_when",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "None"
      ]
    },
    {
      "fieldCode": "adminstered",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "adminstered",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "12"
      ]
    },
    {
      "fieldCode": "damaged",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "damaged",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "12"
      ]
    },
    {
      "fieldCode": "adverse",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "adverse",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "12"
      ]
    },
    {
      "fieldCode": "data_verification",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "data_verification",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "No"
      ]
    },
    {
      "fieldCode": "task_complete",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "task_complete",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "No"
      ]
    },
    {
      "fieldCode": "business_status",
      "fieldDataType": "text",
      "fieldType": "formsubmissionField",
      "formSubmissionField": "business_status",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "In Progress"
      ]
    },
    {
      "fieldCode": "",
      "fieldDataType": "start",
      "fieldType": "concept",
      "formSubmissionField": "start",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "2021-03-03 18:00:59"
      ]
    },
    {
      "fieldCode": "",
      "fieldDataType": "end",
      "fieldType": "concept",
      "formSubmissionField": "end",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "2021-03-03 18:05:33"
      ]
    },
    {
      "fieldCode": "163149AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA",
      "fieldDataType": "deviceid",
      "fieldType": "concept",
      "formSubmissionField": "deviceid",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "358240051111110"
      ]
    },
    {
      "fieldCode": "163150AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA",
      "fieldDataType": "subscriberid",
      "fieldType": "concept",
      "formSubmissionField": "subscriberid",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "310260000000000"
      ]
    },
    {
      "fieldCode": "163151AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA",
      "fieldDataType": "simserial",
      "fieldType": "concept",
      "formSubmissionField": "simserial",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "89014103211118510720"
      ]
    },
    {
      "fieldCode": "163152AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA",
      "fieldDataType": "phonenumber",
      "fieldType": "concept",
      "formSubmissionField": "phonenumber",
      "humanReadableValues": [],
      "parentCode": "",
      "saveObsAsArray": false,
      "values": [
        "+15555215554"
      ]
    }
  ],
  "providerId": "ams1",
  "team": "Team Ams",
  "teamId": "9c65502f-591d-5c47-abdc-62fdd5310d9e",
  "version": 1614783951276,
  "clientApplicationVersion": 32,
  "clientApplicationVersionName": "5.3.22",
  "clientDatabaseVersion": 14,
  "dateCreated": "2021-03-03T18:05:51.276+0300",
  "type": "Event",
  "details": {
    "taskStatus": "COMPLETED",
    "location_id": "6cb96ec5-a89f-4eb6-bb5e-83692687095e",
    "form_version": "0.0.1",
    "appVersionName": "5.3.21",
    "planIdentifier": "6b485d4b-1043-40ed-ab8a-c64d24045ada",
    "taskIdentifier": "7855b9a9-7924-44d3-8e4e-49ea52e08749",
    "locationVersion": "0",
    "taskBusinessStatus": "In Progress"
  }
}

Rkareko · 2021-03-03T15:40:54Z

The wards and CDD names are stored on OpenSRP server and can be accessed via this API for Reveal stage

The relevant values are

{
                "settingMetadataId": "16718",
                "serverVersion": 0,
                "values": [
                    {
                        "hamisi": [
                            {
                                "name": "banja"
                            },
                            {
                                "name": "gisambai"
                            },
                            {
                                "name": "jepkoyai"
                            },
                            {
                                "name": "muhudu"
                            },
                            {
                                "name": "shamakhokho"
                            },
                            {
                                "name": "shiru"
                            },
                            {
                                "name": "tambua"
                            }
                        ],
                        "emuhaya": [
                            {
                                "name": "c. bunyore"
                            },
                            {
                                "name": "n.e. bunyore"
                            },
                            {
                                "name": "w. bunyore"
                            }
                        ],
                        "vihiga": [
                            {
                                "name": "c. maragoli"
                            },
                            {
                                "name": "lugaga"
                            },
                            {
                                "name": "mungoma"
                            },
                            {
                                "name": "s. maragoli"
                            }
                        ],
                        "sabatia": [
                            {
                                "name": "busali"
                            },
                            {
                                "name": "chavakali"
                            },
                            {
                                "name": "lyaduywa"
                            },
                            {
                                "name": "wodanga"
                            }
                        ],
                        "luanda": [
                            {
                                "name": "emabungo"
                            },
                            {
                                "name": "luanda south"
                            },
                            {
                                "name": "l. township"
                            },
                            {
                                "name": "mwibona"
                            },
                            {
                                "name": "wemilabi"
                            }
                        ]
                    }
                ],
                "description": "List of wards per sub-county",
                "label": "List of ward names and codes",
                "type": "Setting",
                "uuid": "0cdf3412-6f71-11eb-9439-0242ac130002",
                "key": "wards",
                "settingIdentifier": "global_configs"
            }

{
                "settingMetadataId": "16720",
                "serverVersion": 0,
                "values": [
                    {
                        "emuhaya": [
                            {
                                "code": "emuhayaCDD1",
                                "name": "emuhaya CDD 1"
                            },
                            {
                                "code": "emuhayaCDD2",
                                "name": "emuhaya CDD 2"
                            },
                            {
                                "code": "emuhayaCDD3",
                                "name": "emuhaya CDD 3"
                            },
                            {
                                "code": "emuhayaCDD4",
                                "name": "emuhaya CDD 4"
                            },
                            {
                                "code": "emuhayaCDD5",
                                "name": "emuhaya CDD 5"
                            }
                        ]
                    }
                ],
                "description": "List of community drug distributors per ward",
                "label": "List of cdd names and codes per ward",
                "type": "Setting",
                "uuid": "9f0a4cae-6f77-11eb-9439-0242ac130002",
                "key": "community_drug_distributors",
                "settingIdentifier": "global_configs"
            }

lincmba · 2021-03-03T15:50:43Z

Document describing how to arrive at the metrics to power the dashboard https://docs.google.com/document/d/1WrQYhkET5Ws-gg8d2hZtHM9hEVqkF8IdtCesq2Ni7lQ/edit#

lincmba · 2021-03-05T13:33:57Z

MDA Lite Plan sample json opensrp/opensrp-client-reveal#1248

samkanga · 2021-03-10T13:17:26Z

@ciremusyoka as per the conversation earlier today, the client provided additional information on the presentation of the maps. This is as follows:

The map is to be shown at the sub-county level showing the wards under the sub-county and the treatment disaggregations for Male and Female, and showing the demarcation of the wards. See sample view below:

From the map view, one should also be able to drill down to the ward level table and CDD information table. Let me know how much this will affect the timelines we are working with.

samkanga · 2021-03-15T07:59:41Z

@ciremusyoka @lincmba for the indicator average per day this should be derived by: Total number of treatments done by a CDD / total number of days worked.

lincmba · 2021-03-26T11:27:31Z

@samkanga
I am currently blocked by the OpenSRP issue that @Rkareko is working on with missing base_entity_id values in events of event_type: tablet_accountability .
I will need to be reassigned to this once I am unblocked to resume work on this issue

lincmba · 2021-03-31T20:25:24Z

The following has been done and based on conversations with @ciremusyoka , is sufficient to proceed:

kenya_mda_lite_wards_geojson has ward geojson data and also data aggregated according to genders
kenya_mda_lite_wards has data linking wards to their parent id's (subcounties)
supervisor_drug_distribution that has data of work done by a supervisor on a ward
ward_drug_distribution has data that can map cdds to supervisors in a ward.

samkanga added the needs scoping Something needs clarification / scoping before working on it label Feb 11, 2021

ukanga assigned moshthepitt Feb 12, 2021

Naima-Bashir added this to the End Fund Milestone milestone Feb 16, 2021

Naima-Bashir assigned lincmba Feb 24, 2021

samkanga added Priority: High and removed needs scoping Something needs clarification / scoping before working on it labels Mar 10, 2021

ciremusyoka mentioned this issue Mar 18, 2021

MDA Lite Reporting #1536

Merged

Naima-Bashir added the endfund label Apr 22, 2021

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Create Kenya End Fund MDA Dashboards #1494

Create Kenya End Fund MDA Dashboards #1494

samkanga commented Feb 11, 2021 •

edited

Loading

moshthepitt commented Feb 12, 2021 •

edited

Loading

moshthepitt commented Feb 25, 2021

Rkareko commented Feb 25, 2021 •

edited

Loading

Rkareko commented Feb 25, 2021 •

edited

Loading

Rkareko commented Feb 25, 2021

Rkareko commented Mar 3, 2021

Rkareko commented Mar 3, 2021 •

edited

Loading

lincmba commented Mar 3, 2021

lincmba commented Mar 5, 2021 •

edited

Loading

samkanga commented Mar 10, 2021

samkanga commented Mar 15, 2021

lincmba commented Mar 26, 2021 •

edited

Loading

lincmba commented Mar 31, 2021

Create Kenya End Fund MDA Dashboards #1494

Create Kenya End Fund MDA Dashboards #1494

Comments

samkanga commented Feb 11, 2021 • edited Loading

moshthepitt commented Feb 12, 2021 • edited Loading

moshthepitt commented Feb 25, 2021

Rkareko commented Feb 25, 2021 • edited Loading

Rkareko commented Feb 25, 2021 • edited Loading

Rkareko commented Feb 25, 2021

Rkareko commented Mar 3, 2021

Rkareko commented Mar 3, 2021 • edited Loading

lincmba commented Mar 3, 2021

lincmba commented Mar 5, 2021 • edited Loading

samkanga commented Mar 10, 2021

samkanga commented Mar 15, 2021

lincmba commented Mar 26, 2021 • edited Loading

lincmba commented Mar 31, 2021

samkanga commented Feb 11, 2021 •

edited

Loading

moshthepitt commented Feb 12, 2021 •

edited

Loading

Rkareko commented Feb 25, 2021 •

edited

Loading

Rkareko commented Feb 25, 2021 •

edited

Loading

Rkareko commented Mar 3, 2021 •

edited

Loading

lincmba commented Mar 5, 2021 •

edited

Loading

lincmba commented Mar 26, 2021 •

edited

Loading