Field to Control who receives timesheet updates

P

PG

our pmo wants to do all the publishing of all projects on a regular basis.
that means of course that the respondent to updates becomes the publisher. we
want to write some simple sql to alter the field that keeps tract of the
person to who updates are sent ... we will do it by proj id and yes we could
change owner each time but one script would be a lot faster.

what field controls this? and yes i have looked thru the documentation but
it isn't really obvious. thanks in advance.
 
C

Christoffer Soltau

Hi PG,

You need to change the field WRES_ID_MGR in MSP_WEB_ASSIGNMENTS. That way
you can control the manager for the individual assignment.
Remember that you have to use the pm's WRES_ID.

regards,

Christoffer Soltau
Project Consultant
Hans Tørsleff management systems (http://www.htms.dk)
 
Top