📏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:
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
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
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
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
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
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.
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
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
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:
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
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
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