RMS Other Support – NIH Format Report

The ‘Other Support – NIH Format’ report is required by many sponsors as part of the proposal submission, at just-in-time, or in the progress report.

The Data management team has developed an ‘Other Support’ report in the new NIH format using data in the RMS datamart to support these requests.  This report does not currently include research activities that are not captured in RMS such as clinical trials, in-kind support, or research sponsored outside of the university.

You can locate this report in Cognos under Team Content > Reports > Research Reporting > Pre Award > Other Support- NIH Format.

Report Access

Running this report in Cognos will require RMS security in the data warehouse. Anyone with current RMS data warehouse security will be able to see all of the data on the report.

If you find that you do not have the appropriate access to see data on this report, please click the button below to request RMS security access.

To generate the report, run by Individual and “As of” Date.

RMS allows flexibility at the discretion of the DA when developing budgets which may impact how the data is displayed on the report.  It is important to review the output and adjust the report as needed to ensure accuracy.  Reports can be exported as a PDF, saved on the desktop and then converted to word for editing.

Known Issues and Enhancements

Please note that this is an ongoing project. We are aware of the issues below and are working to have them corrected in the next round of edits. 

  • Active funds “Total Award Amount” will include only the amount that has been awarded to date in the current renewal project period. 
  • “Project/Proposal Start Date” Renewal start dates are the beginning of the current award cycle and not the life of the award.

We appreciate your feedback by completing this survey, which will help determine any additional fixes that will need to be made.  

Frequent changes that will need to be made to the Other Support report and updates that should be made in RMS

Below is a list of changes we recommend you make in RMS PT in order for your Other Support Reports to include the appropriate information.

  • Update the status of pending RMS if it is not being funded.
  • Add Major Goals and Primary Place of Performance on current RMS that are active or pending.
  • Include the Major Goals, Key Words, and Primary Place of Performance in new RMS.
STEPS TO UPDATE RMS- PT:

MAJOR GOALS AND PRIMARY PLACE OF PERFORMANCE

  1. RMS – search for the parent RMS
  2. Select Proposal Tracking – Edit
  3. On the Summary Screen enter both the “Major Goals” and the “Location of Project”

STATUS UPDATE

  1. RMS: search for the parent RMS
  2. Select Proposal Tracking > Edit
  3. Select Status History
  4. Click the dropdown under Status and select “Not Funded by Sponsor”

CALENDAR MONTHS TO SHOW UP ON OTHER SUPPORT

When entering the effort or calendar months in the Budget Detail tab, hit “tab” after entering the effort or calendar months instead of “enter” and it will fill in the out years as well as percent of effort and calendar months on the Effort Periods tab.

Calendar months are pulled from RMS and should be updated/confirmed with workday PCAs in order to have the most up-to-date information.