Yodha Clinical Evaluation System
Offline unit screening dashboard for medical grading, readiness review, and follow-up prioritization
Overview & Scope
Developed the Yodha Clinical Evaluation System as a secure, offline-first decision-support platform for authorized unit administrators and command reviewers. Built using Microsoft Access and VBA, the database replaces manual files with structured health tracking, physical assessment records, and wellbeing follow-up modules.
Decision-Support and Readiness Review
Designed for a military-unit administrative environment, the database operates on a split Front-End/Back-End architecture so sensitive records can remain local and access-managed. It helps authorized reviewers audit medical readiness and follow-up status using several vectors:
- Compliance Auditing: Visual dashboards track complete and incomplete profiles across internal groups, helping administrators monitor screening coverage.
- Low Medical Category Tracking: Automates the listing of personnel with documented restrictions, supporting safer role-allocation decisions within approved administrative policy.
- Decision-Support and Follow-up Flags: Compares physical assessment, clinical indicators, and configured thresholds, giving reviewers cautionary follow-up cues without exposing operational specifics.
- Motivation-Capability Performance Quadrants: Categorizes aggregate indicators to help reviewers identify where supportive counselling or supervisory attention may be useful.
Review Workflow Integration
To maintain accountability, the system enforces a multi-tier sign-off protocol. Baseline screenings entered by data operators move through supervisory review before Battery Commander-level administrative sign-off.
Core Deliverables
- Subunit Auditing to track screening progress across subunits without naming specific formations.
- Low Medical Category tracking to help administrators plan role allocation within documented fitness restrictions.
- Automated Follow-up Flags calculating threshold-based review cues for clinical, physical, and wellbeing indicators.
- Performance Quadrant Analysis mapping aggregate motivation and capability indicators to prioritize supportive follow-up.
- Multi-Tier Sign-Off Workflow linking data operators, Subedar Major-level review, and Battery Commander sign-off for accountability.