This dashboard will show some data reflecting the overall status of our department.


The graph below is derived from data from the monthly "Provider Open Panel" report. The total number of patients assigned to all DFM providers is added to produce the graph in blue. That graph is then divided by the total weekly hours worked in clinic (not including residents), and then adjusted to the mythical person working 32 hours in clinic, to get the "Adjusted panel size" in red. I am uncertain whether some change in an "assigned patient" due to system-wide changes associated with ccLink in July explain why the # of assigned patients supposedly went up, even in a healthier economy.

Assigned_patients_and_adjusted_panel_size.gif



The graph in red below is also derived from the "Provider Open Panel" report and includes the hours work by residents. The blue graph is derived from a Cadence report, available on iSite, that shows the number of kept visits (i.e. no shows are ignored) in family medicine clinic. This includes short notice clinics and a number of other clinics that are staffed by DFM members, such as language clinics, group prenatal and diabetes clinics, etc. These are 3-month visit totals.

Visits_and_FMC_Hours.gif



The graph below shows the percent turnover among providers doing family medicine clinic, i.e. a turnover of 10% would mean that 1 in 10 of our members left in a given year. This includes people who left our system entirely or people who dropped family medicine clinic while still doing other work in our system. The data was "smoothed" by averaging over 2 year periods (otherwise some of the "noise" obscures trends). This data is derived from analysis of "Provider Open Panel" reports through 2002 (the earliest data I have). The data for 2013 is extrapolated based on data through the July 2013: I assume that the turnover for the first 7 months of the year will continue. Residents are NOT included (they are included if they signed on as an attending but then later left).

Obviously, in the last few years, we have been able to grow our current staff only by interviewing and recruiting vigorously to keep up with high turnover.

Yearly_turnover.gif

The graph below shows the number of patients been *seen* (not scheduled) per hour, on average, in family medicine clinics across our system.

Visits_per_Hour.gif


x.gif"imaje/x.gif"

This page has been edited 17 times. The last modification was made by - tairoe tairoe on Nov 7, 2013 1:36 pm