For the complete documentation index, see llms.txt. This page is also available as Markdown.

📏Standard Indicators

This page lists the indicators and measures SPICE computes out of the box, how each is defined, and where it appears. It is derived from what the reporting ETL and the mobile app's dashboard actually calculate. It does not describe indicators that are configured only in a particular deployment.

There are three places indicators come from:

Source
What it produces
Granularity

In-app dashboard

Service counts for the signed-in health worker, grouped by programme area

Counts of services (visits) recorded on the device, with a few person-level exceptions

NCD program indicators (reporting ETL)

Monthly hypertension and diabetes program indicators and cohort snapshots

One row per enrolled patient per report month; aggregate by site or district for rates

RMNCH report tables (reporting ETL)

Record-level tables, one row per visit or event, with full geography and provider

Visit level. Rates are computed by the consumer

How people and visits are counted

Concept
Rule

Visit (service) vs. person

In-app dashboard cards count services (one per recorded visit) unless the table below says "distinct". RMNCH report tables are visit-level, so row counts are visits.

Unique person

NCD program indicators identify a person by the patient-tracker identifier. Each patient appears once per report month.

First vs. follow-up

The dashboard treats a member's earliest NCD visit on the device as the screening (first service) and every later NCD visit as a follow-up assessment. This is based on the visit history on the device, regardless of the selected date range.

Newly enrolled vs. known

The NCD program indicators place a patient in a cohort by enrolment month. Patients enrolled within the last three calendar months (current and previous two) are not in the indicator denominator yet.

Reporting period (dashboard)

Today, this week (Monday to today), this month (first of the month to today), or a custom date range. Dates are compared in the device's local time.

Reporting period (NCD indicators)

Calendar month. The current month is rebuilt on each ETL run, so it grows until month end. Earlier months are retained as snapshots. Cohort tables are appended with a report date.

Scope filters

The dashboard can be narrowed by community health worker catchment or by community unit. It counts only visits recorded by the signed-in user, or visits with no recorded practitioner.

In-app dashboard indicators

The dashboard is computed on the device from locally stored visit history, so it reflects what the user has recorded or synced, even offline. Cards are grouped into programme tabs (all, maternal and child health, NCD, eye care, other services). Which cards appear depends on the user's role and the clinical workflows enabled for their facility.

Maternal, newborn and child health

Indicator
Definition
Counting unit

Pregnancy registration

Pregnant-woman profile visits in the period.

Visits

ANC services

Antenatal care visits in the period.

Visits

PW registered within 3 months and received ANC

Pregnancies where the woman was registered within 90 days after the last menstrual period and has at least one antenatal visit in the period. Limited to the woman's latest pregnancy, only if that pregnancy has no recorded delivery and its expected delivery date is not more than 45 days in the past.

Pregnancies

3/3+ ANC services

Women with an antenatal visit numbered 3 in the period.

Distinct women

High-risk pregnant women

Antenatal visits whose status carries a high-risk pregnancy flag.

Visits

Pregnancy outcome

Pregnancy outcome visits in the period.

Visits

PNC within 72 hours

Postnatal mother visits made 0 to 72 hours (inclusive) after the recorded delivery time. Delivery is taken from the pregnancy outcome of the same pregnancy, else the member's latest earlier outcome.

Visits

PNC after 72 hours

All other postnatal mother visits, including visits with no usable delivery time. Together with the previous card it equals all postnatal mother visits.

Visits

Under-2 children counselled

Childhood visits in the period.

Visits

Family planning counselled

Family-planning visits in the period.

Visits

Households registered

Households created in the period (by creation date).

Households

Non-communicable diseases

Indicator
Definition
Counting unit

NCD screening

Members whose first-ever NCD visit on the device falls in the period.

Visits (first per member)

NCD follow-up assessment

NCD visits in the period that have an earlier NCD visit for the same member.

Visits

Total NCD services

All NCD visits in the period, plus NCD services delivered at a cataract camp.

Visits

NCD referred

A member's first referral recorded on an NCD (or cataract-camp NCD) visit, if it falls in the period. Counted once per member.

Members

Linked to care

Members with an enrolment visit in the period whose most recent NCD service up to that point was delivered by the signed-in user.

Distinct members

At facilities that provide only community-level NCD services, only Total NCD services and NCD referred are shown. The other three are hidden.

Eye care and other services

Indicator
Definition
Counting unit

Total eye screening

Eye-care visits in the period.

Visits

Glasses sold

Visits carrying the glasses-sold status.

Visits

Cataract screening

Cataract visits in the period.

Visits

Patients referred for operation

Cataract visits carrying the referred-for-operation status.

Visits

NCD services in cataract camp

Cataract visits carrying the NCD-service-at-camp status.

Visits

Other services

Visits of type "other services".

Visits

Demographic summary

Indicator
Definition
Counting unit

Total households

Households created in the period.

Households

Total members

Household members created in the period, excluding members created by roles other than the community health worker role.

Members

Total pregnant women

Same count as Pregnancy registration.

Visits

NCD program indicators (reporting ETL)

Two monthly tables hold hypertension and diabetes program indicators, one row per patient per month. Rates are computed by summing the flag columns over a site or district and dividing by the denominator. Both are generated from the same patient-level logic, and the cohort tables carry the same measures summarised by enrolment month and site.

Who is counted

A patient is included when all of the following hold:

  • Patient status is enrolled, with an enrolment date on or before the report month end.

  • The patient's tracker and facility are not deleted, and the facility is not excluded from reporting.

  • The enrolment was created by a user in the nurse role.

  • The patient has a confirmed diagnosis of the relevant condition.

Diagnosis class
Matches (case-insensitive)

Hypertension

Hypertension, pre-hypertension

Diabetes

Diabetes, diabetes mellitus type 1 or 2, pre-diabetes

Co-morbid

Both of the above

The hypertension table includes patients classed as hypertension or co-morbid. The diabetes table includes patients classed as diabetes or co-morbid. A diagnosis recorded as a comma-separated list is split before matching.

Indicator definitions

Indicator
Definition

Total registrations

Every included patient, one each.

Patients under care

Included patients who are not lost to follow-up.

Lost to follow-up

Included patients whose most recent visit is more than 365 days before the report month end. A visit is a medical review, a prescription or a blood pressure or glucose reading. With no visits, enrolment date is used.

Denominator patients

Included patients enrolled before the three-month window, meaning before the first day of the month two months earlier than the report month.

Controlled at enrolment

Denominator patients whose enrolment reading is controlled (rules below).

Uncontrolled at enrolment

Denominator patients whose enrolment reading is uncontrolled.

Controlled at follow-up

Denominator patients whose latest reading in the three-month window is controlled.

Uncontrolled at follow-up

Denominator patients whose latest reading in the three-month window is uncontrolled.

Missed visits

Denominator patients with no reading in the three-month window.

Visit but no reading taken

Denominator patients whose latest reading in the window is empty or zero for all measures.

Average values

Enrolment and follow-up averages for systolic and diastolic pressure (hypertension) or fasting and random glucose (diabetes), carried on each patient row.

The three-month window is the report month and the two calendar months before it. The follow-up reading is the latest reading in the window.

The enrolment reading is, in order of preference: a reading marked as updated from enrolment, or taken on the enrolment day or the day before (latest such reading). Otherwise it is the reading closest in time to enrolment among those taken before the three-month window.

Controlled and uncontrolled

Condition
Controlled when
Uncontrolled when

Blood pressure

Average systolic is below 140 and average diastolic is below 90 mmHg.

Systolic is 140 or more or diastolic is 90 or more.

Fasting blood glucose

Above 4.0 and below 7.0 mmol/L.

Otherwise.

Random blood glucose

Above 4.0 and below 11.1 mmol/L.

Otherwise.

Diabetes overall

Random or fasting glucose is in its controlled range, or HbA1c is below 7.0.

Otherwise.

Blood pressure uses the average of the readings taken at that visit.

Diabetes also records follow-up glucose bands per patient:

Measure
Low
Middle
High

Random glucose

Below 11.1

11.1 to 16.6

Above 16.6

Fasting glucose

Below 7.0

7.0 to 11.1

Above 11.1

Cohort tables

The cohort tables are appended daily with a report date, one row per patient and a summary row per enrolment month and site. For hypertension they add reduction measures: patients whose follow-up systolic is at least 10 mmHg lower than at enrolment, and whose diastolic is at least 5 mmHg lower, with the same measures restricted to patients uncontrolled at enrolment. For diabetes they add counts and averages of fasting and random glucose at enrolment and over the last three months, split by controlled and uncontrolled.

Where indicators appear

Indicator group
In-app dashboard
Reporting database
Reporting web application
Analytics dashboards

MNCH service counts

Yes

Record-level tables only

NCD service counts

Yes

Record-level tables

Patient lists by screening, enrolment and assessment

NCD program indicators (control, follow-up, lost to follow-up)

No

Yes, monthly and cohort tables

Available to any BI tool reading the reporting database

Eye care counts

Yes

Eye tests and NCD eye and cataract tables

See Reporting Web Application and Data Pipeline & Analytics.

Data definitions

Term
Definition

Enrolled patient

A person whose NCD patient status is enrolled. Status is read from the latest version of the related-person record.

Screened person (dashboard)

A member whose first NCD visit on the device falls in the selected period.

Follow-up visit

Any NCD visit after the member's first.

Confirmed diagnosis

A diagnosis recorded on a confirm-diagnosis record. Pre-hypertension and pre-diabetes are counted with hypertension and diabetes in the program indicators.

Controlled blood pressure

Average systolic below 140 and average diastolic below 90 at the reading used.

Controlled glucose

See the glucose rules above.

Enrolment month

The calendar month of the patient's enrolment date.

Lost to follow-up

No visit in the 365 days before the report month end.

Report month

Calendar month, stored as a label such as OCT 2026.

Visit date

Clinical dates are converted to one fixed local offset before storage. See Data Pipeline & Analytics.

Practitioner scope

Dashboard counts include only visits by the signed-in user or visits with no recorded practitioner.

Last updated