3 Replies Latest reply on Jun 27, 2017 10:14 AM by mark.welsh

    June 22 HUG Webinar - Metrics

    Nicole Lohr

      At the June 22 HUG webinar, someone asked for definitions for some metrics. 

      Charge lag: DATEDIFF('day', [Service Date From],[Posting Date])


      Established Patients

      Sum of chargeable CPT units from the following procedure codes:

      99211, Office/Outpatient Visit, Est Level 1, Est Pt Visit

      99212, Office/Outpatient Visit, Est Level 2, Est Pt Visit

      99213, Office/Outpatient Visit, Est Level 3, Est Pt Visit

      99214, Office/Outpatient Visit, Est Level 4, Est Pt Visit

      99215, Office/Outpatient Visit, Est Level 5, Est Pt Visit



      99241, Office Consultation; Prob Focused, Consult

      99242, Office Consultation; Expand Prob Focused, Consult

      99243, Office Consultation; Detailed, Consult

      99244, Office Consultation; Compreh; Mod Complex, Consult

      99245, Office Consultation; Compreh; High Complex, Consult


      New Patients

      A sum of Units where the Procedure Category equals Consult or NP

      New Patients Rate

      Sum of New Patients (includes Consult) / Sum of New Patients (includes Consult) plus Established Patients


      Total Units

      Sum of the total CPT charged units

      Excludes Categories: Capitation (CAPCK), Quality Incentive (Quality), Retail, PQRI


      No Show

      Appointment Status is equal to No Shows.

      No Show Rate

      Sum of Appointment Status is equal to No Shows / Sum of Appointment Status Acknowledged, Cancelled and No Shows.

      Excludes: Tracking category




      Appointment Status is equal to Cancellation.

      Cancellation Rate

      Cancelled Appointments / Sum of Appointment Statuses where Acknowledged, Cancelled or No Shows.

        • 1. Re: June 22 HUG Webinar - Metrics

          Thanks Nicole!  It's awesome that you've provided this information for all of us.


          I do have a question on your patient census data if you find the time to answer.  Our database does not store historical patient census information, so if I want to look back at a date three months ago and identify how many patients were in the ED, I need to calculate all patients who arrived on or before that date and were discharged after (for the sake of simplicity). 


          Since the opportunity has presented itself to see how another healthcare system is calculating census I wanted to ask if you are using a similar method, or if you do something different. 


          Thanks again for the presentation and follow up.

          • 2. Re: June 22 HUG Webinar - Metrics
            Nicole Lohr


            Our live database doesn't store the census history data in the way that we are collecting it.  The system has admit and discharge dates, but not summary counts every thirty minutes as presented in the dashboard.  We are collecting this information through a query we run. We have the ability to run a query every thirty minutes and with an ETL process store that data into a database that we have security rights to write to.  Essentially we are creating our own historical table.

            • 3. Re: June 22 HUG Webinar - Metrics

              Awesome, thanks Nicole.