Add a new provider

Add a new provider to the Budget Provider Simple Dept Config Basic driver.

NOTE: This driver includes only provider and department combinations that have activity recorded in the current year actual Provider table.

  1. Double-click Double Click to Insert New Provider.

  2. Enter the number of rows to add.

  3. Enter a provider ID.

  4. Enter a data type.

    NOTE: The Type column shows how a provider's work is measured. See the Data Type options table below for definitions of each option.

  5. Click Enter.

  6. To save, right-click on the Budget Provider Simple Dept Config Basic tab and select Save > Save Data Only.

Data Type options

This table describes the data type options in the Type column.

Option Description
Encounter Represents a patient visit used to measure a provider's workload.
FTEClinical

The provider's clinical workload measured as an FTE Full-time equivalent. A unit of measure that represents a full-time workload regardless of how many people are needed to cover it..

Enter the value of the FTE to use in the Provider and ProviderComp tabs in the plan file.

The FTE you specify here overrides actual payroll FTEs. This allows administrators to lock the FTE value when setting volume targets. This function also overcomes data issues with payroll hours.

NOTE: The value you enter here will be the FTE value used in the ProviderComp and Provider tabs.

FTEAcademic

Represents the portion of a provider's time spent on teaching or academic activities, measured as an FTE.

Enter the FTE used to track the provider FTE into common functional categories of clinical, academic, and admin.

NOTE: The FTE you enter here does not affect the plan file FTE. Only the FTEClinical row affects the plan file, but all three of the FTE rows save to the driver table for reporting.

FTEAdmin

Represents the portion of a provider's time spent on administrative duties, measured as an FTE.

Enter the FTE to use to track the provider FTE into common functional categories of clinical, academic, and admin.

NOTE: The FTE you enter here does not affect the plan file FTE. Only the FTEClinical row affects the plan file, but all three of the FTE rows save to the driver table for reporting.

WRVU

Represents provider productivity measured using work relative value units (wRVUs)

Enter the WRVU value for this department provider.

This gives the admin total control over the value of the current year projection and next year budget as well as the spread of the WRVUs for each month of the budget.

CRVU

Represents provider productivity measured using clinical relative value units (CRVUs).

Enter an adjustment to the per unit ratio to apply to CRVU if historical relationship is not desired.

CRVU is designed in the Provide LE calculation method to be a per unit relationship the driver stat (for example, WRVU) so CRVU will not be entered from this location.

Shadow

Represents the time spent in training or observation that does not generate clinical activity.

Enter the Shadow WRVU value for this department provider.

This gives the admin total control over the value of the current year projection and next year budget as well as the spread of the Shadow WRVU for each month of the budget.

Research

Represents time the provider spends on research activities rather than patient care.

Enter the Research WRVU value for this department provider.

This gives the admin total control over the value of the current year projection and next year budget as well as the spread of the Research WRVU for each month of the budget.
AdjDays

Adjusted workdays used to measure provider activity or availability.

Enter adjustments to the workdays for each department provider combination.

Budget Provider Simple Dept Config Basic driver columns

This table describes the driver columns.

Column Description
Provider The name of the provider included in the budget.
ProviderID A unique identifier for the provider.
Type Identifies how the provider’s work is measured for budgeting purposes, such as encounters, productivity, or FTEs.
Dept Desc The name of the department the provider is associated with.
Dept The department number where the provider’s activity is budgeted.
Source Indicates whether the row is based on previously loaded data or newly added provider information.
Conversion Ratio A factor used to convert provider activity into another measure, such as converting encounters or productivity into FTEs.
L2A The provider’s actual value from two fiscal years ago.
LYA The provider’s actual value from the prior fiscal year.
CYB The budgeted value for the current fiscal year.
YTD The year-to-date actual value for the current fiscal year.
CY Projection The projected total for the current fiscal year based on year-to-date activity.
Total CYP The full-year projected total for the current fiscal year.
CYPMetric The calculated metric used to derive the current-year projection.
NYB1-NYB12 The budgeted provider value for each month of the next fiscal year.
Total The total of all next-year monthly budget values for the provider and type.