eResearch Proposal Management UM-Maintained Reports Updated

09/15/09

New fields and two new reports were recently added to the RS02 BusinessObjects Proposal Management universe in response to customer feedback. Refer to Dennis Cebulski's September 15 e-mail for details.

Subject: eRPM Repository Reports Update

As a person who has access to the RS02 Proposal Management data set in Business Objects, here is an update on available repository reports. These reports can be found in Business Objects under Public Folders, UM-Maintained, Research, RS02 Proposal Management.

New fields have been added to the RS02 Proposal Management data warehouse and all repository reports have been updated. These new fields enable us to link data from the various tables to give you the information you have requested. For example, one of the new fields, the Primary Project/Grant Number, adds the most recent project/grant number to the PAF award information and can be found on all Active Awards and Historical Awards reports. A description of new fields pertaining to a report can be found on the Notes page of the report.

Updated reports include:
-- Pending Proposals by Person
-- Historical Proposals by Person
-- Active Awards by Person
-- Historical Awards by Person
-- Active Commitments by Person (recently added to RS02 Proposal Management)

Also per your request, the following reports have been updated with the new fields mentioned above as well as updated to run from the Person Appt Department rather than the Proposal Admin Department. The Person Appt Department is the department of appointment selected on the PAF for Principal and/or Participating Investigators. For your convenience, the Proposal Admin Department and related School/College continue to be included in all reports.

-- Pending Proposals by Person Appt Department
-- Pending Proposals by Person Appt School or College
-- Historical Proposals by Person Appt Department
-- Historical Proposals by Person Appt School or College
-- Active Awards by Person Appt Department
-- Active Awards by Person Appt School or College
-- Historical Awards by Person Appt Department
-- Historical Awards by Person Appt School or College
-- Active Commitments by Person Appt Department (recently added to RS02 Proposal Management)
Active Commitments by Person Appt School or College (recently added to RS02 Proposal Management)

Two new reports have been added to the repository to assist you with gathering information on collaborating investigators.
-- Active Awards by Person Appt Dept with all UM PIs
Adds the Principal Investigator(s) if not from your department.

-- Active Awards by Person Appt Dept with all UM PIs and Participating Investigators
Adds the Principal Investigator if not from your department and all Participating Investigators.

In addition to these two reports, new reports will soon be available that will contain data for outstanding proposals.

While these reports have been carefully constructed and tested there still remains some data issues that occasionally arise, you are strongly encouraged to notify us should you come across data that appears to be inconsistent with expected results.

I would like to acknowledge the efforts of Kate Strzempek of DRDA and Vasudha Ramani of MAIS who have partnered in developing and testing these queries.

Additional reports will be added over the next month. Information on RS02 Proposal Management data set on-line and classroom training will be announced before the end of September.

Your questions, suggestions, and data needs are always welcomed and should be sent to:
eRPM-Data@umich.edu

From: Dennis Cebulski
To: eRPM.Warehouse.Users
Sent: Tuesday, September 15, 2009 11:25 a.m.
Subject: