> For the complete documentation index, see [llms.txt](https://spice.docs.medtroniclabs.org/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://spice.docs.medtroniclabs.org/reporting-and-data/standard-indicators.md).

# 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](https://spice.docs.medtroniclabs.org/reporting-and-data/reporting-web-application.md) and [Data Pipeline & Analytics](https://spice.docs.medtroniclabs.org/reporting-and-data/data-pipeline-and-analytics.md).

## 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](https://spice.docs.medtroniclabs.org/reporting-and-data/data-pipeline-and-analytics.md). |
| Practitioner scope          | Dashboard counts include only visits by the signed-in user or visits with no recorded practitioner.                                                                                             |
