UW IT has made a change to their Clinical Salary service, which requires SAGE to update to their new end point.
Switch to new Space Service End Point
UW IT has made a change to their Space Web service, which requires SAGE to update to their new end point.
FIX: Update procedure causing task list performance issues
One of the procedures supporting the subaward task list has been improved in its design in order to improve performance when searching.
Upgrade front end developer tools
The front end engineers have upgraded to a new set of tools and a consolidation of code into a monorepo architecture. This update provides important streamlining benefits, allowing SAGE to deploy updates in a targeted way, and for code to become more easily managed and maintained.
An issue was resolved in the viewing of salary details in SAGE Budget, occurring at times when salary data was refreshed by the user.
FIX: SAGE Budget re-saving issue in salary details view
An issue was resolved in the viewing of salary details in SAGE Budget, where re-saving of the select allocation details caused clinical salary to be omitted.
When you link a SAGE Budget to an eGC1, each item’s contacts and access lists are combined into a shared “access” page. A set of rules determines how the data is combined, so that no user loses access.
Once you link the Budget and the eGC1, you can make changes from either the eGC1’s Contact & Access page or from the Budget Settings Access & Roles section.
The shared page includes the “owners” which are the Administrative Contact, Pre-Award Budget Contact, eGC1 Preparer, Budget Preparer and the eGC1’s PI. The list will also include any general collaborators with assigned access, either Can Edit or View Only.
The rules for combining the information from the original pages are:
If you have different Administrative Contacts and Budget Contacts listed on your eGC1 and your SAGE budget when they are connected:
Any existing SAGE Budget contacts will display on the resulting shared page.
The eGC1’s contacts will change to editable access, either Read/Write (eGC1) or Can Edit (Budget). Note: If your budget does not have an Administrative or Budget Contact, then the eGC1 contact will display on the shared page.
The eGC1 and Budget Preparers will display on the shared page.
The PI listed on the eGC1’s PI & Personnel page will be the PI on the shared access page.
Users will keep their higher level of access to the connected eGC1 and SAGE Budget. For example, a user with View Only access to the SAGE Budget and Read/Write access to the eGC1, will have edit access on the shared page.
Read/Write (eGC1) or Can Edit (Budget) are a higher level of access than Read-Only (eGC1) or Can View (Budget).
Owners (contacts, preparers, and PI) always have edit access.
Anyone with edit access may change or remove assigned access for anyone else.
Disconnected Budget and eGC1
When you disconnect a budget from an eGC1, each item will retain the Administrative Contact, the Pre-Award Budget Contact and a copy of all users with assigned access.
Additionally, these adjustments will be made:
The Budget Preparer role will not display on the eGC1. However, if the Budget Preparer had no other access to the eGC1, they will be assigned Read Write access to it.
The eGC1 Preparer role will not display on the Budget. However, if the eGC1 Preparer had no other access to the Budget, they will be assigned Can Edit access to it.
The eGC1’s PI will be assigned Can Edit access to the Budget.
Access page for multiple eGC1s and their connected budget
If you have a budget which is connected to multiple eGC1s:
Access lists for the eGC1s and their connected budget will merge.
The creator of the most recent eGC1 will become the eGC1 Preparer on the shared access page and will therefore have owner (edit) access.
Creators of all other eGC1s will have read-only access.
The PI on the most recent eGC1 will receive any email notifications and be listed as an owner.
Any former PIs will still display on the PI, Personnel, & Organizations page of the corresponding older eGC1. They will have read-only access to the current eGC1 and Budget. The former PIs will not receive email notifications.
Note: The PI on the most recent eGC1 will display on your My eGC1s page, so you will be unable to search for an older eGC1 using the former PI’s name.
Access for Global Editors
SAGE users with the Global Edit ASTRA role do not display on the access list for an eGC1 or Budget. They only have access to eGC1s not in Composing status. They will also have read/write access to any budgets connected to those eGC1s.
Notes, tips, and warnings
If you are preparing your eGC1 and budget at the same time, connect your budget before filling out the access page. You will then only need to fill in the information once.
If you remove yourself as an owner from the Contacts & Assign Access page for an eGC1 in Composing status or in Withdrawn status with no approvals, you will no longer have any access to the eGC1 or its connected budget. For an eGC1 in Approved or Returned status, you will retain read-only access.
Be sure you are connecting the correct budget to your eGC1 or the wrong people will end up on the access list.
As you manage an awarded project over time, you might link more than one eGC1 to the same SAGE Budget. When that occurs, there are several things to consider.
Editing Linked eGC1s and their Budget
Generally, you cannot edit an eGC1 in Routing or In OSP status or its linked budget. When you link multiple eGC1s to the same budget, none of the eGC1s or the budget are editable if any one eGC1 is Routing or In OSP.
Shared eGC1 Data: Contacts & Assign Access
Information on the Contacts & Assign Access page is shared across all of the eGC1s and the budget that links them. If you make a change on any one of the eGC1s or the budget, it affects all of the other linked items.
For example, assume you have an older Approved or Awarded eGC1 linked to a budget. You then link a new eGC1 to the same budget. If you make changes on the new eGC1’s Contacts & Assign Access page, those changes will happen on the older eGC1 and the budget also. This ensures that the current contacts receive any system email notifications sent concerning either related eGC1.
Shared eGC1 Data: Research Personnel
Similarly, if you make a change to the PI, Personnel, & Organizations page on any of the linked eGC1s, it will display on all of the other linked eGC1s. You can change the PI, add or delete other personnel, or update an investigator’s status. Once an eGC1 has reached Approved status, the Post-Approval Personnel Changes section displays at the bottom of the page and lists any changes.
The intent is to maintain one up-to-date list of the research personnel working on the project, for the purposes of significant financial interest (SFI) disclosures. When you add new investigators to the list, they will have to create a disclosure for the older eGC1 in addition to the new one.
Note: changes to the PI, Personnel, & Organizations page do not affect the personnel listed on the linked budget.
Any personnel changes you make to an eGC1 after approval do not affect the approval graph. It remains as it was at time of approval. The list of people on the cost share page will be the people who were on the eGC1 at time of OSP approval. Personnel that you add post-approval do not display on this page.
Also, the eGC1 Snapshot on the approval History & Comments page will still show the data as it was at the time that person approved.
One of the benefits of using SAGE Budget to create your proposal budget is that you can then connect it to your eGC1. It will automatically populate the Budget page of your eGC1. Since the two items are linked, any time you update your budget, your eGC1 will show the updated data. When you select a budget period to connect to your eGC1, SAGE imports all the data from your budget worksheets.
In addition, if your eGC1 is a Grant Runner application using the RR Detailed Budget form, your budget data will be mapped into the form. A Sponsor Budget Map link will display on the left navigation menu for you to make any desired changes to where the data maps by default. Review the Sponsor Budget Map article for more details.
Your eGC1 and budget will route together so reviewers can easily see budget details in a standard format.
When you submit a renewal eGC1, you can use the same budget to link the award-adjusted data for the next period to your renewal application.
Contacts and Access
When you connect a SAGE Budget and eGC1, they will share the contacts and access information. Any information you update on the Budget will be reflected on the eGC1. When you connect the two items, everyone who had access to either item will still have access. The SAGE Budget and eGC1 Shared Access Data article explains the details.
Thanks to valuable user feedback, the Office of Research Information Services (ORIS) launched a redesigned SAGE Budget tool in 2020 with a more streamlined, efficient, and intuitive look and feel. This new design also lays a foundation for upcoming integrations between SAGE and Workday.
Over the last year, we’ve collected your feedback and have added several features to ensure the current SAGE Budget format meets all of your core needs (e.g. APL and Fixed Fee). We are now ready to retire the legacy format, which allows us to focus our continued enhancements in the new format only. This is especially important as we prepare for the critical role that SAGE Budget will play in communicating award budget information to the financial system when the UW goes live with Workday Finance.
Upgrading of all Legacy Budgets
With the retirement of legacy SAGE Budget, all existing budgets in the legacy format will be upgraded to the new (current) budget format. Upgrading means:
When you open your budget, it will open in the new (current) version.
Those who had access to the legacy budget will have the same access on the upgraded version.
On the History page, snapshots of previous budget versions will now display in the new (current) format.
All costs and settings (like targets and salary caps) that were enabled on the legacy budget will be enabled on the upgraded budget.
Note: Auto Adjusting Entries (AAE) will not be available in the new (current) format. AAE will be converted to a standard costs line on the primary worksheet, with a note, “Converted Auto Adjusting Line.” The following budget details will remain the same:
object/sub-object code
cost amount
periods
Budget List Updates
The following changes have been made to the budget list:
The option to create a legacy budget has been removed
The Format column has been replaced with a Created Date column
An “Upgraded” indicator displays when a budget has been upgraded by the system
The default sort order on the budget list remains the same, descending by last edited date. You can still search for your budgets by Principal Investigator (PI) name, budget number, or budget title.
Other Budget Updates (released in advance)
The default Prorated Direct Cost (PDC) rate that displays when you enable APL on a budget worksheet has been updated from 35.2% to 35.0%.
SAGE eGC1
Ad Hoc Approver Improvements
Two changes were made to the list of roles that display when adding an ad hoc approver to an eGC1 approval flow:
Several out-of-date roles have been removed.
The list has been alphabetized.
SAGE Subawards (released in advance)
Subaward Expiration Fix
Subawards that reached Expired status were not updating to Active status when a modification was processed which pushed the End Date into the future. That issue has been fixed so that the overall Subaward reflects accurate status information.
Subaward History Now Includes All Subaward Status Changes
The Subaward History now includes events for each time the Subaward Status changes. Previously, the Subaward History only included status changes for Subaward Actions. This will provide more information about when the overall Subaward transitioned through process steps.
You can identify these upgraded budgets on your budget list by the “UPGRADED” chip following the title of the budget. If you hover your mouse over the chip, the text reads “This budget was automatically upgraded from the legacy format.” The following image shows an example of this.
When you open the budget, you will see a banner displaying the same “automatically upgraded” message at the top of the Budget Summary, as shown below.
Upgraded Budgets with Some Revised Calculations
If your budget included APL (Applied Physics Lab), Fixed Fee, or Sea Pay costs, you were not previously able to manually upgrade it due to some incorrect calculations. On the automatically upgraded version of these budgets, the calculations have been corrected, so the totals will differ from the legacy version.
In these cases, an “alert” version of the banner will display. The alert text will indicate which of your budget costs needed to be corrected: APL, Sea Pay, or APL and Sea Pay.
The following image shows an example alert for a budget with APL costs.
These are the four incorrect calculation cases:
Legacy Budgets with APL/PDC (pro-rated direct costs) that included a subaward
PDC should have been charged against the first $25,000 of a subaward worksheet or subaward line 03-62.
Legacy Budgets with APL that included Sea Pay
Sea Pay benefits on APL budgets were incorrectly calculated using APL benefits AND APL Leave Benefits. The correct calculation for Sea Pay benefits is to use the APL hourly rate (01-86).
Legacy Budget with APL costs in 19-00 or 19-20
Costs from 19-00 and 19-20 should not have been used for proposal budgets and are no longer allowed in current budgets.
Legacy budgets with APL and Fixed Fee on both the parent budget and a sub-budget
The sub-budget fixed fee amount was not included in the total budget’s fixed fee.
Budgets that Could Not be Upgraded
There were a very few budgets that could not be upgraded for various reasons. To provide access to the data for these budgets, a download icon and “legacy” chip will appear on your budget list, as shown below.
Clicking the budget title or download icon will create an export to Excel in the legacy format.
New Funding Action (FA) fields added to SAGE API for GCA Budget Setup
The following fields have been added to the SAGE API, allowing GCA significant time saving in their budget setup automation work.
FA Number
Prepared By
Approved By
F&A Explanation
Disposition of Balance
Intellectual Property
Frequency of Report
Final Report
Following this SAGE API release, MyResearch squirrel will be updated so that GCA can fully access the FA data for budget setup automation (MyResearch release timing TBD).
SAGE eGC1
Budget Connection Issues Resolved
The following issues with budgets that are connected to eGC1s have been resolved:
Bad routing state caused by having a budget connected to a second eGC1
Linked budgets not opening correctly on non-editable eGC1
SAGE Budget
Minor Polish Updates
From the budget list, you can now right click on the budget title and it will open in a new tab.
When adding personnel costs, the new row is now added to the top of the salary and benefits table for greater visibility.
When viewing budget history snapshots, the banner text has been reworded for added clarity.
SAGE Grant Runner
Sponsor Budget Map Ordering
A minor issue with personnel ordering on the Sponsor Budget Map has been fixed.
The SAGE Budget infrastructure has been updated, enabling ORIS to deliver features more efficiently moving forward.
SAGE Budget has also been updated to include UW fonts and branding.
Previous Format
New Format
Sea Pay Added to Current Format Budgets
Proposals that include Sea Pay costs can now use SAGE Budget.
Steps to add Sea Pay to a budget:
Turn on Sea Pay using the toggle in worksheet settings.
Note: With Sea Pay enabled, additional fields will display in the personnel side panel for each period.
Enter the person’s hours of Sea Pay for each period. SAGE Budget will calculate the amount of Sea Pay using the hourly benefit rate for (01-86).
Note: The Sea Pay Benefit Rate is editable. When a custom Sea Pay Benefit Rate is entered, SAGE Budget will use it to calculate the Sea Pay benefits.
When both APL and Sea Pay are enabled in the worksheet settings, SAGE budget will use the APL 01-86 hourly benefit rate (instead of the standard APL benefit and leave rates) to calculate Sea Pay benefits.
When Sea Pay costs are added to a personnel cost, an “anchor” icon displays next to the person’s name.
When the budget is connected to an eGC1, Sea Pay costs will appear on the eGC1 Budget & Fiscal Compliance page. For a Grant Runner eGC1, they will appear on the RR Detailed Budget.
Proposal Budgets that Include APL Fixed Fee Can Now Use SAGE Budget
Fixed Fee costs can be added to primary, internal, and fabrication worksheets and display as 19-40 costs on that worksheet. Fixed Fee costs can also be charged against subaward worksheets.
Steps to add Fixed Fee to a worksheet:
Navigate to the worksheet’s settings. When APL is turned on, the Fixed Fee toggle will display. By enabling the Fixed Fee toggle you can select your Fixed Fee Base type and customize the Fixed Fee rate.
Select one of the standard Fixed Fee base types or customize the base.
When Custom is selected, a modal opens allowing you to select the object codes you want to include in the Fixed Fee base. Expanding each object code offers you the ability to select or deselect sub-object codes.
On Subaward worksheets, Fixed Fee can be charged against the subrecipient’s costs.
To do so, enable Fixed Fee on the primary worksheet, and ensure 03-62 (outside services – subcontract) is included in the Fixed Fee base type. The Subaward worksheet settings will display the Fixed Fee rate and base type, read-only. Fixed Fee will be calculated on 03-62 lines items on the primary worksheet and on any subaward worksheets.
The Fixed Fee amount for a primary, internal, or fabrication worksheet is displayed in the Worksheet Totals.
The Fixed Fee total and amount for each worksheet is also displayed in the Project Totals within the Budget Summary.
Note: Fixed Fee is not part of a subrecipient’s cost to UW and will not appear in a subaward worksheet’s totals. Instead, you will see the amount of Fixed Fee charged against the subaward worksheet on the budget summary only.
Details on Fixed Fee calculations can be found in the SAGE Budget User Guide by clicking on the (?) icon next to the Fixed Fee toggle in worksheet settings.
Additional SAGE Budget Improvements
A help link to the SAGE Budget User Guide was added to the APL and Sea Pay sections in the worksheet settings.
Users can now see the full description of personnel sub-object codes and the Academic/Summer % effort.
SAGE Wide
SAGE Databases Have Been Updated for Use in RAM Cube
Updates have been made to productionize the data in the Research Administration Management (RAM) cube, enabling improved reporting for the Office of Sponsored Programs.