Skip to content

Pull requests: ohcnetwork/care_analytics_sql

New pull request New
31 Open 17 Closed
31 Open 17 Closed
Author
Filter by author
Loading
Label
Filter by label
Loading
Use alt + click/return to exclude labels
or ⇧ + click/return for logical OR
Projects
Filter by project
Loading
Milestones
Filter by milestone
Loading
Reviews
Filter by reviews
No reviews Review required Approved review Changes requested
Assignee
Filter by who’s assigned
Assigned to nobody Loading
Sort
Sort by
Newest Oldest Most commented Least commented Recently updated Least recently updated Best match
Most reactions
👍 👎 😄 🎉 😕 ❤️ 🚀 👀

Pull requests list

Add documentation for X-Ray Revenue and Count queries at SSMM
#93 opened May 4, 2026 by sonzsara Contributor Loading…
Add count of scan and the revenue collected query
#92 opened May 4, 2026 by sonzsara Contributor Loading…
17
Add documentation for Lab Test Revenue and Count queries at SSMM
#91 opened May 4, 2026 by sonzsara Contributor Loading…
Add pharmacy revenue documentation for SSMM
#90 opened May 4, 2026 by sonzsara Contributor Loading…
Add detailed query for discharged but incomplete IP encounters at SSMM
#88 opened May 4, 2026 by sonzsara Contributor Loading…
Add bed occupancy summary documentation
#87 opened May 4, 2026 by sonzsara Contributor Loading…
Add IP Encounter Count and List for SSMM excluding fake beds
#86 opened May 4, 2026 by sonzsara Contributor Loading…
8
Add documentation for Fake IP Encounters with Bed Assignment query
#85 opened Apr 24, 2026 by sonzsara Contributor Loading…
5
Added queries for ASAP - Today appointments: booked, checked in, and fulfilled for arike
#70 opened Jan 12, 2026 by sonzsara Contributor Loading…
1
Added STAT appointment queries for booked, checked in, and fulfilled statuses for arike
#69 opened Jan 12, 2026 by sonzsara Contributor Loading…
1
Add medication dispense query documentation (arike)
#68 opened Jan 9, 2026 by sonzsara Contributor Loading…
1
Added upcoming appointments col to active patient list for arike
#67 opened Jan 9, 2026 by sonzsara Contributor Loading…
1
Added users filter to the open encounters list (arike)
#66 opened Jan 9, 2026 by sonzsara Contributor Loading…
1
Add user activity tracking queries for specimen collection and diagnostic reports for ssmm
#58 opened Jan 6, 2026 by sonzsara Contributor Loading…
1
Add user activity tracking queries for invoices, supply deliveries, and service requests for ssmm
#57 opened Jan 6, 2026 by sonzsara Contributor Loading…
1
Add queries for user activity tracking for ssmm: medication administered, prescribed, and dispensed
#56 opened Jan 6, 2026 by sonzsara Contributor Loading…
1
Add documentation for user encounter creation query for ssmm
#55 opened Jan 6, 2026 by sonzsara Contributor Loading…
1
Add users list with departments documentation and query for ssmm
#54 opened Jan 6, 2026 by sonzsara Contributor Loading…
1
Add inventory stock list documentation for ssmm
#48 opened Dec 29, 2025 by sonzsara Contributor Loading…
1
Add detailed active invoices query with documentation for arike
#47 opened Dec 29, 2025 by sonzsara Contributor Loading…
1
Add total registrations and revenue query documentation for ssmm
#46 opened Dec 29, 2025 by sonzsara Contributor Loading…
1
Add queries for first-time and follow-up consultation revenue tracking for ssmm
#45 opened Dec 29, 2025 by sonzsara Contributor Loading…
1
Add inpatient encounters query with parameters and documentation for ssmm
#41 opened Dec 20, 2025 by sonzsara Contributor Loading…
1
Add supplier delivery details documentation and query for ssmm
#40 opened Dec 20, 2025 by sonzsara Contributor Loading…
1
Add documentation for comfort devices, patient transfers, and nursin…
#32 opened Dec 16, 2025 by sonzsara Contributor Loading…
1
ProTip! Adding no:label will show everything without a label.