Two new project types have been added to the eGC1. Users can now select “Cooperative Agreement” or “Other Transaction Authority” (a federal designation) from the list, in addition to the current options.
FIX: Sponsor Deadline warning displays when it should not
SAGE and SPAERC users were seeing a sponsor deadline warning message in cases where the deadline had not exceeded our internal due date, causing confusion. The issue was occurring due to time zone differences between east and west coast, and has now been resolved to disregard time of day when comparing the dates.
Update to Read-Only Non-Fiscal Compliance Page for EHS-1 and D-1
In a prior release, an update was made to the Non-Fiscal Compliance page of the eGC1, in order to display the full list of options a user was asked to choose from when responding to the Environment Health and Safety and Data and Technology questions. The display caused confusion for users and has now been updated with a more intuitive presentation of the responses, for added clarity.
Removal of Grant Runner attachment validation for spaces in file name
An old Grant Runner validation disallowing spaces in file names has been removed, to align with NIH current rules for file naming conventions. For details on all allowable characters, see the eGC1 and Grant Runner Attachments article.
Validation Update for Grant Runner
A validation has been added to Grant Runner, to indicate that the RR Research Plan attachment “Program Report Publication List” is required for Renewal applications. This coincides with a recent NIH update of the same.
Applicant PI Added to Email Notifications – Part 2
When an Applicant PI is identified in the personnel listing of an eGC1, that individual will now receive all priority notifications that the primary PI receives. This work was divided across two releases due to the volume of updates to be made, and work is now completed.
SAGE Suite-Wide
Caching Updates to Improve Releases
In the past, certain types of system updates would require the user’s cache to be reset before the change would be visible or to prevent unexpected behavior. The cache was automatically reset every 24 hours, but at times caused help desk calls the day after a release. Technical improvements have been made across the SAGE Suite that will no longer require users to clear cache to see certain changes.
SAGE Budget
FIX: Error on selection of staff with no salary or effort in Workday
An update has been made so that staff with no salary or effort in Workday will still be selectable in SAGE Budget, with a default of 0 in both salary and FTE fields. The user can manually update both salary and FTE as necessary, to project future salary for the individual.
FIX: Excluding Compensation Allocations with Earning Codes
Some personnel with special earning codes related to APL work were flowing through to SAGE Budget with multiple distribution rows, all at 100%. An update has been made to filter out these special APL Workday entries, so that the appropriate Institutional Base Salary is represented in SAGE Budget.
FIX: $25k cap for Subawards incorrectly applied to TDC budgets
For budgets using the base type Total Direct Costs (TDC), when an 03-62 subcontract expense was entered as a line item on the parent budget (and not as its own sub budget), the $25k cap on amount subject to F&A for subawards was incorrectly being applied. The total amount subject to F&A for the 03-62 line item was also showing an incorrect figure. Neither issue occurred when using sub budgets for subaward expenses. These issues have now been fixed.
SPAERC & SERA
Updates to Post-Award Change (PAC)
In order to improve the data quality, reporting, and analytics around award data, the following changes have been made to the Post-Award Change in SPAERC and SERA:
Addition of Revised Start Date field, displayed for the PAC Requested Change type “Start Date Change”
Addition of Revised End Date field, displayed for PAC Requested Change types “Extension”, “Early Termination”, or “Relinquishment”
Addition of Temporary End Date field, displayed for PAC Requested Change type “Temporary Budget Extension” (formerly called “Advanced Extension”)
Addition of Modification Number field
Addition of Originating Sponsor Award Number field, which will pre-populate from the parent FA data, when present.
Updates to PAC Notification PDF
The above new PAC fields will also be displayed on the PDF attachment that is sent to campus when a PAC has been processed.
Updates to Pending Actions Report
The above new PAC fields are also included on the GCA Pending Actions Report
PAC Requested Change Type Updates
The following changes have been made to existing PAC types:
“Advanced Extension” is now relabeled as “Temporary Budget Extension”
“Significant Financial Interest” has been removed
“Create Program Income” has been removed
“Change of Award” has been removed
“Change in Authorized Action” has been removed
The removed PAC Requested Change types will continue to display on historical PACs.
Update to Cycle View of PAC Data
When in the SPAERC or SERA Cycle view, the PAC row will now display the new Revised Start Date, Revised End Date, and Temporary End Date fields when populated.
The validation message that appears when the Intellectual Property Provisions question is not answered will now match the current question label, for added clarity.
SERA only: Future budget biennium selection removed
The Budget Biennium field, updated by GCA in many of the items in SERA, will no longer show future biennium dates for selection. This change will help prevent erroneous biennium selections.
SPAERC only: Grant Runner Submit no longer displays timeout error
Upon submission of Grant Runner applications in SPAERC, the system was displaying time-out errors that were misleading and likely to cause unnecessary alarm or confusion. The error tracking has been updated to improve the quality of the messages received by OSP on submission.
SPAERC only: Activity Locations Page Expanded by Default
The eGC1 Activity Locations page in SPAERC will now display as expanded by default, for easier viewing of relevant data without additional clicks.
AUMS
Automation of AUMS Renewal Reminders
In order to streamline processes for the Office of Animal Welfare (OAW) and Environmental Health & Safety (EH&S), the renewal reminders for AUMS screening will now be system-generated. The email notifications will be delivered as follows: For existing AUMS applicants who are still working with animals or whose animal exposure status is unknown, reminder emails will be sent on the following cycles, unless a new application is submitted prior:
35 days prior to renewal date (to applicant only)
7 days prior to renewal date (to applicant only)
1 day past renewal date (to applicant and their supervisor, when the applicant is an active employee.)
Applicants who are former staff, now inactive in Workday, will also receive the reminder notifications, since these individuals may continue to work with animals either on a voluntary basis or through an affiliation with the UW.
If the applicant no longer works with animals, the email will direct them to change their animal exposure status accordingly. (See next entry). When their animal exposure status is marked as “Inactive. No further work with or around animals”, no more reminders will be sent.
AUMS Status for No Further Work with Animals
The AUMS Profile now includes a field to indicate Animal Exposure Status. This will allow existing applicants to communicate to EHS & OAW that they no longer work with animals, or are again working with animals. When the exposure status is set to “Inactive. No further work with or around animals”, the individual will no longer receive any renewal reminders.
Profile History Display in AUMS OHN Module
When an AUMS applicant changes their animal exposure status in any way, the AUMS system will log the change, and the history of changes will be visible to the Occupational Health Nurses in EH&S and other authorized AUMS administrators. This will provide a helpful trail of when exposure status has changed for an applicant.
AUMS Ergonomic Questions now trigger “Consult Required” Review Action automatically
When an applicant has responded in the affirmative on any of the ergonomics questions on the AUMS questionnaire, the application’s Review Action will be automatically set to “Consult Required” to ensure an occupational health nurse reviews the application appropriately.
FIX: Can’t update AUMS Supervisor
An issue preventing the changing of an applicant’s supervisor in both the AUMS Applicant and OHN modules has been resolved.
FIDS
SFI Entity Type update
A change has been made to the Entity Type field when users are adding or updating SFI in FIDS. The “Foreign Government” entity type is now relabeled as “Foreign Government/Institution of Higher Ed” to better align with NIH disclosure requirements.
FIDS Reviewer: Update to Related Sponsored Research display
To better assist FIDS reviewers in monitoring compliance, a change has been made to the display of Related Sponsored Research (eGC1s). For eGC1’s that are in “Awarded” status the system will now show the most current and relevant related eGC1s based on the end date of the Funding Action instead of the end date of the eGC1. This will mitigate the accidental omissions of eGC1s whose anticipated start and end dates differ greatly from the Funding Action start and end dates.
For additional helpful context, the start and end dates of eGC1s will display in the list, when the eGC1 has not yet been awarded. Once awarded, then the Funding Action start and end dates will display in the list, along with the FA Number for reference.
MyResearch Integrations
SAGE Data Integrations with MyResearch
The following SAGE data was added to a web service to enable MyResearch future work.
eGC1 data needed for Current and Pending Support generation
New PAC fields mentioned above, for use in Award View
Carryover funding action field and new PAC fields in the SAGE web service will also enable GCA automation of award setup and changes in the financial system
In order to give reviewers/approvers better visibility to the application’s sponsor deadline, the deadline now appears on the Approval Graph in the Application Details section.
PI Assurance Statement Updated with Multiple PI Guidance
The Assurance Statement for Principal Investigators on eGC1s has been updated to include a statement guiding them on their responsibilities for ensuring Multiple PIs from external organizations provide proper assurance, in compliance with federal regulations. The newly included verbiage reads as follows, and is visible on the Certify and Route page when the PI is logged in, and on their approval page when they have not yet noted their assurance:
If this is a multiple PI application, I understand that if I am the eGC1 PI, my approval of the eGC1 indicates I have obtained written assurances from external PIs named in this application that include this Non-UW Multiple PI Assurance Statement.
Application PI Added to Priority Email Notifications
When an eGC1 contains personnel with the Application PI role, the Application PI will now receive the following email notifications to ensure they are alerted to important changes:
Final Sponsor Documents Required for eGC1 – reminder email for deadlines sent if eGC1 has not been marked “Ready to Submit”
eGC1 Returned by Reviewer (campus reviewer) – to inform owners their submitted eGC1 has been returned by a campus reviewer
eGC1 Returned by Reviewer (OSP) – to inform owners their submitted eGC1 has been returned by OSP
eGC1 Received at OSP – eGC1 has reached OSP and will begin the central review process; includes OSP assignment
Application Review Notice (auto generated by OSP) – generated after central review and includes OSP review comments
Requested Documents Ready for Pickup – signed and scanned documents are uploadable to an application and are ready for pickup
FCOI Just-In-Time notification – to indicate eGC1 has reached JIT
Funding Action email w/Funding Action pdf attached
Post Award Change email w/PAC pdf attached
FIX: Non-UW authorized SAGE users cannot create new eGC1
Non-UW SAGE users, such as partners as SCCA or Fred Hutch, were receiving errors when attempting to initiate new eGC1s. The system restriction has been updated, so that all persons with a valid UW NetID and an appropriate SAGE Astra Role can perform their SAGE duties as expected.
FIX: Common Interdisciplinary Org Unit Reviewer checkboxes can’t be unchecked
An issue was resolved where eGC1 preparers who had previously checked one of the Interdisciplinary Organizational Unit Reviewers to add to the approval graph, and then later wanted to uncheck the unit, were unable to do so. Users can now check and uncheck as necessary before completing the eGC1.
FIX: Activity Locations without an address display blank in summary table
In the case where a location sourced from the GeoSims database does not have an address, the summary table on the Activity Locations page will now show the test “Not Provided” for consistency and clarity.
FIX: Editing Activity Locations or International Involvement sections in Firefox causes page to freeze
An issue with Firefox and locking/freezing of the Activity Locations page on edit has been resolved.
SAGE Budget
SAGE Budget Updates to Workday Salary Data Displayed for Personnel
In order to clean up and clarify the salary distribution data presented to SAGE Budget users, the following updates were made:
Make Institutional Base Salary more easily configurable in SAGE and update existing rules
SAGE Budget can now be more easily updated when new Compensation Plans are added to Workday. This will ensure salaries in SAGE Budget reflect each person’s Institutional Base Salary. This release also brings SAGE Budget up to date with the Compensation Plans currently in Workday.
Distribution % for Administrative and Endowed Supplements no longer factor in FTE
Administrative and Endowed Supplements will now show the Distribution % direct from Workday. Previously, these Compensation Plans used the same Distribution % calculation as General Salary, which incorrectly reduced the total pay for people with supplements tied to part-time positions.
Administrative and Endowed Supplements now included for Non-Faculty Personnel
SAGE Budget will now include Administrative and Endowed Supplements in Institutional Base Salary for any UW personnel who have them. Previously, these Compensation Plans were only included for faculty.
Other Minor SAGE Budget Fixes
The following SAGE Budget issues are now resolved:
FIX: 07 Retirement Benefit percent does not update when changing personnel from APL to non-APL
FIX: The Update (Benefit) Rate button in personnel salary and benefits by period does not work
FIX: 01-70 Changing between exemption rate settings for 01-70 staff does not result in refreshed benefits rates for individual personnel entries
SAGE Grant Runner
Populate SF424 Federal Agency from the Opportunity Data
The SF424 Grant Runner sponsor form will now default in the Federal Agency from the opportunity information retrieved from Grants.Gov, instead of the sponsor listed on the eGC1. This will improve accuracy on the Grant Runner form and reduce the risk of issues at the time of submission.
FIX: Error on History & Comments page for Grant Runner eGC1s (Released via patch on 6/19/19)
An issue has been resolved that was causing an error for users when they would navigate to the History and Comments section of the Approvals tab for an eGC1.
The SAGE team is focusing in 2019 on expanding and improving SAGE Budget capabilities, and streamlining proposal budgeting processes. This release includes several high-value features that were identified by budget preparers across campus who responded to a budget-focused survey and subsequent focus groups.
SAGE Budget
New Salary Cap Feature
In SAGE Budget you can now indicate when the sponsor has a salary cap, allowing you to set a custom salary cap value from the newly-renamed Targets & Caps tab.
From the worksheet, you’ll be able to see what the cap is, and which personnel exceed it.
When you open the details for individual personnel, you’ll see their total uncapped salary in addition to their capped total for improved transparency.
Improved Visibility to Salary and Benefit Totals
When updating the period details for personnel, you’ll now have better visibility to Period Salary Totals, Period Benefits Totals, and for the first time, visibility to the combined Salary & Benefit Total. This will make it easier to copy this total into sponsor budget forms, while also improving the layout to reduce scrolling. (See “Total Salary + Benefits” in image above)
New Summer Tuition Amount Field
To make it easier and more transparent to budget for summer tuition (the rate which normally differs from other academic quarters), you’ll now be able to enter a discrete Summer Tuition Amount for personnel with student sub-object codes. You’ll also be able to enter a Summer Tuition Amount for stand-alone tuition lines in the 08 object code.
Copy Budget Improvements
Copying SAGE budgets and sub-budgets will now prompt you to update the Title of the new budget, and after confirmation will open the new budget in a new browser tab. This will make it more intuitive for you to identify the new budget from the original when copying.
Streamlined and More Accessible Expense Entry
Keyboard and mouse navigation in the expense entry screens has been improved to make the experience more intuitive and accessible. This will reduce the amount of time to enter expenses for users who navigate using keyboard or mouse.
General SAGE Suite Maintenance Items
SAGE
Activity Locations Entry Updated for Consistent Experience
The eGC1 Activity Locations page has been updated to make the entry of locations mirror the experience found on the Non-Fiscal Compliance page when entering Human and Animal protocols. This will make the entry experience more intuitive and the system more maintainable.
Improved eGC1 Performance
Testing of SAGE response time revealed that the Details and PI, Personnel & Organizations pages were slower than other parts of the eGC1. Those pages have been updated to drastically improve performance, allowing you to navigate with less waiting.
Compliance Question E-2 Has Been Updated
Non-Fiscal Compliance question E-2, concerning export of hardware, equipment, specimens, etc. has been updated to clarify that you do not need to report personal use laptops.
Fix: Country Field Displaying for Manually Entered Animal Use Institutions and Activity Locations
An issue causing the Country field to not display for manually entered Animal Use Institutions and Activity Locations has been resolved.
SAGE Grant Runner
New Grant Runner Warning for Expired NIH Funding Opportunities
When using Grant Runner, you’ll now see a warning at the top of the Check for Errors pop-up if you choose an NIH funding opportunity that closes prior to the Sponsor Deadline on the eGC1 Details page. This will provide you with transparency to the conflict, but will not prevent you from routing the eGC1.
Improved Usability for Country & State Entry on Grant Runner Forms
The Key Persons Expanded and Performance Sites forms on Grant Runner eGC1s have been updated to provide a more intuitive experience when entering Country and State. This also resolves an issue that could result in the State not saving.
Submission deadline warning notification no longer sent for RRF eGC1s
Principal Investigators and Preparers of eGC1s to the Royalty Research Fund (RRF) will no longer receive the automated email sent from SAGE 3-6 days prior to the Sponsor Deadline when the proposal is marked as not ready for submission. This notification was not applicable to RRF proposals and caused confusion.
SAGE Budget
Add links to connected eGC1s and Budgets on SAGE task lists
When an eGC1 is connected to a SAGE Budget, links between the two will now display on the My eGC1s and My Budgets task lists, making it quicker and easier to navigate between the two.
Prefix and/or Suffix fields added for personnel in SAGE Budget
Users can now enter a Prefix and/or Suffix for personnel in SAGE Budget. These will display on the Budget worksheet, and when using the Grant Runner Budget Sync feature will flow directly to the NIH RR Detailed Budget form on the connected eGC1. This ensures personnel will display on the sponsor form with their preferred titles/credentials.
Budget Sync performance improvements
The new Grant Runner Budget Sync feature has been optimized to now perform faster, allowing users to complete their proposals more quickly.
SAGE Grant Runner
Allow Grant Runner eGC1s to route with Grants.gov and NIH errors
The Certify & Route page of the eGC1 has been updated to make routing choices more clear and intuitive.
Additionally, when using a Grant Runner eGC1, as long as the eGC1 is marked “Ready to Submit” = No, users will now be allowed to route their eGC1s for review while there are still outstanding NIH and Grants.gov errors.
A new warning displays on Certify & Route page when there are grants.gov and/or NIH errors:
SPAERC
Add Award Modification Number to Cycle View
The Cycle view in SPAERC has been updated to include a “Mod Nbr” column to reflect Award Modification Numbers on Funding Actions and Modification Numbers on Subaward Actions.
Changes to Defaulting Behavior on Funding Actions
Defaulting logic for the Disposition and Carryover fields on Funding Actions has been revised to improve data accuracy.
If Payment type is changed to Cost Reimbursable from another value, then the Disposition of Balance field is reset to “Not Applicable”
If Payment type is changed to Letter of Credit from another value, then the Disposition of Balance field is reset to “Not Applicable”
If Sponsor is changed to Royalty Research Fund (RRF) from another value, then
Disposition of Balance field is reset to “Return to Sponsor”
Carryover is reset to “Automatic Carryover”
If SNAP is checked after a value is already set in the Carryover field, then the Carryover value is reset to “Automatic Carryover”
OSP Team C assignment updates
The rules that govern who the default OSP reviewer will be for eGC1s that have been routed for review have been updated to facilitate the appropriate eGC1s being assigned to OSP’s new Contracts Team. eGC1s will be assigned to the Team C Administrator under the following conditions:
Application Type = Non-Award Agreement (new) or Non-Award Agreement (continuation)
After the Fact (ATF) is marked “Yes” and the Sponsor Type is “Private Industry” or “Foreign Private Industry”
SERA
Add validation in SERA for missing short title
The Short Title on Funding Actions is now required in SERA prior to save in order to resolve an error that occurred when the Short Title was saved blank.
The SAGE team will be focusing the next six months on expanding and improving SAGE Budget capabilities, and streamlining proposal budgeting processes. This is the initial release in a series of SAGE Budget improvements to come in 2019.
SAGE Budget Rounding Changes
The SAGE Budget approach to rounding has been changed to better match user expectations and needs. These changes will facilitate accurate integration of budget data into sponsor budget forms when using the new Budget Sync feature.
Context:
Historically, SAGE Budget has used display-only rounding for individual expense items, and banker’s rounding for totals.
Display-only rounding is the equivalent of using the decimal display setting in Excel versus the round() formula. With display-only rounding, you may see a $5 on screen, but the stored value may really be $4.60. This can be confusing for users when viewing totals of display-rounded numbers.
For example, you might see:
$5 + $5 = $9 when the underlying values are $4.6 + $4.6 = $9.2 (rounded to $9)
The old display-only approach to rounding also resulted in an inability to fully reconcile SAGE Budget numbers to sponsor budget formats, where sponsor budgets require whole dollar entries.
Key Rounding Changes:
Display-only rounding of expenses will no longer be used in SAGE Budget. Rounding is now applied to each expense individually, not just to budget sum totals.
Budget sub-totals and totals now display the sum of the rounded expense totals.
Banker’s rounding has been replaced by Rounding Up approach on tie break. (Example: When rounding to whole dollars, $2.50 will now round up to $3, instead of down to $2.)
Users now have the choice to round to whole dollars or to cents (new!) or to not round.
When Grant Runner Budget Sync feature is used, the rounded values will flow to the RR Detailed Budget with 100% accuracy.
These changes to rounding in SAGE Budget will result in a clearer, more intuitive approach to display of rounded values that accurately matches sponsor budgets that require whole dollars entry.
Important Note for Existing Budgets:
Existing budgets set to whole dollar rounding at time of go-live will be migrated to the following settings:
Rounding is changed to Do Not Round
Decimals display is changed to 0
Banker’s rounding is used on tie
These settings will maintain the integrity of historical budgets and to allow users to make intentional decisions on whether to apply the new rounding methodology to active budgets.
When you Copy a budget with the above legacy settings, the new budget (and any child sub budgets) will automatically convert to the new rounding settings.
Converting Existing Budgets to New Round Approach:
To convert your existing budget to the new rounding approach, go to the Properties tab of your main worksheet, and select the appropriate rounding option.
When you change the rounding settings in the Properties for your parent budget, all sub-budgets will inherit that same rounding setting as well.
SAGE Budget: Period Updates Screen Improvements
Dynamic Update of Expense Totals
Users will no longer need to manually SAVE between changes to expenses to see the sub-total and totals update. Entry of personnel and other expenses will trigger a recalculation and refresh of the expense totals upon navigating away from the field where the entry occurred.
SAGE Budget: Properties and Settings Improvements
To improve the usability of the Properties and Advanced Settings pages, the following adjustments have been made:
Properties Tab Changes
The Properties page has been streamlined to combine what was formerly the Advanced Properties onto the main Properties page, for added visibility and convenience
New section headings add clarity to the choices available
New help text guides users when making selections
The same above changes have been applied to the Properties portion of the Budget Setup Wizard
The Properties page now has improved keyboard accessibility
As mentioned in the Rounding section above, the rounding setting now includes an additional option to round to Cents, in addition to Whole Dollar and No Rounding options.
Targets and Limits Tab Changes
Users will now enable Targets and Limits from the Targets and Limits tab.
The Budget Setup Wizard no longer includes the Enable Targets and Limits question, and will instead be enabled from the Targets and Limits tab upon completion of the wizard setup.
General SAGE Suite Maintenance Items
SAGE eGC1
Discontinuation of Human Subjects Just In Time Reminder Email
The email notification sent from SAGE to PIs and Administrators at Just in Time when human subjects is marked as YES on the eGC1, has been discontinued. Campus feedback indicated that this email often caused confusion, since it was not an official notice of action from the sponsor, and that the reminder was not helpful to their processes.
Fix: Display of Activity Locations and Non-Fiscal Compliance Page
The Activity Locations and Non-Fiscal Compliance pages were displaying beyond the right border for Internet Explorer users, causing read-only users in SAGE to be unable to access certain expand/collapse controls on the page. The issue has been resolved.
SAGE Budget
Update to APL Manual Entries in SAGE Budget
SAGE Budget has been updated to clarify to which APL expenses can be manually entered (sub-object codes 19-00 and 19-20) and which are based on the APL setting on the Properties tab (sub-object codes 19-10 and 19-40).
SAGE Grant Runner
Fix: Cognizant Federal Agency POC Field Display – RR Subaward Budget
An issue with display of the Cognizant Federal Agency POC field on the RR Subaward Budget form has been resolved. The saved data is now displaying as expected on the Grant Runner form.
Link to Sponsor Budget Map from RR Detailed Budget
Users will now see a convenient link to the Sponsor Budget Map page from the header of the RR Detailed Budget page, when using Budget Sync. This will serve as a helpful reminder to users that this new page exists and may need actions on their part to fully sync data from SAGE Budget to the RR Detailed Budget.
AUMS
Clearance Email and PDF Attachment Updates
The clearance email, sent from the AUMS system, has been updated to clarify contact and other helpful information for recipients.
FIDS
Fix: Update to Display of SFI Percent Ownership in Reviewer Module
The SFI Percent Ownership has been updated to address a display issue caused by a rounding setting in the FIDS reviewer module.
Sync SAGE Budget to Grant Runner RR Detailed Budget
eGC1 preparers using Grant Runner now have a new feature that allows them to sync a connected SAGE Budget to the NIH RR Detailed Budget. This capability provides a more streamlined experience for preparers by reducing redundant entry. It also eliminates the need for reviewers to cross check the various parts of the application where budget data is stored.
Highlights
Personnel and expense data flows directly from SAGE Budget to RR Detailed Budget, when connected.
When updates are made to a connected SAGE Budget the changes will automatically flow to the RR Detailed budget.
On the new Sponsor Budget Map page on the left navigation, the following actions can be taken:
View or change the default flow of data from SAGE Budget to the RR Detailed Budget
Define custom personnel roles and custom categories for other direct costs
Customize the order of Personnel with an easy drag & drop feature
Identify Participant Support Costs, and associated numbers of participants
When users disconnect a SAGE Budget they have the option to keep or clear the data in the eGC1 budget page and the RR Detailed Budget.
What to expect
Connecting your SAGE Budget to a Grant Runner eGC1 with an RR Detailed Budget form triggers the two budgets to sync. When the sync occurs a new Sponsor Budget Map page displays on the left navigation menu and the RR Detailed Budget form becomes read-only. Changes to where the data flows to on the RR Detailed Budget can be made on the Sponsor Budget Map page. Additions and deletions of expenses or changes to expense amounts will be made on the SAGE Budget. The Budget Justification attachment will still be attached on the RR Detailed Budget directly.
Finance & Administrative (F&A) flows to section H. Indirect Costs on the RR Detailed Budget with one row per distinct F&A rate and base type combination.
The Sponsor Budget Map displays how data flows from SAGE Budget to RR Detailed Budget. SAGE Budget expense items are grouped into sections by Object code. Within each section they are ordered by sub-object code. SAGE Budget data is displayed on the left side of the page. The RR Detailed Budget expense category to which the expense will flow is shown on the right side.
Reorder Personnel. Use the drag and drop functionality in the Salaries and Wages section of the Sponsor Budget Map page for easy reordering of Senior/Key personnel.
Define Custom Personnel Roles. Drop-down menus allow for remapping to several default personnel project roles or you can create a custom role.
Change Defaulted Data Flow. Many expense categories can be changed to flow the data from SAGE Budget to an alternate category on the RR Detailed Budget. Use the drop-down menus at right to specify any changes to the flow.
SAGE Budget Changes (Enablers)
The following changes were made to SAGE Budget, in order to fully meet the data needs of the RR Detailed Budget.
Application PI Role Added. Users will now see the Application PI role available in the personnel section of SAGE Budget. Personnel assigned to the role Application PI on the SAGE Budget will flow through to the RR Detailed Budget as the Principal Investigator (PD/PI). If the SAGE Budget had a PI listed in addition to the Application PI, the PI will flow to the RR Detailed Budget under the role of Faculty, and that role can be modified on the Sponsor Budget Map if necessary.
Additional Role Updates. The Fellow role is no longer available in SAGE budget. , iInstead new roles have been added to match those in the RR Detailed Budget. The new roles include: Faculty, Post Doctoral Associate, Graduate Student, Undergraduate Student, Secretarial/Clerical.
TBD & Non-UW Personnel: Monthly Salaries Now Editable. In order to identify Base Salary on the RR Detailed budget for TBD and Non-UW Personnel, the UW Monthly Salary and Clinical Monthly Salary fields are now editable in the SAGE Budget personnel entry section (for TBD and Non-UW Personnel entries only).
Travel Destination Logic Modified. In order to improve data quality and reduce the need for adjustments to the budget, the travel destination (domestic or foreign) will now default based on the sub-object code chosen by the user. If “foreign” is explicitly referenced in the sub-object code name, then “foreign” will become the defaulted destination location. Users can adjust the destination as needed for sub-objects codes that could apply to either.
Sub-Object Codes added. A detailed analysis comparing sub-objects codes between the Finance System and & Sage was completed, and the missing object codes were added to SAGE Budget to keep the two systems synchronized.
eGC1 Updates
Improved Error Messages. Validation messages on the RR Detailed Budget have been improved to now include the specific period and section that requires the user’s attention.
Validation Icons Added. The Sponsor Budget Map has the same validation icons as the rest of Grant Runner. If there are unmapped items on the Sponsor Budget Map the user will see red exclamation points on the individual sections to indicate which section needs their attention. Once in the section the field in question is highlighted red. When the mapping issue has been resolved, the validation icon will turn to a green checkmark.
Help Documentation and Resources
The SAGE User Guide has been updated with detailed instructions for the Budget Sync feature. Users can access it by clicking on the help icon (?) on the Sponsor Budget Map page and on the RR Detailed Budget form. SAGE 102 courses will also include a section on the Budget Sync feature and using the Sponsor Budget Map.
You can use the Sponsor Budget Map page to understand how your SAGE Budget personnel data will initially flow to the RR Detailed Budget form.
In the (01) Salary and Wages section on the Sponsor Budget Map page, you will see one row for each person on your parent budget and any internal sub budgets.
Based on the Project Role you selected for each person in SAGE Budget, each person will map to either the RR Detailed Budget Section A. Senior/Key Person or Section B. Other Personnel.
The columns in this section of the Sponsor Budget Map are:
From SAGE Budget: displaying its Expense Type and Project Role
To RR Detailed Budget: displaying its Category and Project Role
Personnel Order: displaying the relative position in the Section A list for this person. Note: this column is unique to the 01 section.
Initially, you will see the personnel listed in the same Project Role order as on your SAGE Budget. Any personnel from internal sub budgets will display just after those on the parent budget, within each role.
You can adjust the default RR Detailed Budget Project Roles, except for the person who is the PD/PI. In some cases, you can change the default RR Detailed Budget Category (Section A or B).
Optionally, you can change the Personnel Order for those mapped to the RR Detailed Budget Section A by using the “Drag to Re-Order” feature (described below).
For personnel in Section B, in addition to the four default Project Roles, you can create customized ones.
Section A. Senior/Key Persons
When you first view the Sponsor Budget Map page, you will see the personnel listed in the same Project Role order as on your SAGE Budget. Any personnel from internal sub budgets will display just after those from the parent budget, within each role.
Mapping Rules
The following table defines the initial mapping rules and indicates whether the default value can be edited (changed).
SAGE Budget Project Role
RR Detailed Budget Project Role
Can the Role Be Edited?
Principal Investigator
PD/PI; if there is also an Applicant PI, then this role defaults to Faculty
Only if “Faculty” role
Application PI
PD/PI
No
Co-Investigator
Co-Investigator
No
Multiple PI
PD/PI
No
Key Personnel
Depends on the 01 sub-object code selected; defined below
Yes
Mentor
Faculty
Yes. Note: You can map this person to Section B, if appropriate
Faculty
Faculty
No
If you selected Key Personnel for someone’s project role on your SAGE Budget, their sub-object code will determine the default role on the RR Detailed Budget.
01 Sub-Object Codes
Project Role on Detailed Budget
10-14 Instruction & Research Faculty
Co-Investigator
20-24 Auxiliary Teaching Staff
Other Professional
30-34 Graduate School Student Appointments – Teaching
Graduate Student
40-44 Graduate School Student Appointments – Non-Teaching
Graduate Student
50-54 Postdoctoral Research Trainee
Post Doctoral Associates
60-64 Classified Staff
Other Professional
70-74 Professional Staff
Other Professional
80-87 Temporary Staff
Other Professional
88-89 Hourly
Undergraduate Students
90-94 Graduate Stipends
Graduate Students
As needed, you can change the role. Project Role choices for the RR Detailed Budget form are:
Co-PD/PI
Faculty
Post Doctoral
Post Doctoral Associates
Post Doctoral Scholar
Other Professional
Graduate Students
Undergraduate Students
Technician
Consultant
Co-Investigator
Drag to Re-Order Feature
You can use this feature to adjust the order of the personnel mapped to Section A of the RR Detailed Budget. The Personnel Order column displays the text “RR Detailed Budget Position” followed by a number, indicating that person’s place in the order.
The Application PI (if present) will display on the first row. If your budget does not include an Application PI, then the Principal Investigator will be listed first.
After the PD/PI or Application PI (if present), the default order of the personnel entries is by Category (Section A or B) and, within each category, by Project Role with Parent Budget and Sub-Budget personnel grouped together. For example:
Multiple PI (parent)
Multiple PI (sub budget)
Co-Investigator (parent)
Co-Investigator (sub-budget)
Key Personnel (parent)
Key Personnel (sub-budget)
You can use your mouse, or the keyboard, to choose a person’s row to re-order. Move the row up or down to update the position number for that person. Note that the form can list up to eight individuals. Any additional personnel are included in the Additional Senior Key Persons attachment, described below. The PD/PI must be one of the initial eight people listed.
Personnel mapped to Section B will have the note “Not applicable” in the Personnel Order column. You can drag them to a different position on the mapping page, but the next time you view the mapping page, the order will have returned to the Section A personnel followed by those mapped to Section B.
Any changes you make on your connected SAGE Budget or the Sponsor Budget Map page will be reflected on the RR Detailed Budget form when you view it. The ordering of Personnel on both the Sponsor Budget Map page and the RR Detailed Budget form will match the last ordered sequence you created and saved on the Sponsor Budget map page. Any newly entered Personnel, after the initial synchronization, will sort to the bottom of the Sponsor Budget Map page order by default.
Additional Senior Key Persons Attachment on RR Detailed Budget
Section A can display up to eight individuals on the RR Detailed Budget form. You must list any additional personnel in an attachment to the form. When you initially connect your SAGE Budget and Grant Runner application, SAGE will automatically generate and attach the PDF file listing any additional personnel. The file will be named to reflect the budget period. For example, the attachment for Period 3 of your budget will be named “Period_3_Personnel.pdf”. In addition, the system will calculate the Total Funds for Attached Persons value and display it.
Any time you add or remove Section A personnel from your SAGE Budget, or change their order on the Sponsor Budget Map page, the PDF attachment will automatically be recreated to reflect those changes, if necessary.
Section B. Other Personnel
Personnel that map to Section B are combined into the appropriate rows, with their data values totaled.
Mapping Rules
If you select one of these SAGE Budget Project Roles, the individual will be added to the corresponding role in Section B:
Post Doctoral Associates
Graduate Students
Undergraduate Students
Secretarial / Clerical
On the Sponsor Budget Map page, you can shift personnel with the Post Doctoral Associate role to the A: Senior/Key Persons section. You cannot edit the other project roles from the Sponsor Budget Map page. You would change them on your SAGE Budget.
If you select Other for someone’s project role on your SAGE Budget, that person’s sub-object code will determine the default role on the RR Detailed Budget.
SAGE Budget Personnel Sub-Object Code
RR Detailed Budget Project Role Default Value
10-14 – Instruction & Research Faculty
Select…
20-24 – Auxiliary Teaching Staff
Select…
30-34 – Graduate School Student Appointments – Teaching
Graduate Students
40-44 – Graduate School Student Appointments – Non-Teaching
Graduate Students
50-54 – Postdoctoral Research Trainee
Post Doctoral Associates
60-64 – Classified Staff
Secretarial / Clerical
70-74 – Professional Staff
Select…
80-87 – Temporary Staff
Select…
88, 89 – Hourly
Undergraduate Students
90-94 – Graduate Stipends
Graduate Students
When “Select…” displays, you can choose one of the four existing Section B roles listed above, or you create up to six different, customized roles.
Create a Customized Personnel Project Role
Click on “Select…” in the drop-down menu and choose “Other…”
A dialog will display where you can enter the customized name of your project role for Section B. Click Save to return to the Sponsor Budget Map page. The new project role will appear, followed by an Edit link.
Once you have added a customized role, it will appear in the drop-down so that you can choose it for additional personnel. If you edit the customized role, your changes will apply to all personnel with that role.
RR Detailed Budget Personnel Data Sources
Section A. Senior/Key Persons
The following table describes the source data for each RR Detailed Budget field in Section A.
RR Detailed Budget Field
Data Source
Name
SAGE Budget: First, Middle and Last Name
Project Role
Sponsor Budget Map: Project Role
Base Salary ($)
SAGE Budget: Line Setup Starting Monthly Salary * 12 (annualized) * the inflation rate for the period
Calendar Months
SAGE Budget: if Calendar is checked on Line Setup; from Update Periods: Person Months
Academic Months
SAGE Budget: if Academic/Summer is checked on Line Setup; from Update Periods: Academic Person Months
Summer Months
SAGE Budget: if Academic/Summer is checked on Line Setup; from Update Periods: Summer Person Months
Requested Salary ($)
SAGE Budget: from Worksheet (01 item) period amount or Update Periods: Period Total Salary
Fringe Benefits ($)
SAGE Budget: from Worksheet (07 item) period amount or Update Periods: Total Benefits
Funds Requested ($)
System calculated: Requested Salary plus Fringe Benefits
Section B. Other Personnel
The source data for each RR Detailed Budget field in Section B is the same as that for Section A. In this section, the values for a given row are a sum of the values for all personnel with that specific Project Role:
Number of Personnel: the total number of personnel with the specific Project Role
Project Role: the first four rows are the fixed project roles; any custom roles you create will appear below these. There is a maximum of 6 custom roles.
Calendar, Academic, Summer Months: the sums of each type of person months for personnel with the specific Project Role.
Requested Salary ($): the sum of all Requested Salaries for personnel with this Project Role
Fringe Benefits ($): the sum of all Total Benefits for personnel with this Project Role
Funds Requested ($): System calculated: Requested Salary plus Fringe Benefits
The Sponsor Budget Map page shows where the expenses from your connected SAGE Budget will flow to on the RR Detailed Budget form.
A link to the Sponsor Budget Map page will appear on the left navigation menu once you connect your SAGE Budget to your Grant Runner application and the RR Detailed Budget form is either mandatory for your opportunity, or you have selected it.
Use the Sponsor Budget Map page when you have expenses that are not mapped to default fields on the RR Detailed Budget form, or you need to adjust the defaults. A red exclamation “validation icon” will display if you need to complete any mappings.
Note: The Sponsor Budget Map page does not show dollar amounts. It shows you how the various expenses on your budget are categorized for the RR Detailed Budget form. For some expenses, you can use the Sponsor Budget Map to change where and how your data displays on the RR Detailed Budget form.
The following image shows the Sponsor Budget Map link on the left navigation menu.
Note: If the budget you connect does not yet contain any expenses (costs), you will see an alert message. It reads “Whoops! You connected a budget with no expenses. Navigate to your SAGE Budget to add expenses.”
The following image shows the message.
Data Synchronization
After the initial connection of your SAGE Budget and Grant Runner application, any data changes you make to your SAGE Budget will be synchronized with both the RR Detailed Budget form and Sponsor Budget Map page. Any changes you make on the Sponsor Budget Map page will be reflected on the RR Detailed Budget form when you view it.
Your data changes will also be reflected in the PDF generated when you select View Grant Runner forms (PDF) on the left navigation menu.
Using the Sponsor Budget Map
The Sponsor Budget Map page initially shows where the SAGE Budget expenses will appear, by default, on the RR Detailed Budget. Where editable, you can choose to shift those expenses to a different category on the RR Detailed Budget. You can also specify the order of the personnel entries for Section A. Senior/Key Persons.
The Map page includes a link to your budget, just above the first section, that displays the budget number and title. For example: “B32836 Guide: Example Budget” as shown in the following image.
Below the link, there is a section for each expense type (object code) on your connected SAGE Budget. By default, the sections are all collapsed when you first view the page. You can “Expand All” sections or just individual ones.
The sections you see will match those where you have entered data in your parent SAGE Budget and any sub budgets. The possible sections are:
(01) Salaries and Wages, which includes the (07) Retirement and Benefits data (this links to a separate article)
SAGE Budget data is displayed on the left side of the page, in the same order as your SAGE Budget. The RR Detailed Budget expense category to which the expense will be mapped is shown on the right side.
Each section will display a status icon to indicate the status of the data within the section. A red exclamation point indicates that there are one or more expenses from your SAGE Budget that you need to map to an RR Detailed Budget category or sub-category. A green check mark indicates that all mappings are resolved. The Participant/Trainee Support Costs section shows a gray check mark icon if one or more of the optional mappings are unresolved.
The following images show examples of each type of status icon: green, red, and gray.
Adjust Expense Categories
You can change a number of SAGE Budget expense categories from the default value to another category on the RR Detailed Budget. Use the drop-down menus in the right-hand column to make changes to the default mapping between SAGE Budget and the RR Detailed Budget form. Some selections are grayed-out to indicate that the SAGE Budget object code cannot be mapped to that selection. For example, Travel costs cannot be assigned to Other Personnel.
Create Customized Categories
For some expenses that map to Section F: Other Direct Costs, there is no default sub-category. You must make a selection. These expenses are:
Supplies & Materials 05-47, 05-48
Student Aid 08-00, 08-02, 08-05
Unallocated 38-00
You can either select one of the existing sub-categories, or create a customized one. You can add up to 10 custom (user defined) sub-categories for Section F. The custom fields will be listed in object code order on the budget form.
Click on “Select…” in the drop-down menu and choose “Other…” You made need to scroll down the list.
A dialog will display where you can enter the customized name of your sub-category. Click Save to return to the Map page. The new sub-category will appear, followed by an Edit link.
Once you have added a customized sub-category, it will appear in the drop-down so that you can choose it for additional expenses. If you edit the name of your customized sub-category, all items you associated with that sub-category will be updated.
Participant Support Costs
You can change some SAGE Budget expense items from the default mapping value to Section E. Participant/Trainee Support Costs.
Note: If you have any Participant Support Costs, you must use the section at the end of the Sponsor Budget Map page to indicate the associated numbers of participants for those budget periods.
By default, the expenses for this object code, on a parent budget or internal sub budget, will map to Section F. Other Direct Costs, subcategory Consultant Services.
You can change the RR Detailed Budget Category to either D. Travel, or E. Participant/Trainee Support Costs.
Within this category you can select the appropriate subcategory for your expense item.
(03) Other Contractual Services
By default, the expenses for this object code, on a parent budget or internal sub budget, will map to Section F. Other Direct Costs. The default subcategory depends on the SAGE Budget sub-object code for the expense. Consult the table below.
Generally, you can change the RR Detailed Budget Category to either D. Travel, or E. Participant/Trainee Support Costs. The exception is an 03-62 expense, a subcontract sub budget. You cannot change its mapping.
By default, the expenses for the (04) Travel object code, on a parent or internal sub budget, will map to Section D. Travel on the RR Detailed Budget form. The expense will map to either Domestic Travel Cost or Foreign Travel Cost, depending on your SAGE Budget Destination choice.
You can change the RR Detailed Budget Category to E. Participant/Trainee Support Costs. The subcategory will default to Travel.
(05) Supplies & Materials
By default, the expenses for this object code, on a parent budget or internal sub budget, will map to Section F. Other Direct Costs, with the subcategory of Materials Supplies.
You can change the RR Detailed Budget Category to E. Participant/Trainee Support Costs, except for sub-object codes 47 and 48 “Non-Capitalized Equipment”.
Within the category you can select the appropriate subcategory for your expense item.
(06) Equipment
The expenses for this object code, on a parent budget or internal sub budget, will map to Section C. Equipment, and you cannot change the mapping.
Additional Equipment Items Attachment
Section C. Equipment on the RR Detailed Budget form can display up to ten items. Any additional items must be included in an attachment to the form. When you initially connect your SAGE Budget and Grant Runner application, SAGE will automatically generate and attach the PDF file listing any additional equipment items, as needed. The file will be named to reflect the budget period. For example, the attachment for Period 3 of your budget will be named “Period_3_Equipment.pdf”.
Any time you add or remove equipment items from your SAGE Budget, the PDF attachment will automatically be recreated (or removed) to reflect those changes, as needed.
(08) Student Aid
By default, the expenses for this object code, on a parent budget or internal sub budget, will map to Section F. Other Direct Costs. You will need to select a sub-category on the Sponsor Budget Map page, or create a custom one.
(10) Capital Projects
The expenses for this object code, on a parent budget or internal sub budget, will map to Section F. Alterations and Renovations, and you cannot change the mapping.
(19) APL
The expenses for APL Prorated Direct Costs (PDC), on a parent or internal sub budget, will map to Section H. Indirect Costs
The non-PDC expenses will map to section F: Other DIrect Costs. You will need to select a sub-category on the Sponsor Budget Map page, or create a custom one.
(38) Unallocated
By default, the expenses for this object code, on a parent budget or internal sub budget, will map to Section F. Other Direct Costs.You will need to select a sub-category on the Sponsor Budget Map page, or create a custom one.
You can change the sub-category to any value for Section F, except Subaward/Consortium/Contractual Costs.
You can also change the RR Detailed Budget Category to either D. Travel or E. Participant/Trainee Support Costs.
(25) Facilities and Administrative
The expenses for this object code, on a parent budget or internal sub budget, will map to Section H. Indirect Costs, and you cannot change the mapping.
The RR Detailed Budget form allows a maximum of four distinct indirect cost base/rate rows.
Participant/Trainee Support Costs
Use this section to indicate how many participants and/or trainees there are for each period.
There will be an entry field for each period.
If there are not any participants in a period, leave the field blank.
The eGC1 Compliance Questions and Explanations pages have been replaced by a new page called Non-Fiscal Compliance. This consolidation provides a more streamlined experience for preparers and reviewers.
Updated questions reflect current institutional needs, with improved clarity in mind. Links to supporting guidance have been added to assist preparers in understanding the policies and regulations behind each question. You can review the updated questions by visiting this page..
Design improvements make the page easier to navigate and gauge progress toward completion.
eGC1s that are in routing at the time of this release will display the old compliance questions that existed when the eGC1 was initially routed.
However, any eGC1 that is returned or withdrawn after the release will be reset with the new compliance questions. Answers to the previous questions will no longer display. Plan for additional time to re-complete that page in case a return or withdrawal is necessary.
Zipline and Hoverboard linked to eGC1
Human Subject (Zipline) and Animal Use (Hoverboard) protocols can now be linked to your eGC1. Searching by IRB Application Number or IACUC Protocol Number will allow you to pull in real-time information, reducing manual back-and-forth between systems and improving the accuracy of protocol details in SAGE.
Improved Collaboration
Send page link to PI, Reviewers
From any standard eGC1 page (excluding Grant Runner forms), the URL is now a direct link that you can copy and share with others who have access to that eGC1. This will be particularly useful when collaborating with the PI on completing the Non-Fiscal Compliance page.
Multi-User Editing (limited)
Currently, only one person can edit an eGC1 at a time. However, the Non-Fiscal Compliance page can now be edited, even while someone else is working in other areas of the eGC1. This will avoid situations where the PI could be blocked from contributing to the Non-Fiscal Compliance page while the administrator is currently editing other areas of the proposal.
Use this section to provide information about tangible items involved in a project, such as equipment and biological materials. This information helps reviewers understand export control and budgetary implications as well as informing protections that need to be in place for any sharing of tangible items outside UW. Contact Equipment Inventory Office with specific questions about fabricating equipment, or email exports@uw.edu for guidance on export controls.
As with other eGC1 pages, you can partially complete your entries and save the eGC1. You must complete the required fields before you route your eGC1 for approval.
Select Start Section to open the section initially, and then Edit Section to add or update existing data.
E-1. Will equipment be fabricated by the UW on this project?
Answer: Yes or No
Note: if the fabrication is being performed entirely by a non-UW entity (that is, a subcontractor), answer “No”.
E-2. Will the project involve the export of hardware, equipment, specimens, goods, software or monies? (excludes personal-use laptops)
Answer: Yes, No, or Unknown
Note: Answer “No” for personal-use laptops unless the laptop contains any military or space technical data, or if the only international transactions are for travel expenses.
E-2A displays if E-2 = Yes
E-2A. Describe the items/materials
Answer: enter a description
E-2B displays if E-2 = Yes
E-2B. Add one or more destination countries
Answer: search for by name, and select the appropriate countries
M-1. Will University-owned biological materials be provided to non-UW parties, including sponsor?
Answer: Yes or No
Note: Materials include (but are not limited to) cell lines, cultures, bacteria, nucleotides, proteins, transgenic animals, pharmaceuticals, or chemicals.
