CaseMaker PCS Financial Analysis Tool Enclosed: CaseMaker PCS Information Sheet CaseMaker PCS Required Data Elements CaseMaker PCS Sample Reports
CaseMaker PCS©™ Simplified, robust financial analysis for hospital Palliative Care Services Making the case to sustain and grow your hospital PCS demands that you demonstrate operational, clinical, satisfaction and financial outcomes. While most PCSs can collect and analyze their own operation, clinical and satisfaction outcomes, calculating financial impact of your PCS is labor intensive, complicated, and requires expertise in financial analysis--until now. CaseMaker PCS©™ provides a robust, automated, and easy-to-use to use Webbased tool for calculating and reporting financial outcomes of your PCS. All it takes are 20 data elements that your hospital finance department can easily provide, combined with data about which patients the PCS cared for and when. Simply upload the information to the CaseMaker PCS©™ Website, and within minutes you will receive a detailed, customizable financial report to help you make the case for sustaining and growing your PCS.
CaseMaker PCS©™ provides: • Easy-to-use Web-based tool • Robust, research-level analytics • Streamlined, automated, and customizable reports • Expert technical assistance • 24/7 access to analysis and reports
For information, please contact: Steve Pantilat:
[email protected] Ashley Bragg:
[email protected]
The CaseMaker©™: Summary of Required Data You need surprisingly few data elements to conduct this analysis (just 21 unique elements). The three tables below summarize the data elements necessary for this analysis. Hospital administration should be able to provide you with Admission Level Data and Daily Cost Data. You will need to specify the time period for the analysis- we recommend a year to ensure that there are sufficient numbers of patients to analyze (Note: there is typically a 3-month delay in when financial data are complete and available for analysis). Palliative Care Service Data will come directly from the PCS database or wherever the PCS keeps track of which patients were seen and on which day the initial consult happened. Admission Level Data
These data describe an entire admission
1) Medical record number
A unique identifier for the patient
2) Admission/visit number
A unique identifier for that hospital stay
3) Financial class
Medicare, Medicaid, uncompensated care, etc
4) Hospital admission date
Calendar Date
5) Hospital discharge date
Calendar Date
6) LOS (days)
Length of stay as calculated by your hospital
7) # Critical care days 8) Discharge disposition 9) Principal Diagnosis Code 10) APR-DRG 11) APR-DRG SOI score 12) APR-DRG ROM score 13) Variable direct costs 14) Direct costs 15) Total costs 16) Net revenue
Number of ICU days as calculated by your hospital Home with homecare, hospice, death, etc. ICD-9 code indicating the principal reason for the admission All Patient Related Disease Related group SOI = severity of illness; for use in constructing comparison groups ROM = risk of mortality; for use in constructing comparison groups For the entire admission For the entire admission For the entire admission Net revenue is best, but expected revenue is an Ok substitute
Daily Cost Data 2) Admission/visit number 17) Date 18) Variable direct costs 19) Direct costs
These data describe daily costs within an admission You need this so you can match daily data to admission level data The calendar date Variable Direct Cost for this calendar date Direct Cost for this calendar date
Palliative Care Service Data 2) Admission/visit number 20) Date initial PCS consultation 21) PCS Sign off Date
©
These data describe which patients were seen by the PCS and when You need this so you can match and merge PCS data with administrative/cost data You need this so you can differentiate pre-PCS and post-PCS days Include if patient was not followed by PCS through the day of discharge
2012 UCSF Palliative Care Program and UC Regents