Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Create Kenya End Fund MDA Dashboards #1494

Open
samkanga opened this issue Feb 11, 2021 · 13 comments
Open

Create Kenya End Fund MDA Dashboards #1494

samkanga opened this issue Feb 11, 2021 · 13 comments
Assignees
@moshthepitt @lincmba
Labels
endfund Priority: High
Milestone
End Fund Milestone

Comments

@samkanga
Copy link

samkanga commented Feb 11, 2021 •
edited
Loading

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
image

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
image

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).
image
@samkanga samkanga added the needs scoping Something needs clarification / scoping before working on it label Feb 11, 2021
@moshthepitt
Copy link
Contributor

moshthepitt commented Feb 12, 2021 •
edited
Loading

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 💪 - 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

@Naima-Bashir Naima-Bashir added this to the End Fund Milestone milestone Feb 16, 2021
@moshthepitt
Copy link
Contributor

@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
Copy link

Rkareko commented Feb 25, 2021 •
edited
Loading

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
Copy link

Rkareko commented Feb 25, 2021 •
edited
Loading

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
Copy link

Rkareko commented Feb 25, 2021

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
Copy link

Rkareko commented Mar 3, 2021

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
Copy link

Rkareko commented Mar 3, 2021 •
edited
Loading

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
Copy link

lincmba commented Mar 3, 2021

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

@lincmba
Copy link

lincmba commented Mar 5, 2021 •
edited
Loading

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

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

@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:
    image

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
Copy link
Author

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

@ciremusyoka ciremusyoka mentioned this issue Mar 18, 2021
Merged
@lincmba
Copy link

lincmba commented Mar 26, 2021 •
edited
Loading

@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
Copy link

lincmba commented Mar 31, 2021

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@moshthepitt moshthepitt

@lincmba lincmba

Labels
endfund Priority: High
Projects
None yet
Milestone
End Fund Milestone
Development

No branches or pull requests
5 participants
@moshthepitt @samkanga @lincmba @Rkareko @Naima-Bashir