Tag Archives: Update Periods

The value of the Facilities and Administrative (F&A) line for a period or the summary column is equal to the Amount Subject to Facilities and Administrative times the F&A rate.

The global F&A rate is determined in the budget setup and display on the F&A tab.

The following data values display at the top of the modal.

  • Sponsor Name
  • Flow Through Sponsor
  • Institutional Activity Category
  • Location
  • Specific Funding Mechanism
  • Base Type

Select the expansion triangle for the F&A Rate section near the bottom of the modal to see the following fields:

  • Period Rate is Custom: When you enter a value in the F&A Rate field that is different from the global rate, this box will display as checked to indicate that a custom rate applies to this specific period.
  • Justification for Custom Rate: This field is required when you specify a rate other than the global rate.

The Update Periods page displays personnel values for a selected individual, for all budget periods.

The selected individual’s name and title display above the values.

The sections are

Each section can be collapsed or expanded as desired.

Base Salary

The following image shows the Base Salary section of the Update Periods modal, for just one period as an example.

base salary section of update periods

This section includes

  • Monthly Base Salary
  • Update Salary
  • Salary Inflation Rate (%)
  • Adjusted Monthly Base Salary

The Monthly Base Salary for the first period is, by default, the value entered as the Starting Monthly Salary on the Line Setup page. For any following periods, the Monthly Base Salary will be the prior period’s Adjusted Monthly Base Salary value.

For personnel that are paid hourly, the Starting Monthly Salary value, on the Line Setup modal, will be equal to the hourly rate of pay times the number of hours in a standard month (173.3 hours). 

The Salary Inflation Rate is the value specified in the Inflation & Benefit Rates section of the Properties tab page.

The Adjusted Monthly Base Salary is automatically calculated. It equals the Monthly Base Salary amount increased by the Salary Inflation Rate.

Effort

The following image shows the Effort section of the Update Periods modal.

effort section of update periods

This section includes

  • Months
  • % Effort
  • Person Months

Months is auto-calculated based on two data values:

  • The length of the period in months
  • Worker Position Type (calendar vs. academic) on the Line Setup modal

A budget period that includes a leap year will not affect the Months calculation.

% Effort is auto-calculated based on the initial % Effort entered on the Line Setup page.

Person Months is automatically calculated and is equal to: Months times Effort.

Period Salary Totals

The Period Salary Totals row shows the total for each period and in the far right Summary column, the total for the project.

    • Period Salary Total = Adjusted Monthly Base Salary times Person Months
  • Project Total = sum of all period totals

If the budget has a Salary Cap enabled, this will be expandable section. It will also display the individual’s salary without the cap imposed.

Period Benefits Totals

The following image shows the Period Benefits Totals section. The values are described below.

benefits totals section of update periods

This read-only section is pre-populated based on data entered on the Line Setup page for this person (specific individual or a TBD one).

For more information on benefits rules and rates, see GIM 3 Fringe Benefit Rates and Sponsored Projects.

Field Description
Benefit Type The UW Sub-Object Code selected on the Line Setup modal determines the benefit type and rate.

“APL” is listed if Include APL Benefits was selected on the Line Setup modal.

Benefit Object Code The UW Sub-Object Code entered on the Line Setup modal determines the benefit type.
Benefit % The benefit rate is determined by the Benefit Object Code (above) and whether APL was selected.
Total Benefits This total is calculated by multiplying the Period Total Salary by all listed benefit rates. If you update the data on the Setup page, then this total will reflect the changes.

Total Salary + Benefits

The Total Salary + Benefits row shows the total for each period and in the far right Summary column, the total for the project. The values are the sum of the Period Salary Totals and the Period Benefits Totals.

Tuition

Tuition may be included for student personnel, which are UW Sub Object codes 33, 34, 43, 44, 51, 52, 53, 54, 91, 92, 93, and 94.

Note: UW Sub Object codes (88) Hourly Work Study and (89) Hourly Student Salary do not include Tuition Benefits.

The following image show the Tuition section of the Update Periods modal with some example values. Each field is described below.

tuition section of the update periods screen

