stopping a task from being booked to...

[Simon Dullingham]

I've been discussing in the project group ways of managing infrequent
overhead tasks (like QC, data management, Project Management, etc) One
solution is to set aside a pool of hours for a fixed period (say a month)
and just assign them at the end of the month - i.e. 15 hours on the 30
April. Set the timesheets in PWA to show 4 weeks ahead and allow people to
pre-book against overhead tasks as needed.

(I'm not sure if this makes any sense, but I'm trying not to repeat
everything in another forum).

Anyway, let's say the PM on a project books jsut 5 hours. I then want to
zero his hours at the close of the month, and then stop him from booking
against April's hours in May. i.e. he has to use his pool of 15 hours in
May.

So is there a way of locking out a task so that it cannot be booked against
(like the lock timesheet feature for past time periods), or removing a task
from a timesheet (like the changing a resource to proposed in the Enterpise
Resource dialog)?

Thanks,
Simon

 

[Gary L. Chefetz [MVP]]

Simon:

You can use the "proposed" technique only if you rotate the projects
monthly, as this is a project-level setting for a resource. You can also use
a SQL query providing you can identify the assignments you want to affect.
You can get some ideas on the necessary SQL from various posts on
projectserverexperts.

 

[Simon Dullingham]

Gary,

Thanks. I thought this would be the case. Seems like it would be a nice
feature for a future version

One the SQL query side, I've already been to your site an nabbed the script
that you use to removed deleted tasks from timesheets. I've modified it a
bit and use it for some other tidy up work. However, I have a question: If I
use SQL query to remove tasks from the MSP_WEB_ASSIGNMENTS table (to stop
people from booking against them), do I run the risk of damaging the table?
I guess what I am asking is that if I run "re-publish all assignments" from
Project, will it correct any mistakes that I may have inadvertently made? Or
do I now have an SQL restore job to do!

Thanks,
Simon

 

[Gary L. Chefetz [MVP]]

Simon:

It seems to me you want to hide the assignments.

 

[Simon Dullingham]

that makes sense. Do you know which field I need to change to make it hidden
to the user?

Or where details are of the database structure which would explain this to
me.

Thanks,
Simon

 

[Gary L. Chefetz [MVP]]

Simon:

On your server in the Project Server folder help files, look for PJDB.htm
and PJSVRDB.htm