Service Line Margin Analysis report

This report provides the ability to evaluate performance across service lines by Inpatient, Outpatient or Combined. It is a report that provides an Inpatient, Outpatient or Combined View and also has totals and per case values. Expenses are classified as Variable or Fiexed, which allows you to evaluate the contribution margin by service line. Encounters can be selected by Admit or Discharge date and Net Revenue can be determined based on Actual or Estimated.

This report also provides an option to Limit the Encounters to specific patients based on other tables, e.g., certain procedures in the ENC_CPT or ENC_Proc tables, or for selected physicians in the ENC_Provider table.

Refresh Variables

The following table describes the variables you can configure for this report:

Option Description
Admit or Discharge Date Select whether to populate the report based on encounter admit or discharge date
Actual or Estimated Net Revenue Select whether to show estimated or actual net revenue
Current From Select the starting year and month of the report
Current To Select the ending year and month of the report
Group By Select the column to use as a header for each row, often Service Line 1, Service Line 2, etc.
Limit Encounters (optional) See Using the Filter Wizard

Report Options

The following table describes the options available for this report:

Option Description
Group by Options (rows)

Service Line 1, Service Line 2, or Service Line 3. You can specify the name.
Measure Options
  • Actual or Estimated Revenue
  • Months to aggregate data to specific months, quarters, and years in Fiscal and Calendar Years depending on the selection
Views

  • Inpatient – Shows cases, patient days, ALOS and financial performance for Inpatient cases

  • Outpatient – Shows encounters and financial performance for Outpatient cases

  • Combined – shows both Inpatient and Outpatients datal
Quick Filtering Yes
Drills No
Printable Yes
Primary Source Table Encounter
Design Notes Report uses combined GetData and Axiom Architecture

Report Examples