Four questions a hospital asks most weeks. Each one is answerable because of a schema change made during the rebuild, and none of them could be asked of the system this replaced.
Each card is hidden unless your role can open it.
Nothing is stored as a total
Every figure is worked out when you open the report. There is no summary table updated by a nightly job, which means there is nothing that can quietly fall out of step with the records underneath it. It costs a little time on a large database and it is worth it.
Outstanding lab work
Every test requested and not yet reported, oldest first, with anything past three days marked. Because a request is rows rather than one report field, a request with the bloods back and the culture still growing shows the culture alone instead of appearing as an entire outstanding request.
Drug usage
What was prescribed next to what was actually dispensed, across a date range you choose. The gap between the two columns is the part worth reading, and rows that were prescribed and never dispensed are marked.
Aged debtors
Who owes money, in the usual ageing buckets, with a total. Balances come from the payment rows rather than a single received column, so a part paid invoice shows its real remainder instead of reading as either settled or untouched.
Bed occupancy
Occupancy per day across a range, the busiest day, the number of discharges, the average length of stay and the split by ward. Counted from admissions rather than from the bed status column, so it agrees with the ward board.
What is not here
Reporting covers those four questions. Anything else still means querying the database directly. If there is a report your hospital runs every week, tell us what it has to show and we will look at it, because the tables underneath are now shaped to support that kind of question.
See it rather than read about it. All four reports are shown in the user guide.
The user guide walks the whole system in the order you would meet it, and the screenshots page has every screen. The source is on GitHub under the GPL v3.