[PDF]HFMA Data Mining for Revenue Cycle Gold! - Rackcdn.comhttps://02f0a56ef46d93f03c90-22ac5f107621879d5667e0d7ed595bdb.ssl.cf2.rackcd...
1 downloads
170 Views
6MB Size
May 2019
HFMA Data Mining for Revenue Cycle Gold!
Presented by:
Philip Roudabush UIHC AVP, Revenue Cycle Management
UIHC
The University of Iowa Hospitals and Clinics
Iowa’s Only Comprehensive Academic Medical Center
• 3 Hospitals (UIHC, Children’s, Psychiatric) – – – –
811 beds Inpatient Admissions 46,325 Emergency Department 66,732 Outpatient Claims Billed 865,882
• 300 Clinics – UI Clinic Visits 762,463 – Outreach and UI Community Medical Services Visits 173,277
• 11,837 Staff – Nurses 1,972 – Physicians and Dentists 1,653
2
3
UIHC Data in this Presentation… The data/numbers which you will be viewing are fanciful, perplexing, horrific… and possibly pithy. They are also wholly fake and filtered such to the point that they will have whimsical meaning to the topics and screen shots I am discussing.
The Revenue Cycle - PFS Analytics
4
The Revenue Cycle and the Importance of Data and Reporting
Key Metrics and Actionable Data “In regards to reporting on the revenue cycle for any large hospital setting, the best method is full transparency.
4
5
Epic Reporting!
6
Tableau Reporting!
Patient Financial Services (PFS)– Tableau
7
Epic and Tableau Integration
Epic (Chronicles)
Epic Clarity (SQL Server)
Microsoft SQL Server Management Studio
Tableau Desktop
Tableau Server
Epic Clarity SQL Server is refreshed with current data on Monday, Tuesday, and Thursday
PFS Analytics writes SQL based statements in Microsoft SQL Server Mgmt Studio PFS Analytics adds the custom SQL statements into Tableau Desktop Once data is sourced into Tableau Desktop the creative visualization process begins Completed dashboards are published to Tableau Server End users are then able to access and interact with the published dashboards
Phil’s Data Gold Mine
8
9
Answering Revenue Cycle Questions?
Tableau Report – Denials Example
Payor
10
Denial Category
Provider
Filters Plan
Denial by Remit Code
Trending
CPT Code
Possible Filters/Parameters Department Grouper: Professional billing grouper used to isolate distinct areas of business for reporting purposes Example: Community Clinics, Student Health, etc.
Post/Service Period: Allows users to view data summarized by post day or service date CBU (Combined Business Unit) Category: Revenue allocation grouper by physical location site Example: IRL CBU category is comprised of IRL Anesthesia, IRL Dermatology, IRL Diabetes Center, IRL Family Practice, etc. financial divisions
CBU (Combined Business Unit) Name: Revenue allocation grouper by specialty discipline across multiple physical locations Example: Otolaryngology CBU is comprised of IRL Otolaryngology and Otolaryngology financial divisions
11
Possible Filters/Parameters Financial Division: Professional billing revenue allocation grouper by specialty discipline and physical location, comprised of one or more financial subdivisions Example: Otolaryngology financial division is comprised of OTO General and Rhinology, OTO Head and Neck, OTO Otology/Neurotology, OTO Speech & Hearing, etc. financial divisions
Financial Subdivision: Professional billing revenue allocation grouper by specialty and physical location, comprised of one or more bill areas Example: OTO Speech & Hearing financial subdivision is comprised of OTO Hearing Aid Center and OTO Audiology OP Clinic bill areas
Bill Area: Professional billing revenue allocation grouper by subspecialty and physical location Example: OTO Hearing Aid Center bill area
Billing Provider: Supervising provider on the service Service Provider: Performing provider on the service
12
Possible Filters/Parameters Account Type: Guarantor account type used to identify specific visit classifications Example: Personal/Family, Behavioral Health, Cosmetic, etc. Account Base Class (HAR): Hospital account class derived from the patient class which determines level of care as inpatient, outpatient or emergency Account Class (HAR): Hospital account class derived from the patient class Example: Observation, Newborn, etc. Charge Cd/Name: Allows users to view matched transactions, outstanding AR amounts and payor mix for selected charge codes Financial Class: Grouping of similar payors and benefit plans Example: Commercial, Medicaid, Medicare, Self Pay, etc. Payor Name/ID: The organization to which claims are sent and from which remittance is received Example: Cigna, Medicaid of Iowa, United Healthcare, etc.
13
The Revenue Cycle - PFS Analytics
Revenue Cycle KPI’s
14
The Revenue Cycle - PFS Analytics
15
Revenue Cycle Review (RCR) - Tableau
Core Metrics Templated Automated
Simple Actionable
RCR mantra The RCR is not designed to answer every question, rather, it should spawn questions and conversational topics while identifying areas of interest and potential development
15
RCR – KPI’s
16
Choose FY or FYTD trending
— 17 —
RCR – Charge Dash
Total and trended charges by department, specialty, physician, payor, plan, CPT code
18
RCR – Adjustments/Payment Dash
Total and trended adjustments/payments by department, specialty, physician, payor, plan, CPT code Focus on controllable adjustments and/or payments for improvement
19
RCR-Denial Rates
Denials – First Pass Review
20
Charge Mix Rank versus Denial Mix Rank
21
The Revenue Cycle - PFS Analytics
Evaluation and Management Bell Curves
22
— 23 —
The Revenue Cycle - PFS Analytics
Account Receivables
24
Accounts Receivable
Let’s Talk A/R Classic Department Chair Question • My total A/R for last month was $6 million. • This month it is at $9 million! It rose by $3 million!
25
Account Receivables
26
Aged A/R
+ $3 million
+ $3 million
Account Receivables
27
Trended Good and Bad A/R A Desirable Divergence
“Good A/R” 0-60 A/R $
“Bad A/R” > 90
Time
A/R – How to Know Aging and Trending?
— 28 —
— 29 —
The Revenue Cycle – Overview
30
Anatomy of Gross Account Receivables (A/R)
Service Provided
Charge Lag
Charge Entered
Claim Edits
Unbilled A/R
Gross A/R
Physician RVU Generated
Claim Dropped
Billed A/R
Claim Adjudication
30
The Revenue Cycle - PFS Analytics
Payor Mix
31
Payor Mix
Important profit indicator? Can be controlled! – Advertising – Referrals – Word of mouth – Etc..
A change in payor mix does not mean that you are seeing less patients in any payor category.
32
Payor Mix Cash Impact Analysis
— 33 —
The Revenue Cycle - PFS Analytics
Collection Rates
34
Collection Rates - Phil’s Phavorite!!!!!!
P a y o r
P l a n
B i l l i n g
D o c t o r
C P T
C o d e
— 35 —
The Revenue Cycle - PFS Analytics
Reporting Need – Case Example Hospital Late Charges
36
Charge Lag Understanding Late Charges
Charge Lag – Days between service date/discharge and the date the charges post (Hospital & Professional)
Charge Lag — 37 —
Professional Charge Lag
— 38 —
Professional Charge Lag
Service Date
Post Date
39
Hospital Late Charges Understanding Late Charges
Charges are “late” when they: 1. Drop after min days • ED/IP charges: Holds for 3 days • OP Charges: Holds for 7 days
2. Drop after a claim/HAR is in billed status Original Hospital Claim Inpatient Eligible to Drop Day After Hold Date of Service / Discharge Date
2nd Hospital Claim
Outpatient Eligible to Drop Day After Hold
ED/Inpatient Late Charges Outpatient Late Charges Problem Late Charges — 40 —
The Revenue Cycle – Claim Submission
41
All 3 Physician claims created before: Hosp Min Days Hold Hospital Pre Billed Outpatient: 7 days Hospital Claim
Physician Claim
Physician Claim
Physician Claim
The Revenue Cycle – Claim Submission
42
2 Physician Claims Drop before Replacement Hosp minClaim days Hold Hospital Pre Billed Payment or Denial Received Hospital Claim Hospital
Replacement Claim
Physician Claim
Physician Claim
Physician Claim
The Revenue Cycle – Claim Submission
Why are late charges a problem? • Late charge claims cause unnecessary extra work – Potential change in primary payment - rework – Potential change in secondary payment - rework – Potential change in patient liability – rework – Credit work – Potential payer recoups – Statement cost to mail multiple statements
• Patient Receives Multiple EOB’s and UIHC Statements – Confusing to patient to receive multiple EOB for same service – Patients do not like to have to pay multiple times for the same service • Timely filing ugliness!
43
Hospital Late Charges
44
Hospital Late Charges Created From Practitioner Charge Lag
Which departments and practitioners are creating late charges due to documentation occurring past hospital min days
45
The Revenue Cycle - PFS Analytics
Under Construction Cost to Collect
46
47
Healthy Revenue Cycle - Cost to Collect Measures Expense against Revenue
Revenue – Expense -
Easy-peasy Tricky
Benchmarking expense definition can be complicated and can include: Activities/Departments
– Vendors, Systems, Scheduling, Registration, Check-in & Check-out, Admissions, Prior Authorizations, Coding, Payment Posting, Claims Management, Denials Management, Customer Service, Patient Billing, etc… To build – Allow for filters of above – Allow for percentage dialer of above
TREND!
Many, many more
Dashboard for… • various audiences (Executive, Supervisor, Staff, etc…) • • • • • • • • •
staff productivity and workqueues referral payor mix procedure mix (trending on procedure usage…) net collection rates (variability in formulas) Medicaid MCO specific data Self Pay vendor management payor report cards daily, monthly, yearly cash tracking
48
The Revenue Cycle - PFS Analytics
49
Data Success
49
The Revenue Cycle - PFS Analytics
50
Lessons of Reporting Successes • Communicate with your customers • Present meaningful and actionable data • Keep the reporting simple • Allow ad hoc reporting • Do NOT try to get it “right the first time”… evolve!
• Great reports drive great results!
50
The Revenue Cycle - PFS Analytics
51
Data Failure
51
The Revenue Cycle - PFS Analytics
52
Lessons of Reporting from Failures • Good data, which may be actionable, can be abandoned if not backed by unified “administrative will” • Accept that some data is just good data and not, necessarily actionable • The executive belief of “more data = better decisions” can be debilitating • Don’t get cute! Produce data which “answers the question”
52
Phil’s Most Favoritist Meme!!
What we suspect payors are doing!
53
Mining for Data Gold
— 54 —