Brenda,

Another one. Jane

-----Original Message-----
From: Research Administration List [mailto:xxxxxx@HRINET.ORG]On Behalf
Of Key, Diana
Sent: Tuesday, November 30, 2004 5:10 PM
To: xxxxxx@HRINET.ORG
Subject: Re: [RESADM-L] Giving Credit on Proposals and Awards

Franc,

We converted a DB2 database to an MS Access 97 database in 1997. When we
did that, we added a PINUM field to allow us to assign a sequential
number to investigator's on projects. PI #1 was always the lead, and the
others were added in whatever order the department desired. We then had
the ability to report just using PI #1 or all PI's, using Access's
reporting functionality.

We went live with PeopleSoft Grants 8.4 in July 2004. This system
requires designation of a single Proposal PI. The system also allows
multiple projects to be set up under a single Proposal ID; therefore, we
can have one Project PI, and multiple Co-PI's. The system provides
several different tools which will allow us to report investigators
however we want.

Let me know if you would like me to send you information on the table
structure and relationships of the Access db.

Diana

Diana Key  ;-)
ERP Sponsored Projects Team
Sponsored Research Services
97 South Woodward Street
Tallahassee, FL 32312-4166
(850) 644-8648
(850) 644-1464

-----Original Message-----
From: Research Administration List [mailto:xxxxxx@HRINET.ORG] On
Behalf Of Lemire, Francois D.
Sent: Monday, November 29, 2004 8:37 AM
To: xxxxxx@HRINET.ORG
Subject: [RESADM-L] Giving Credit on Proposals and Awards

Hi,

We have a recurring problem ascribing credit on proposals and awards and
I'm hoping to find out how others handle this situation.  When we record
proposals and awards, we can give credit only to the lead department and
investigator.  There are some departments here at WPI though that would
like us to acknowledge in our reports their contributions to
multi-disciplinary proposals and awards.  Does anyone have any ways that
they've successfully accomplished this?

Thanks for your help!

Franc

Francois D. Lemire
Director, Research Administration
Worcester Polytechnic Institute
100 Institute Road
Worcester, MA 01609-2280
Tel. 508-831-5359
Fax. 508-831-5789

######################################################################
This transmission may be confidential or protected from disclosure and
is only for review and use by the intended recipient. Access by
anyone else is unauthorized. Any unauthorized reader is hereby
notified that any review, use, dissemination, disclosure or copying of
this information, or any act or omission taken in reliance on it, is
prohibited and may be unlawful. If you received this transmission in
error, please notify the sender immediately.  Thank you.

######################################################################

======================================================================
 Instructions on how to use the RESADM-L Mailing List, including
 subscription information and a web-searchable archive, are available
 via our web site at http://www.hrinet.org (click on "Listserv Lists")
======================================================================