Field Description
Academic Quarter Tuition Rate The tuition rate for student personnel. There may be different tuition rates for the summer and academic year quarters.
Number of Academic Quarters The number of quarters this student will be working on the project.
Academic Tuition Amount This is a calculated field. It is equal to the Academic Quarter Tuition Rate times the Number of Academic Quarters.
Summer Quarter Tuition Amount The summer tuition amount for student personnel included in your budget.
Increase % (Academic & Summer) An inflation rate for tuition, which is applied to both Academic and Summer amounts.
Total Tuition This is a calculated field. It is equal to the sum of the Academic Tuition Amount and the Summer Quarter Tuition Amount, multiplied by the Increase percentage.

The Total Tuition values display in the “(08) Student Aid” section of the budget worksheet.

The setup page for personnel, including To Be Determined (TBD) persons, consists of four sections:

Primary Position Type & Fringe Benefit Rate

This section contains the values for the person added, as described in the following table. This following image shows the fields with example data for a budget that includes APL benefits.

primary position type and fringe benefit rate section

Field Description
Name The person selected in the Personnel Chooser or “TBD” for placeholder personnel
Title The selected person’s title or the user-entered title for a TBD person.
UW Sub Object Code The UW Sub Object Code for the person.
Include APL Benefits Displays if you selected Budget includes Applied Physics Lab (APL) in the Advanced Settings section of the Properties tab. If checked, the Benefit Type for this person will be APL.
Benefits Exemptions Provides current HR benefit exemption information on the individual.
Current Campus or APL Benefit Rates Displays the appropriate benefit information for this person.

If Include APL Benefits is checked, the two APL Rates will display.

Cascade Entries If checked, will indicate that the system cascaded salary values across periods.

Project Role and Effort

This section indicates whether the person’s position is Calendar or Academic, their role in the project, and the amount of effort.

project role and effort section

Field Description
Worker Position Type Calendar is a 12-month period. Academic/Summer consists of a 9-month academic period plus a 3-month summer period.
Project Role Roles are:

  • Principal Investigator
  • Application PI
  • Multiple PI
  • Mentor
  • Co-Investigator
  • Faculty
  • Key Personnel
  • Post Doctoral Associate
  • Graduate Student
  • Undergraduate Student
  • Secretarial/Clerical
  • Fellow (deprecated)
  • Other (default)
% Effort

Academic % Effort

Calendar % Effort

Used to calculate the Person Months, Period and Project Totals for the person’s (01) Salaries and Wages line items. It is dependent on appointment type.

  • For a “Calendar” appointment, the percentage of effort is calculated on a 12-month period.
  • For an “Academic” appointment, the effort periods are broken into two terms, Academic (9 months) and Summer (3 months).
Academic Hours Per Month

Summer Hours Per Month

Displayed only for Academic Appointment types, once for Academic and once for Summer. The value is equal to the % Effort times 173.3 (the number of hours in a standard month).

Salary, Wages, and Stipends

This section displays information about the person’s earnings.

salary, wages, and stipends section

Note: Salaries are adjusted to reflect any salary cap on the Targets & Caps Tab. Personnel with a capped salary are indicated.

Field Description
Date Retrieved  System-generated date (mm/dd/yyyy) indicating when the salary information was retrieved from the source system.
UW Monthly Salary The salary of the person based on a 100% FTE.
Clinical Monthly Salary The clinical salary information where applicable.

The earnings table lists all of the earnings for the selected person.

Column Description
Checkbox This is checked by default to include this row in the Starting Monthly Salary total
PositionID  Unique identifier for the Workday position
Obj-SubObject  This value is 01 for Salary and Wages, followed by the sub-object code for the selected person
Cost Center  Cost center name and code
Organization  Organizational unit name and 10-digit code
Position Title  Selected person’s title for this position
Pay Type  Possible pay types are:

  • Allowance
  • Stipend
  • Basepay

Administrative and Endowed Supplements are included for Non-Faculty Personnel.

Unallocated Rate Monthly or Hourly Rate
Distribution %  Proportion of total for this earning type
FTE Rate  Total of Unallocated Rate value times the Distribution percent

The Starting Monthly Salary field will reflect the total of the selected (checked) earning rows.

Notes

This section displays any user-entered notes for this personnel entry.

