@extends('layouts.app') @section('content') @auth

Report Calculations

date
date

Clinic Total Comparison

Compared clinics: HTY-A, HTY-C1, HTY-B, SPT, SDG, TL
Run count to load comparison chart.

NCD New/Old Visit Comparison

By selected date range (From/To), using visit-date based filters.
Column Explanation
Data source labels: ncd_pt_registers = NCD registered Data, ncd_followups = NCD followup Data, followup_generals = Reception's Disease Category Data.
How 7 columns are counted:
1. NCD Register (Reg_Date): Count from ncd_pt_registers where Reg_Date is between From and To.
2. NCD Follow-up New Visit: From selected IDs, first (earliest) Visit_date per ID in range from ncd_followups.
3. NCD Follow-up Old Visit: Other follow-up visits for same ID in range (visit count > 1) from ncd_followups.
4. General NCD New: Count from followup_generals where decoded NCD status is New in range.
5. General NCD Old: Count from followup_generals where decoded NCD status is Old in range.
6. New Difference: NCD Follow-up New Visit - General NCD New.
7. Old Difference: NCD Follow-up Old Visit - General NCD Old.
Clinic NCD Register (Reg_Date) NCD Follow-up New Visit NCD Follow-up Old Visit General NCD New General NCD Old New Difference Old Difference
Run count to load comparison table.

Data Count Table

Date NCD Register NCD Follow up STI Male STI Female TB03 Pre-TB IPT Cervical Cancer Screening CMV Mental Register Mental Follow Up HBV Register PrEP Screen PrEP Follow Up PrEP Facility Log Sheets CBS Total
Total Count 0

Staff Entry Tracker

Manual assign staff, clinic and tables, then click "Check Staff Entry" to get total entry counts within selected date range.
Staff Name Clinic Assigned Tables Total Count Breakdown
Tip: Hold Ctrl (or Cmd) to select multiple tables. Staff assignment will be remembered on this browser.
@endauth @endsection