Add a new provider
Add a new provider to the Budget Provider List driver.
-
Double-click Double Click to Insert New Provider.
-
Enter the number of rows to insert.
-
Complete the fields in each column.
-
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:
|
| Secondary Comp Model | From the dropdown, do one of the following:
|
| 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:
|
| NY Guarantee | Do one of the following:
|
| 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. |
| Provider Hours Spread |
From the dropdown, do the following:
|
