Broward Regional Health Planning Council HEALTH DATA WAREHOUSE June 18, 2009

1. Broward Regional Health Planning CouncilHEALTH DATA WAREHOUSEJune 18, 2009 Mike De Lucca, President/CEO mdelucca@brhpc.org Michele Rosiere, Division Director mrosiere@brhpc.org www.BRHPC.org 954.561.9681

2. HEALTH DATA WAREHOUSE MILESTONES Broward Regional Health Planning Council

3. BRHPC HEALTH DATA WAREHOUSE • Collaborated with Local Health Planning Councils Representing Florida’s 67 Counties • Developed web-based statewide infrastructure: • To identify, prioritize and address community health issues • Identify potential quality concerns • Identify areas needing further study & investigation • Track changes over time • Facilitate decision making by federal, state and local policy makers; healthcare leaders; clinicians; etc. • Maximizes existing resources Broward Regional Health Planning Council

4. BRHPC HEALTH DATA WAREHOUSE Broward Regional Health Planning Council

5. SIGNING UP FOR THE HEALTH DATA WAREHOUSE 1) Go to www.brhpc.org 2) Click on the “>>Please click here to login” link in the Health Data Warehouse Website Login section. Broward Regional Health Planning Council

6. SIGNING UP FOR THE HEALTH DATA WAREHOUSE 3) Click on REGISTER to create a new user account. Broward Regional Health Planning Council

7. SIGNING UP FOR THE HEALTH DATA WAREHOUSE 4) Please enter at least your email address and a password in the boxes below and then click the register button to create your new account. Broward Regional Health Planning Council

8. SIGNING UP FOR THE HEALTH DATA WAREHOUSE Once you have complete the registration process you will be directed to the main Health Data Warehouse page. Broward Regional Health Planning Council

9. PQI CATEGORIES Broward Regional Health Planning Council

10. CHRONIC CONDITION INPATIENT UTILIZATION Chronic Conditions last 12 months or longer and • places limitations on self-care, independent living & social interactions; and/or (b) results in need for ongoing intervention with medical products, services and special equipment. Chronic condition identification utilizes • all five-digit ICD-9-CM diagnosis codes, • excludes external cause of injury codes (E codes). Broward Regional Health Planning Council

11. SUICIDE SURVEILLANCE SELF INFLICTED INJURY E-CODES Broward Regional Health Planning Council

12. EMERGENCY DEPARTMENT ACUITY (CPT) STRATIFICATION Broward Regional Health Planning Council

13. EMERGENCY DEPARTMENT AMBULATORYNYU ALGORITHM EMERGENCY VS. AVOIDABLE Broward Regional Health Planning Council

14. USING THE PREVENTION QUALITY INDICATORS (PQI) MODULE TO PRODUCE A REPORT Report 1: Using the (PQI) module to produce a report for: All Counties, Year = 2007, All Quarters, With Charge Information, Showing the Observed Rates, Stratified by Hospital/Gender, Using the standard exclusion of cases where Patient County does not equal Hospital County. Select “All of Florida”, 2007 and All Quarters selections. Broward Regional Health Planning Council

15. REPORT CRITERIA SELECTION Fig2: (1) Select “Yes” for “Show Charge information”, “Show Rates” and “Same Patient & Hospital County”. (2) Then select the stratifers Hospital and Gender. (Notice, that when we select “Hospital” as one the stratifiers a popup box is displayed explaining why the Denominator/Rates cannot be displayed for all PQIs except PQI-2 and PQI-9). (3) click on the “Generate Report” button. Broward Regional Health Planning Council

16. GENERATE REPORT Broward Regional Health Planning Council

17. SAMPLE PQI QUERY RESULT #1 Fig5: The report has finished downloading and is displayed. (1) At the very top you will notice the definition of our report (2007, All of Florida, All Qtrs and the stratifiers) (2) Near the top in the middle there is a link to the help/tutorial. Clicking on “For Help click here” displayed a popup window with the tutorial. (3) Near the top right is where you can export the report. You can export to CSV/Excel and PDF formats. For PDF formats there are 3 different page size/orientation choices (Please choose based on the width of the report) (4) Notice that for PQI-1 there are no Denominators or Obs.Rate as explained on Fig2 above. Broward Regional Health Planning Council

18. SAMPLE PQI QUERY RESULT #2 Fig6: This is the same report as in Fig5 above demonstrating that for PQI-2 there are Denominators and Obs.Rates. As an example, we take “Morton Plant North Bay Hospital” and see that for 2007 there were 10 (Numerator) cases of perforated appendicitis out of 42 (Denominator) cases of appendicitis fitting the AHRQPQI-1 definition. Broward Regional Health Planning Council

19. EXCLUSIONS Broward Regional Health Planning Council

20. MODULE DATA SOURCES Acuity Stratification, Avoidable - NYUAlgorithm Source - Florida AHCA Emergency Department (ED) Patient Data Prevention Quality Indicators, Chronic Conditions, Suicide Incidence - Source: Florida AHCA Inpatient Discharge Data Note: For all Modules, cases with different Patient Counties and Hospital Counties are now included. It is up to the user, when running reports on the website, to decide whether to exclude these cases. Broward Regional Health Planning Council