Add a new provider

Add a new provider to the Budget Provider List driver.

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

  2. Enter the number of rows to insert.

  3. Complete the fields in each column.

  4. To save changes, right click the driver tab and select Save > Save Data Only.

This table describes the columns in the Budget Provider List driver.

Option Description
Provider The provider whose compensation is defined and calculated in the budget.
EmpID The employee identifier used to link the provider to payroll and compensation data.
Name The provider's name.
Primary Comp Model

Identifies the primary compensation structure used to calculate the provider's pay (for example, Salary, Guarantee, CompAltStep, or CompAltRate).

If the provider's model is not listed:

  • Select GlobalProvider. You can use GlobalProvider to feed offline compensation calculations into the Budget workbook.
  • Select the closest match to the provider's compensation method. Then enter adjustments on the ProviderComp tab >Compensation Adjustments line.
Secondary Comp Model From the dropdown, do one of the following:
  • If a provider's compensation method is changing in the budget year, select a comp model for the provider.
  • If the provider's compensation method is not listed, do one of the following:
    • Select GlobalProvider. You can use GlobalProvider for offline compensation calculations to feed into the Budget workbook.
    • Select a compensation model that most closely matches the provider's compensation method, and on the ProviderComp tab, enter adjustments in the Compensation Adjustments line.
Comp Change Month Identify the month that the compensationchanges to the Secondary Comp Model by typing 1 for the first month of the organization's fiscal year, 2 for the second month, and so on.
CY FTE

Enter the total FTE for the provider in the current year (CY).

Use CY FTE and NY FTE for allocating the guarantee if the provider is split among multiple departments. You can also use them in the FICA calculation when a portion of the salary is grossed-up.

NOTE: The system builds current year FTEs from actual hours posted to payroll. It does not pull FTE data from the Driver.

NY FTE

Enter the total FTE for the provider for the next year (NY).

NOTE: The projected total FTE flows to the NYB FTE. The system does not pull FTE data from the Driver.

CY Guarantee Do one of the following:
  • If the Comp Model is assigned as Guarantee, enter the amount.
  • If the Comp Model is not assigned as Guarantee, enter 0.
NY Guarantee Do one of the following:
  • If the Comp Model is assigned as Guarantee, enter the amount.
  • If the Comp Model is not assigned as Guarantee, enter 0.
CY Net Rev Collection Pct Enter the current year percentage when using the Percent of Net and Percent of Cash Collections calculations.
NY Net Rev Collection Pct Enter the Next Year Budget percentage when using the Percent of Net and Percent of Cash Collections calculations.
CY Gross Charge Percent Enter the current year percentage when using the Percentage of Gross calculations.
NY Gross Charge Percent Enter the Next Year Budget percentage when using the Percent of Gross calculations.
Key Statistic From the dropdown, select the key statistic to use on the Provider tab for the Revenue, WRVU, and RVU calculations. The default should be Encounter.
Comp Driver From the dropdown, select the key statistic to use on the ProviderComp tab for the compensation calculations. The default should be WRVU.
CY Level 1-5

Enter the rate per WRVU and the level threshold for the Current Year Projection.

NOTE: Tiered compensation calculates at less than as opposed to less than or equal to the threshold value.

NY Level 1-5

Enter the rate per WRVU and the level threshold for Next Year's Budget.

NOTE: Tiered compensation calculates at less than as opposed to less than or equal to the threshold value.

Alt Level 1-5

Enter the alternate rate per WRVU and the alternate level threshold for Next Year's Budget. Use this model for different rates and level thresholds as you make changes to your compensation model.

NOTE: Tiered compensation calculates at less than as opposed to less than or equal to the threshold value.

Additional Salary Amounts

Use this section to add components that are physician-specific. You can use the first five categories to add on salary components, such as directorships, honorariums, and other types of compensation to their compensation. These rows are included in the FICA calculation.

Additional Benefit Amounts

Use this section to add components that are physician-specific. You can use the last five categories to add on provider-specific expenses such as CME (Continuing Medical Education), phone allowance, malpractice, and so on.

These rows are excluded from the FICA calculation. You need to assign a pay type for each category you use. You must add these codes to your PayType tab in dimensions to save this additional information to the Payroll12 database for each provider. Strata recommends that you add a prefix of Z_ so they do not interfere with your normal pay types.

If you do not want to use a category, leave the yellow cell blank. Use the blue dropdown cell to identify how to spread the expense in the Budget workbook.
Options are: Even, FTE, Salary.

Provider Hours Spread

From the dropdown, do the following:

  • To spread the hours on the Provider Comp tab evenly, select Even.
  • To spread the hours by FTE allocation, select FTE.