Community Hospital Ward utilization
Dear list, I am thinking of designing a monitoring system for a short-term community hospital ward with 9 beds
Among variables are
Patient ID indate (admission date) <dd/mm/yyyy> inhour admission hour ## outdate (discharge date) <dd/mm/yyyy> outhour discharge hour ## (not always recorded)
Age, sex diagnose1, diagnose2 diagnose3, treatment elements etc.
Does anybody have a hint on how I can monitor utilization rate, i.e. how many beds are occupied each day, and average utilization rate per week?
In Epi Info I would put up a sequence of commands that runs through the datafile for each consecutive day to count number of patients. in EpiInfo the PROCESS command would run thhrough the file and do the maths
I thought a defined variable inhouse # and a counter date gen d testdate ="01/09/2013" // Opening date
if testdate < today then if testdate >=indate and testdate <=outdate then inhouse=1 else inhouse=0 endif testdate=testdate + 1 else goto end endif
Then route to an aggregate file date, count.
PROCESS
But there seems to be no equivalent command in EpiData. I have not figured out if aggregate or stab could be used for such a purpose. Anye ideas or hints?
Best Regards Vegard Høgli Community Medical Officer Skien, Norway
In Epidata Analysis, you could do something like this for daily utilization for a whole week:
read thedatafile define aday <dd/mm/yyyy> global define sday #### global define avbed ###.#
aday = dmy(?Start day?,?Start month?,?Start year?) // allows you to set a start date // add an imif here to check validity of the start date
sday = 0 ? “Utilization for the week starting @aday"
count if (indate <= aday) and (outdate >= a day) ? “Beds used on @aday : @$count” sday = sday + $count aday = aday + 1
count if (indate <= aday) and (outdate >= a day) ? “Beds used on @aday : @$count” sday = sday + $count aday = aday + 1
// repeat last 4 steps 5 more times
avbed = float(sday)/7.0 ? “Average bed count for the week was #avbed”
Note that the 4 commands starting with count if could be used to define a cmd to simplify the program. You could also set aday this way to get the 7 previous days:
aday = today - 6
Jamie
On May 28, 2014, at 6:08 PM, epidata-list@lists.umanitoba.ca wrote:
Does anybody have a hint on how I can monitor utilization rate, i.e. how many beds are occupied each day, and average utilization rate per week?
participants (1)
-
epidata-list＠lists.umanitoba.ca