All pull requests

Pull requests

• Add OP Patient Due Report documentation with SQL query and parameters

  #170·sonzsara opened Oct 29, 2026Contributor·

  ·
  9

• Add IP Patient Due Report documentation with SQL query and parameters

  #169·sonzsara opened Oct 29, 2026Contributor·

  ·
  10

• Add stock movement documentation with SQL query and parameters

  #168·sonzsara opened Oct 29, 2026Contributor·

  ·
  9

• Add SQL documentation for various stock value calculations including external purchase, consumed, dispensed, return, and total stock values

  #167·sonzsara opened Oct 26, 2026Contributor·

  ·
  11

• analytics-review: reconcile each run, catch removals and stale branches, approve as one of two

  #166·amjithtitus09 opened Oct 12, 2026Member·3 of 5 tasks·

  ·
  15

• Add documentation for Count of Facilities query with cumulative counts

  #165·sonzsara opened Oct 12, 2026Contributor·

  ·
  5

• Update the query to Round the total balance amount

  #164·sonzsara opened Oct 12, 2026Contributor·

  ·
  8

• Add report for invoices with duplicate discounts on charge items

  #163·sonzsara opened Sep 30, 2026Contributor·

  ·
  11

• Documentation on accounts with no encounters linked

  #162·sonzsara opened Sep 30, 2026Contributor·

  ·
  7

• Add lab tests documentation with activity definition, observations and reference ranges

  #160·sonzsara opened Sep 30, 2026Contributor·

  ·
  11

• Add month-on-month purchase value difference analysis documentation for a specific supplier

  #159·sonzsara opened Aug 31, 2026Contributor·

  ·
  9

• Add documentation for laboratory service requests and their charge items

  #158·sonzsara opened Aug 31, 2026Contributor·

  ·
  11

• Add documentation for list of users with manager role assigned to specific organizations

  #157·sonzsara opened Aug 31, 2026Contributor·

  ·
  7

• Add documentation for Patients with Billable Charge Item and Encounter/Appointment Details query

  #147·sonzsara opened Aug 13, 2026Contributor·

  ·
  17

• Documentation on Total Stock Value with Location Split

  #146·sonzsara opened Aug 13, 2026Contributor·

  ·
  8

• Add documentation for Stock in Air query at SSMM

  #145·sonzsara opened Aug 13, 2026Contributor·

  ·
  9

• Add documentation for Patients With Medication Due query

  #143·sonzsara opened Aug 11, 2026Contributor·

  ·
  4

• Add documentation for counting patients with high RBS

  #142·sonzsara opened Aug 11, 2026Contributor·

  ·
  4

• Add documentation for counting patients with high blood pressure

  #141·sonzsara opened Aug 11, 2026Contributor·

  ·
  2

• Add documentation for hierarchical mapping of districts, grama panchayats, and wards

  #140·sonzsara opened Aug 3, 2026Contributor·

  ·
  5

• Add documentation for Nursing Procedures Count by Facility query

  #139·sonzsara opened Aug 3, 2026Contributor·

  ·
  8

• Add documentation for encounters without appointments query

  #138·sonzsara opened Jul 24, 2026Contributor·

  ·
  10

• Add documentation for Items Transferred to Consumption and Entered-in-Error Locations query

  #137·sonzsara opened Jul 24, 2026Contributor·

  ·
  6

• Documentation for community nurse patients linked to a volunteer by facility

  #136·sonzsara opened Jul 24, 2026Contributor·

  ·
  12

• Add documentation for Bed Availability Prediction query

  #135·sonzsara opened Jul 24, 2026Contributor·

  ·
  16