Report for number of patients checked into worklist

Hi,

I am after a report to see how many patients are admitted into hospital (filtered by department) and I think the best way would be a report showing the patients checked-in to a worklist.

Does anyone have anything like this or any other way to show these stats?

 

Thanks,

greta

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Report for number of patients checked into worklist

There isn't any existing report that I'm aware of.

Here's some basic SQL to extract the information. It can be used as the basis for a JasperReport.

As usual, if you want fund development of a report, please let us know at support[at]openvpms[dot]com. Please consider contributing it back to the project so other users can benefit.

select task.act_id task_id,
    task.activity_start_time start_time,
    task.status,
    worklist.entity_id worklist_id,
    worklist.name worklist_name,
    customer.entity_id customer_id,
    customer.name customer_name,
    patient.entity_id patient_id,
    patient.name patient_name
from acts task
join participations pworklist
    on pworklist.act_id = task.act_id
        and pworklist.arch_short_name = 'participation.worklist'
join entities worklist
    on worklist.entity_id = pworklist.entity_id
join participations pcustomer
    on pcustomer.act_id = task.act_id
        and pcustomer.arch_short_name = 'participation.customer'
join entities customer
    on pcustomer.entity_id = customer.entity_id        
left join participations ppatient
    on ppatient.act_id = task.act_id
        and ppatient.arch_short_name = 'participation.patient'
left join entities patient
    on patient.entity_id = ppatient.entity_id
where task.arch_short_name = 'act.customerTask'
    and task.status <> 'COMPLETED'
    and task.status <> 'CANCELLED';

 

Syndicate content