Use this section of your worksheet to add personnel costs. This article covers the following topics.
Each person added is a row in the table for this section. The last row is the Salary & Benefit Costs Total. This displays the calculated total for each period and the All Periods column. The following image shows an example of this section.
The column headings for personnel are:
- Project Role
- Period description, with the period dates
- All Periods
You can add either UW Personnel or Placeholder (TBD – to be determined) personnel to your budget. Placeholder (TBD) personnel can used, for example, to add some personnel roles to your budget when you do not yet know specifically who the person will be.
To add personnel, click on the Add Personnel Cost drop-down menu to the right of the section title. Then select either Search for UW Personnel or Add Placeholder Personnel. The following image shows the expanded drop-down menu.
Adding UW Personnel
When you select Search for UW Personnel, the system adds a row at the top of this section, and puts the cursor in the Name field. As indicated by the hint text, you can search by name or NetID. As you type in characters, the system will start displaying matching results. As you add more characters, the results list will continue to update.
The results list shows the person’s first and last name, their title and department. From the results list, click on the person you want to add them to your budget. Their first and last name will display in the Name field.
The following image shows an example of a search and results list.
Use the Role drop-down menu to indicate their relationship to the project. Choices are:
- Principal Investigator – only one person on a worksheet can have this role
- Application PI
- Multiple PI
- Key Personnel
- Post Doctoral Associate
- Graduate Student
- Research Scientist
- Undergraduate Student
As you add personnel, each new person is added as the top row, for easy access. A Sort by Role link displays above the All Periods column. When active, clicking it will rearrange the list of personnel to match the order in the drop-down. It will only be active when the list is not in order.
Adding Placeholder Personnel
When you select Add Placeholder Personnel, the system adds a row at the top of the section with TBD in the Name column. You can use the name side panel, described below, to adjust the name for a placeholder (TBD) entry. Use the drop-down menu in the Role column to indicate this person’s relationship to the project.
There are two side panels with additional details for personnel. Each can be closed by clicking on the blue X to the right of the panel name, or by clicking somewhere outside of the panel.
Personnel Details Panel
Access this panel by clicking in the Name field. It allows you to edit the person’s title, and to add a Prefix or Suffix to their name. The following image shows the personnel details panel.
Personnel Period Panel
Access this panel by clicking in a period field for an individual. It allows you to view and adjust salary, effort, and benefits details used to calculate the cost for this person.
The panel header includes:
- The period description
- The period total dollar amount, which is equal to the Adjusted Monthly Base Salary + Total Benefits
- Information text indicating the current cascading state (on or off)
- The blue X, to the right of the period description, which will close the panel
The following image show the panel header and salary areas.
Monthly Base Salary
- For UW Personnel, this value from Workday. Below this field, there is a link to View Salary Details. When clicked, it opens a dialog showing additional details about the person’s compensation. The dialog is described below. Within the field is a Refresh icon (two curved arrows). Clicking this will open a confirmation dialog stating “Refreshing this salary will replace the current salary with the most up-to-date value for person’s name. Custom allocations you have added will be overridden.” You can continue or cancel from the dialog.
- For Placeholder Personnel, the Monthly Base Salary is a default value of $0. Enter the appropriate amount for this period.
- For a newly created budget and primary worksheet, the default value is 2%.
- A newly created sub-budget worksheet will use the value from the Budget Settings.
Adjusted Monthly Base Salary
- This is a system calculated field.
- It is equal to the Monthly Base Salary adjusted for inflation.
The following image show the panel effort area.
Calendar or Academic/Summer
- The default value is Calendar for all personnel.
- If you select Academic/Summer, appropriate fields will display for effort values.
Months or Academic/Summer Months
- For calendar, the default value for Months is the length of the period
- For academic/summer, the default values are 75% and 25% of the length of the period, respectively. The fields are editable, so you can adjust these assumed values, if needed.
Percent Effort or Academic/Summer Percent Effort
- The default value is 0%.
- Enter the amount of effort for this person, and the system will calculate the Monthly Hours.
- The calculated value is equal to the Monthly Hours/ 173.3 * 100. There are 173.3 hours in a standard month.
Note: This field and the Monthly Hours field are connected. If you enter a value in one, the system will calculate the value for the other. This lets you choose which value you want to enter.
Monthly Hours or Academic/Summer Monthly Hours
- The default value is 0.
- Enter the number of hours for this person for this period to have the system calculate the Percent Effort.
- The calculated value is equal to the Percent Effort / 100 * 173.3 There are 173.3 hours in a standard month.
- This is a system calculated field.
- The value is equal to the Percent Effort * Months
Total Requested Salary
- This is a system calculated field.
- The value is equal to the Adjusted Monthly Base Salary * Percent Effort
The following image show the efforts area.
UW Sub-Object Code
- For UW Personnel, their sub-object code from Workday displays.
- For Placeholder Personnel, use the drop-down menu to select the appropriate sub-object code.
Note: for sub-object codes in the 30, 40, 50, or 90 range, the system will automatically add a tuition entry in the Other Costs section of your worksheet for the individual. See the Linked Tuition Entries section below for full details.
APL Benefit Rates Option
- If you enabled APL in the worksheet settings, two options will display: Standard Benefits and APL Benefits. By default, the Standard Benefits option is selected. To use the APL Benefits option, click on its tab.
- Two rate fields will display, APL Benefit Rate and APL Leave Rate, with the corresponding rates for the sub-object code selected. Both rates are editable.
- A link to Refresh Benefit & Leave Rates displays below the option tabs.
- Selecting the Standard Benefits tab will remove the APL fields and re-display the standard rate.
- The corresponding rate for the sub-object code selected displays
- You can enter a different value, if needed
- Within the field is a Refresh icon (two curved arrows). Clicking this will open a confirmation dialog stating “Refreshing the benefit rates will replace the current benefit rates with the most up-to-date values for person’s name.” You can continue or cancel from the dialog.
- If using APL benefits, the value is the sum of (APL Benefit Rate * Total Requested Salary) + (APL Leave Rate * Total Requested Salary)
- This is a calculated field
- The value is equal to Total Requested Salary * Benefit Rate
Adding Entry Notes
To the right of the All Periods column is a “more actions” menu icon. The icon is 3 blue vertical dots. When you click on the icon, the menu displays with these choices:
- Add Note – if none exists
- Edit Note – if there is an existing note
- Delete Note – if there is an existing note
- Turn Cascading Off/On – affects this individual entry
- Delete Personnel – removes the person from the budget.
When you select Add Note, a dialog will display with the person’s name and role. Use the text box for entering your note. Click Save to complete the process. You can also cancel out of the dialog, without saving a note. The following image shows the note dialog.
When a note is added, an icon will appear following the person’s name. Place your mouse over the icon to read the note.
If a note is present, the menu will include Edit Note and Delete Note. If you select Edit Note, the same dialog will appear. You can edit the current note, and then save the updated text. If you cancel, the original note remains.
If you select Delete Note, the note and note icon are both removed.
Linked Tuition Entries
When you add a personnel cost with a tuition-eligible sub-object code (30s, 40s, 50s, or 90s), the system will automatically add a linked tuition line item (08-05) to the Other Costs table, and a brief note to that effect will display.
A small gray oval with a university icon will display in the Name column for that personnel entry. When you hover your mouse over it, the text “This personnel cost has a linked tuition cost” will display. Correspondingly, the tuition entry will have a read-only description of “Tuition for first-name last-name” followed by a link icon. When you hover your mouse over the icon, the text “This tuition cost has a linked personnel cost” will display.
In the Personnel side panel, two additional items will display. A toggle switch to “Include linked tuition cost”, followed by an “Edit Period X Tuition” link button. The toggle switch is on by default. If you turn the toggle off, a confirmation warning will display. If you confirm the change, the linked tuition line will be deleted. The personnel line item icon will change to an orange warning icon, and the option to “Edit Period X Tuition Cost” will be removed from the side panel. Hovering over the orange icon will display the text “Personnel with this sub-object code usually have a linked tuition cost”.
When the toggle switch for “Include linked tuition cost” is off, the warning of “Personnel with this sub-object code usually have a linked tuition cost” will display below it. Switching it back on will re-create the linked tuition entry.
When you change the sub-object code for a personnel line to one that is tuition-ineligible, then a confirmation modal displays. It clarifies that the change will delete the linked tuition line item. When you confirm the change, the personnel sub-object code will be updated and the tuition line item will be deleted.
If you select “Edit Period X Tuition” in the personnel side panel, the system will redirect you to the tuition entry for that person, for that period, and its side panel will display.
In the linked Tuition side panel, selection the “Edit Period X Salary & Benefits” link button will redirect you to the personnel entry for that person, for that period, and its side panel will display.
The “more options” icon at the right of a linked tuition line includes an option to delete the line item. Selecting it will display a confirmation modal, and continuing will delete the tuition line item. The formerly linked personnel line item is not deleted.