Hey Lisa,
I have a question and comment.
1. From your post, it sounds like you know which program they are in by their Room#. Is that correct? If that is the case, it sounds like we could add another field to track the service, or we could look at some BizStream Connect options.
2. Ottawa County has been hard at work with BizStream to create a Placements/Services/Programs feature that will allow you to see a "timeline of events" for a client (or like you said, an aggregate across the entire organization). The time line will be pretty much all of the "IN and OUT" dates for every program, service, treatment, placement or anything else we can think of. Then, like you said, you could run a report to find maxs, mins, counts and averages per client, per year, per month, per "Service Type" or anything else we are tracking. This feature is schedule for Live Release at the end of October 2009.
This would be a great place to list all of the services that Washtenaw (or anyone else) would like to track.
Things we are thinking about right now are:
Tether, Detention, Residential, any Service/Program.
In the future, you could even pull a gantt chart of a client. Maybe something like this (click each example to see what I am talking about):
http://www.simile-widgets.org/timeline/examples/index.html
Let me know how this sounds.
Thanks again for your feedback.
- Mark