The following two scenarios explain how to adjust for personnel promotions between and during a budget period, so that the budget properly reflects the appropriate UW Sub Object Codes for position and benefits.

Add a Salary Increase for a Promotion between Periods

The Problem

When you add a person to a project, their appointment (or sub object code) is specified for the length of that project and cannot be changed.

So what do you do for a researcher who will get a promotion and a raise at the end of the first period, for example? Our researcher is currently a Senior Fellow for the first period and then an Assistant Professor for the second and subsequent periods.

The Solution

Use two budget line items: one for the current appointment and one for the future appointment. Each appointment will be used for a separate period.

The Implementation

Add a Salary and Benefits line item for the researcher in the first period with the current appointment, and with the appropriate amount of effort. For the second, and all future periods, change the salary to $0 and the effort or person months to 0%.

Add a second Salary and Benefits line item for the same researcher with the future appointment. Enter the salary as $0 for the first period and the new salary amount for the second period. The new salary will automatically cascade to the future periods.

Schematically, the salary changes look like this, with example salary figures.

2023 2024
Senior Fellow
(01-23)
$50,000
100% Effort
$0
0% Effort
Assistant Professor
(01-11)
$0
0% Effort
$85,000
100% Effort

SAGE displays the worksheet with the researcher’s salaries for the first and second periods of the project.

  • In the first period, the researcher will make $50,000 as a Senior Fellow. In the second period as a Senior Fellow, they will make $0.
  • In the first period as an Assistant Professor they’ll make $0 but in the second they’ll make $85,000.

Add a Salary Increase for a Promotion during a Period

The Problem

This time the researcher’s promotion from Senior Fellow to Assistant Professor will occur in the middle of the first period.

The Solution

Use two budget line items: one for the current appointment and one for the future appointment. The line for the future appointment will be adjusted for the one period in which the promotion occurs.

The Implementation

Add a Salary and Benefits line item for the researcher in the first period with the current appointment. Let’s assume that the promotion will take effect half-way during the period.

So, on the line item for the current appointment, you would indicate 50% effort. Then on the line item for the future appointment, you would also indicate 50% effort. Finally, on the following periods, you would adjust the effort on the current appointment to 0%, and on the future appointment to 100%,

2023 2024
Senior Fellow
(01-23)
$24,720
50% Effort
$0
0% Effort
Assistant Professor
(01-11)
$50,985
50% Effort
$105,029.10
100% Effort

The Student Aid (08-00) line item links directly to personnel setup in the (01) Salaries and Wages section of the budget. It may be used for specific personnel sub-object codes (33, 34, 43, 44, 51-54, 91-94).

This page presents the information for all of the periods for the chosen person. The values are from the Salary and Wages section.

The information displayed here is not directly editable.

  • Quarterly Tuition Rate displays the value for this person, such as: Standard Campus.
  • Number of Quarters displays the value entered for the particular period when the person was added in the Salary and Wages section.
  • Increase % (percent) is the percentage rate that applies to the Quarterly Tuition Rate.
  • Total Tuition is the dollar amount of the tuition.

The Sea Pay line item appears if the Budget includes Sea Pay checkbox is selected on the Properties Tab. Use it to include additional work hours above a standard 40 hour work week when personnel are at sea.

sea pay line item in the salary and wages section

The Sea Pay Calculation accommodates up to an additional 44 hours per week for personnel at sea.

Sea Pay Personnel List and Benefits

Click in any period to open the Sea Pay Personnel List.

entry screen for sea pay hours

Field Description
Name Shows the name of the individual or TBD person added, followed by their Title.
Monthly ($) For salaried personnel, this value is derived from the “Monthly Base Salary” plus any salary inflation rate increases for a period. For hourly personnel, this value is the “Rate/Hour” value plus any salary inflation rate increases for a period multiplied by 173.3 (hours per average month).
Hourly Rate ($) For salaried personnel, this value is the Monthly value divided by 173.3 (hours per average month). For hourly personnel, this value is the “Rate/Hour” value plus any salary inflation rate increases for a period.
Hours Enter the value that represents the actual “Sea Pay” hours worked for each period.
Period Total ($) Equal to Hourly Rate times Hours.