Current Census Question

An entry on my Linked-In "Meditech Data Repository Group" page (Meditech Data Repository uses in Clinical Settings using SSRS) concerning census led me to post a query there that didn't really answer the question.  The user wanted to get a real-time census of her hospital.  She was starting her search in the AdmNursingCensus table.  I took it and ran!  Big mistake –I didn't read what she really wanted to get out of the DR – the current census.  The AdmNursingCensus table is used to capture data at day's end.  That is, it will tell you who was on what unit at midnight.  It doesn't even post any data until the day is over. 

So if you're trying to find out who's on the floor as of 2:37 this afternoon, you're outta luck if you're looking in the AdmNursingCensus table.  It can tell you who was on the floor at midnight  last night (or any other night for that matter), but not who's there right now.  It is great for trending populations shifts over weeks, months and years even, but not for who's here now.  

So, to see who's where, right now, I turn to the AdmVisists table.  It is updated as a patient's status changes.  If they've been moved to another floor, it updates.  If they've been discharged, it updates.  If their accomodations changes, it updates etc.  Here is the query I use to capture current census:

 

/****** Script for Current Census ******/

SELECT [AccountNumber] ,

[Name] ,

[BedID] ,

[RoomID] ,

[RoomLocation] ,

[FacilityID] ,

[FacilityName] ,

[FinancialClassID] ,

[InpatientServiceID] ,

[LocationID] ,

[LocationName] ,

[ObservationPatient] ,

[ObservationDateTime] ,

[RoomID] ,

[RoomLocation] ,

[RoomLocationGlDept] ,

[RoomLocationName] ,

[RoomRateAccommodation] ,

[Sex] ,

[Status] ,

[UnitNumber] ,

[VisitorsAllowed]

FROM [livedb].[dbo].[AdmVisits]

WHERE
Status
=
'ADM IN'

Question about current census...

A question arose on how to find the current census of your facility.  The simplest way I found (and it is confirmed my running the Meditech Standard Census report), is below:

DR and Virtualization

Hey, anybody out the virtualized their DR yet? I'm about to – on Wednesday next. The 13^th of October, that is. I was wondering if there's been any 'glitches' I might need to look out for. Some of the answers I got when I first posed the question a few months ago had me a little worried. It's a straightforward move, turn off the data transfers, start the mirroring/migration process, verify databases are intact, turn on the data transfers. Simple, eh? Maybe a little bit of re-IP'ing and re-naming of the servers, but not too bad.

At least that's what the plan is…nothing ever goes wrong when we deal with upgrades, moves or implementations, now do they? I'll update as soon as I get a chance after it's done. But for right now, anybody got any words of encouragement?

Welome to PMacD and the DR

Just thought I would begin to write down some of my thoughts, ideas and plans for my life, my career and my family.  There's little time for me to give back everything that I've learned, everything I've soaked up and everything I've discovered on my own.  

While I've been on this beautiful planet for more than two score and ten, I've only recently (the last ten or so) begun to learn about life and how to truly enjoy it.  There's been such a transition and metamorphosis in my life, I don't know where to begin.

But I have to first explain  the blog's name: PMacD is me, naturally, and the "DR" is the data repository.  Which data repository you may ask - well, it's the SQL Server database that is populated with vast amounts of data supplied by a Meditech hospital information system (HIS). Now don't get your pants in a tizzy, there will be no patient information posted (Why, I do believe that's against some sort of HIPAA rule.)  I will merely be trying to collect my thoughts, my work and my accomplishments somewhere - somewhere I can find them.  (Hopefully I'll remember to bookmark this page) 

Oh, and it's not just about me...I want to here from folks out there.  I want input, questions, shrieks of horror at what I may suggest to do with the databases we have been so foolishly entrusted to maintain. 

Enough for now...I'll post again soon with perhaps something a little worthwhile for you to use....