Modelling subspecialties (and sub sub specialties)
31/08/2015by Rob Findlay
You can use Gooroo Planner to plan capacity at any level of detail, so long as you can get all the data at that level of detail too. That goes for subspecialties, and sub sub specialties, and even individual super-specialised consultants.
The tricky bit is usually the waiting list. If you can somehow split the waiting list up into the right subspecialties then you can usually model at that level of detail. And if you can’t, you can’t. This isn’t a limitation of Gooroo Planner, by the way; it would affect any model including an in-house spreadsheet.
Obviously, if every patient is tagged with an accurate subspecialty code (which is increasingly true in General Surgery as it splits into breast, colorectal, vascular…) then you have everything you need, but in most cases things aren’t so easy and you need to work out the subspecialty indirectly.
We have seen a few attempts to split specialties up into subspecialties using clinic codes, but none of them were particularly successful. The problem is that usually a few of the clinics are mixed bags – “Foot & Ankle and General” for instance, or even “Knee / Soft Tissue Knee / Hips / Foot & Ankle” – and you only need one or two of those and the whole classification scheme breaks down.
The most reliable method we have seen is to allocate patients to subspecialties based on their consultant. Get a list of every consultant in the specialty, assign each one to a subspecialty, and then use that lookup table to assign every patient to a subspecialty based on their consultant. The lookup table (for use in your SQL queries) might look something like this:
There are a few possible complications though.
a) Patients sometimes transfer from one consultant to another. However this isn’t usually a big problem, as they commonly transfer within the same subspecialty, and Gooroo Planner can easily cope if a few percent don’t.
b) Patients may not be assigned to a consultant until they are given their first outpatient appointment, which means that unbooked outpatients have no consultant. There may be some other way to estimate the subspecialty for unbooked outpatients, but if there isn’t then you may need to abandon the attempt to split outpatients by subspecialty. You should still be able to allocate elective patients to subspecialties though, as they are usually assigned reliably to a consultant.
c) Is it a subspecialty, or merely a special interest? For instance, if you have two hand surgeons, but one of them also does upper limb work, and your upper limb surgeons also do a bit of simple hand surgery, then “hands” isn’t really a subspecialty on its own and you can lump it into your flexible “upper limb” subspecialty. However if your hand surgeons (mostly) only do hands, and your upper limb surgeons (mostly) don’t, then you can call “hands” a subspecialty distinct from upper limb. It is common to define “mostly” as meaning at least 80% or 90%, and if in doubt it is better to lump potential subspecialties together rather than trying to force them apart.
d) You will need to keep track of consultants joining and leaving the service, and in particular you will need to assign a subspecialty to any previous consultants who left during the period covered by your past period data.
e) Sometimes you may find conflicts between basing subspecialties on consultants, but basing specialties on Treatment Function Codes. This can give rise to odd (and usually rare) situations, such as a patient having a specialty of orthopaedics but a subspecialty of colorectal surgery, because they were apparently treated by an general surgeon in an orthopaedic service for some reason. It is up to you how you deal with this, but you may want to assume that the specialty is correct and assign such patients to the “general” category.
Can you model at consultant level? It depends. Gooroo Planner works by measuring demand in the past, and then projecting that demand into the future (taking account of growth, extra demand, seasonality etc). So it is only sensible to model services which have a reasonably stable “catchment” of demand that can be projected forwards. Subspecialties have a reasonably stable catchment, and so do consultants who receive referrals and conduct their clinical practice independently of their peers. But if a consultant pools their work with peers, then they don’t have a “catchment” of demand in their own right, and it would not make sense to model their demand and capacity separately. (However there is nothing to stop you from analysing their personal waiting lists using the Gooroo simulator if you want to).
Once you have determined the right subspecialty for each patient, getting Gooroo Planner to actually model at that level is easy. Just pick an unused header (e.g. the consultant header HeadCons) and use it to define the subspecialty, in addition to using the specialty header (HeadSpec) to define the specialty. For any specialties that aren’t being broken down by subspecialty, just populate the subspecialty field with a copy of the specialty name (don’t leave it blank).
And all these considerations apply to other kinds of detail too, like hospital site, procedure, or commissioner. If you can split all the data up reliably at that level of detail, then you can model at that level of detail. And if you can’t, you can’t. And that applies to any model, not just Gooroo Planner; although if your data is a bit borderline then Gooroo Planner will probably cope better because it is designed to minimise the impact of inconsistent data (though there are limits).
During the initial “one-day” implementation of Gooroo Planner, we usually stick to specialty level, so that we can get everything loaded up from medical emergencies to surgical outpatients. But modelling at subspecialty is something that operational managers often ask for, so you may want to refine your modelling to allow for this fairly soon afterwards.
After you have refined your capacity plans to subspecialty or sub sub specialty level, it is usually sensible to keep the specialty-level modelling going too, as a separate analysis, because it tells you what could be achieved if resources were allocated flexibly between subspecialties.Return to Post Index