-
Type:
Task
-
Resolution: Unresolved
-
Priority:
Low
-
Affects Version/s: None
-
None
-
STOP TB Sprint 8
-
STOP TB
-
All
Background The m_nikshay_state/district/tu/facility/village tables hold the location hierarchy used to match Stop TB beneficiaries to Nikshay (India's national TB program) for reporting via the Nikshay ID Generator bridge. These tables are currently loaded from an outdated source and are badly out of sync with Nikshay's actual official data.
Problem Comparing the live DB against Nikshay's own official location export ("original json") shows two issues per state:
- Missing data — the large majority of correct village/facility/TU entries were never inserted (coverage ranges from 0.4% to 4.2% depending on the state)
- Wrong mappings — a smaller number of villages already in the DB are attached to the wrong facility
Scope — all states, not state-specific