1 / 38

IDS Training Session – Utilization Rates

IDS Training Session – Utilization Rates. Webinar Features. To ask a question, first click the orange arrow button to enlarge the menu Once the menu is enlarged, type in the box to ask a question To make the presentation full screen, press the middle blue button. Utilization Rates- Intro.

neorah
Download Presentation

IDS Training Session – Utilization Rates

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IDS Training Session – Utilization Rates

  2. Webinar Features • To ask a question, first click the orange arrow button to enlarge the menu • Once the menu is enlarged, type in the box to ask a question • To make the presentation full screen, press the • middle blue button

  3. Utilization Rates- Intro These reports can help in the process of planning for new service lines or equipment; should not be the only source, however, for making decisions Can also be used to plan for physician recruitment; again should not be the only source of data for making decisions

  4. Goals • Understanding Future Utilization • Using Physician Office Visit reports • Using ER Visit reports • Understanding the Physician Supply / Need reports

  5. Caveats Most of these reports use national or state averages – may not apply with your local area totally Other research would be needed to make decisions regarding the subject matter of these reports – don’t consider them the one source for planning

  6. Caveats • Data is age / sex adjusted only – other factors to consider: • Examples: • Race • Insurance Coverage • Socio-economic factors • Managed care penetration

  7. Caveats • Does not account for technology or procedure changes • Example: new equipment changes the way a patient receives treatment • Example: new procedure changes how a patient uses your hospital

  8. Understanding Data Sources The source for most data is National Ambulatory Medical Care Survey (NAMCS) which is published by the National Center for Health Statistics http://www.cdc.gov/nchs/products/ad.htm Updated annually

  9. Understanding Data Sources • Population data is purchased from Claritas, Inc. • Updated yearly from the base census year with projections based on magazine subscriptions, surveys, etc. • Provides projections for future years

  10. Future Utilization Report • This report projects future utilization by MHA Service Code • MHA Service Codes are service lines defined by MHA based on MS-DRG • It is possible to change it to report on another field • Calculates current use rates by age and sex • Applies use rates to the population projections (from Claritas) to determine future utilization

  11. Future Utilization Report As mentioned before, the report adjusts for population changes by age and sex only but does not account for changes in medical technology or other factors influencing hospital usage It may tend to overestimate future utilization

  12. Future Utilization – Tab 1 One time period report – does not have to be limited to one quarter, or year, however Choose patient type – inpatient or outpatient If saving as a custom report, input name and description of report

  13. Future Utilization – Tab 2 • Choose field to report on • This can be a case (drg, procedure, diagnosis) or geographic (zip code, county) field • It is also possible to report on UDFs here • Custom service line • Custom service areas

  14. Future Utilization – Tab 3 • Choose case filter • MS-DRG, PX, DX, or UDF based on a case field • Choose geographic filter • County, Zip code, or UDF based on a geographic field • Choose sex and age category filter • Male or Female • Age Categories are defined in IDS

  15. Future Utilization – Tab 4 Standard IDS output screen – it shows all of the validation information on the right side Choose Export type then Run an Individual Report

  16. Future Utilization - Sample *Demo Data

  17. Mapped Data *Demo Data

  18. Physician Office Visits by Age / Sex The National Center for Health Statistics (NCHS) publishes nationaluse rates by age and sex for physician office visits The use rates are based on the National Ambulatory Medical Care Survey (NAMCS) The NAMCS study includes visits to non-federally employed physicians, excluding specialties of anesthesiology, radiology and pathology

  19. Physician Office Visits by Age / Sex The rates are merged with the population data from Claritas, Inc. to create estimates for the current year and projections for future years The data are adjusted for age and sex only! Many other factors may influence use rates including race, insurance coverage, socio-economic factors, managed care penetration, etc.

  20. PO Visits by Age / Sex Tabs • On Tab 1, select the year (one year only) • On Tab 2, select the geographic field to report on – zip code, county code, or district council (regions of Michigan) • UDF option not available • Select how the data will be sorted

  21. PO Visits By Age / Sex Tabs • On Tab 3, select the geographic filter and the Sex / Age Categories similar to previous report • Two tabs within the tab, Geographic and Sex / Age Categories • UDFs can be used in filter statement for geographic filter • On Tab 4, select output settings, save as a custom report if necessary

  22. PO Visits by Age / Sex Example *Demo Data

  23. Physician Office Visits by Specialty The National Center for Health Statistics publishes distribution rates for physician office visits by specialty The rates are derived from the National Ambulatory Medical Care Survey (NAMCS) Report by Specialty

  24. Physician Office Visits by Specialty The number of visits by specialty is calculated by first estimating the number of visits for a geography by age and sex and then applying the appropriate percentage for each specialty This report should be used with caution. Distributions in any given geography may be influenced by many factors including availability of specialists, socio-economic factors, insurance coverage, etc.

  25. PO Visits by Specialty Tabs • On Tab 1, select the year (one year only) • On Tab 2, select the geographic field to report on – zip code, county code, or district council (regions of Michigan) • UDF option not available • Select how the data will be sorted

  26. PO Visits by Specialty Tabs • On Tab 3, select the geographic filter and the Specialties • Two tabs within the tab, Geographic and Specialties • UDFs can be used in filter statement for geographic filter • On Tab 4, select output settings, save as a custom report if necessary

  27. Sample Report *Demo Data

  28. ER Visits Report The National Center for Health Statistics (NCHS) publishes use rates by age and sex for emergency department visits to non-Federal, short stay and general hospitals The use rates are merged with the population data from Claritas to create estimates for the current year and a five-year projection

  29. ER Visits Tabs • On Tab 1, select the year (one year only) • On Tab 2, select the geographic field to report on – zip code, county code, or district council (regions of Michigan) • UDF option not available • Select how the data will be sorted

  30. ER Visits Tabs • On Tab 3, select the geographic filter and the sex and age categories necessary • Two tabs within the tab, Geographic and sex and age categories • UDFs can be used in filter statement for geographic filter • On Tab 4, select output settings, save as a custom report if necessary

  31. ER Visits Sample *Demo Data

  32. Physician Supply / Need by Geography • Report shows Physician Requirement for the given area • Physician Requirement is then used to calculate the Physician Need • Physician Requirement is based on use rates in the comparison geography • State of Michigan is the default comparison geography • Ability to compare your region to other regions

  33. Supply / Need Tabs • On Tab 1, select the year (one year only) • On Tab 2, select the geographic field to report on – zip code, county code, or district council (regions of Michigan) • UDFs are permitted • Select how the data will be sorted

  34. Supply / Need Tabs • On Tab 3, select the geographic filter and the case filter if necessary • Only case filters related to specialty, age, or physician type available • UDFs can be used in filter statement for geographic filter • Then select comparison geographic area – this will be the area compared to your geographic filter statement

  35. Supply / Need Tabs On Tab 4, select the output options Choose to save as a custom report if necessary “By Specialty” report is similar except it reports on specialty types, not geographic fields

  36. Sample Report – By Geography • Report compares Ingham county to the state of Michigan Comparative Region is the state of Michigan *Demo Data

  37. Sample Report – By Specialty County compared to Michigan *Demo Data

  38. Questions? Michael Ovsenik Client Representative Chris Leong Client Representative IDS Client Support idssupport@mha.org 517-886-8448 or 877-999-4653 Http://www.theidsonline.com

More Related