Get Full Government Meeting Transcripts, Videos, & Alerts Forever!
Get email alerts on the Open Data Portal topic
No spam. Unsubscribe anytime.
HCAI demonstrates open data portal: hospital finances, uncompensated care and labor metrics available
Summary
HCAI demonstrated new and existing hospital finance visualizations and downloadable pivot/profile tables covering assets, uncompensated care, operating margin, payer profitability, utilization and workforce productive hours, and indicated audited data lags for some public visualizations.
Ty Christensen of HCAIs data team demonstrated the departments hospital financial data products and interactive visualizations, which include audited-year trend graphics and downloadable pivot/profile Excel data for more current single-year analysis.
Christensen showed that the portal can present statewide totals or filtered slices (by county, facility, ownership type and other peer-groupings). Visualizations include balance-sheet categories, uncompensated care (bad debt, charity and county indigent), revenues and expenses, operating margin trends, cost-to-charge ratios, and utilization measures (licensed beds, discharges, patient days and outpatient visits).
The portal also contains a labor-productivity suite that reports productive hours by staff classification, productive full-time-equivalent calculations and FTE per occupied bed. Christensen demonstrated payer-level profitability calculations standardized per adjusted discharge, and showed how the pivot profile Excel file can be used to assemble a site-level financial profile for internal comparison and planning.
Christensen noted some products use audited data and therefore lag one year; other sets (the pivot/profile single-year extracts) provide more current snapshots. He encouraged hospitals to use the published report forms alongside the data tools for context and to request technical assistance when needed.
