Create Kenya End Fund MDA Dashboards

[samkanga]

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]

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

Specifically:

Feels like this involves two steps generally:

1. Need to set up migrations for Reveal Kenya :muscle: - 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
2. Create Reveal Kenya-specific queries for the reports that we want
3. Ensure that everything performs as well as possible
4. Deploy & profit

[moshthepitt]

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

1. @lincmba will reach out to you and/or Richard to get samples of the events that we will be dealing with
2. You (@Naima-Bashir ) will provide a sample of an MDALite plan
3. @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
4. I will review @lincmba's document before query-writing work starts

ETA is 1.5 days.

[Rkareko]

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]

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]

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]

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]

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]

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

[lincmba]

MDA Lite Plan sample json https://github.com/OpenSRP/opensrp-client-reveal/issues/1248

[samkanga]

@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]

@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]

@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]

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.