How we can help you

Over the past decade, 3terra consultants have created numerous analytical solutions based on inpatient (DAD) and outpatient (NACRS) coded data. We help hospitals track performance and outcome indicators as well as key operational metrics across entire hospitals. Our solutions enable advanced patient population analysis to help measure and improve patient care.

We work with both vendor abstracting systems (MED2020, 3M) as well as the CIHI coded submission files. We also have considerable experience implementing standardized provincial indicators.

Understanding how patients move within a hospital is critical for predicting bottlenecks and improving patient flow. Managers need the ability to anticipate and react quickly to capacity issues and understand where recurring problems arise.

We have helped organizations use their ADT and ED data to understand how individual patients and entire populations interact with hospitals, programs, and individual units for both historical and near real-time analysis.

Many valuable operational and quality improvement metrics can be created using hospital payroll data including nursing utilization, overtime, sick rate, agency usage, and employee turnover.

Our successful projects include advanced analytical tools that assist with budgeting, forecasting, efficiency/variation analysis, and even reconciliation against entries to the general ledger.

Statistical and financial information within the general ledger is consistently among the highest priority financial data for hospitals to analyze. Hospitals often need more robust reporting and self-serve capabilities than what their standard financial reports provide.

We have developed numerous G/L solutions that reconcile against clinical systems, enable departmental analysis, highlight deviations from budget/forecast and provide the ability to drill down to transaction level detail.

Managing ED wait times is of critical importance to hospitals. We provide insight into ED time-of-day volumes, ED admit wait times, revisits, assessment wait times, and patients that leave without being seen.

In addition to using coded abstract data (NACRS), we have also developed near real-time ED data marts to power live operational dashboards and reports.

MIS Trial balance files that are submitted as part of the Ontario Healthcare Reporting Standards (OHRS) contain invaluable insight into financial and statistical performance for healthcare organizations.

We have used this data to provide hospitals with performance tools, benchmark reporting, and functional centre efficiency analysis. We also create indicators that allow hospitals to quickly determine how well they perform relative to hospitals that provide similar services.

Maximizing Operating Room efficiency requires a thorough understanding of performance indicators, both from a process and financial perspective. Delays in patient service, increased procedure costs and scheduling inefficiencies all impact O/R performance.

We connect to O/R systems within hospitals, such as SIS and PICIS, to enable analysis of key metrics such as start time compliance, room utilization and surgical time durations, from prep through post-operative care. Combining this information with other systems, such as case costing and scheduling, can provide a comprehensive view of O/R costs and workloads.

Using the National Rehabilitation Reporting System (NRS) we have provided hospitals calculated FIM scores before and after discharge, breakdowns of outcomes by Rehab Patient Group (RCG), service interruptions, and FIM improvement efficiency.

Linking from rehabilitation to other data sources, such as ED visits and inpatient stays can identify treatment patterns and areas for efficiency gains.

Mental Health data is very detailed and the algorithms used to calculate outcomes are complex. We've used coded records from Ontario Mental Health Record System (OMHRS) to present assessment outcomes, calculate SCIPP groupings with CMI scores and identify length of stay efficiency. We have also used Mental Health data to provide analysis on readmissions, and linkages to acute and outpatient events to identify treatment patterns for regular and short stay visits.