Provider Detail and Provider Summary sheets

NOTE: This tab only displays if your organization purchased the Provider module license.

There are two sheets available that include provider level information: Provider Summary and Provider Detail.

Provider statistics are computed using historical relationships. Provider volumes are computed using today’s Encounters per Production Day and adjusted for next year’s Available Production Days.

IMPORTANT: Because the tab is rebuildable, any changes made in the Provider data tables after the plan file is built will be automatically updated in the plan file. These changes are commonly referred to as prior period adjustments, which will be reflected in the YTD columns in the tab.

To view a list of Provider calc methods, click one of the following:

• Expense sheet calc methods
• Provider sheet calc methods
• Stat_Rev sheet calc methods

Provider Summary sheets

This sheet provides a summary of the totals at the department and individual provider level.

Provider Detail sheet

This sheet shows summary subtotal information for each provider, but you can also access the details for each provider by using the Click-to-Expand feature.

The Click-to-Expand feature expands the rows and inserts the calc method that includes the provider detail information such as WRVUs, gross charges, RVUs, encounters, and so on. You can simply scan and review the summary information for each provider without having to sort through multiple lines of details to view the information you need, and if necessary, expand the details and manage only those providers that need it.

TIP: When you save the file, the system will remember which providers you have expanded the detail rows for that day. Let's say you expanded the detail rows for five providers and saved your changes, when you open the file later, the detail lines will still display for those five providers. When the plan file processes that evening, however, the system will collapse all of the detail rows so that the tab opens faster.

IMPORTANT: The Summary Department Totals section at the top of the tab will not update values until you save changes to the workbook.

Updating detail provider values from the Stat_Rev tab

Any changes made to the provider's FTE value on the ProviderComp sheet will affect the values for that provider in the Provider Detail sheet. To see that result within your session, double-click the Double click to collapse/refresh Provider summaries cell to refresh the data; otherwise, the nightly recalculation process will update it automatically.