difference between the project in draft and published db

H

Henk

Hi All,

Where can I easily see that there is a difference between the project
in the draft database en the published database? So I can see which
projects still have to be published, so my resources can se the actual
status and plan.

Thanks!

Kind regards,

Henk
 
J

James Fraser

Hi All,

Where can I easily see that there is a difference between the project
in the draft database en the published database? So I can see which
projects still have to be published, so my resources can se the actual
status and plan.

Thanks!

Kind regards,

Henk
Click to expand...


If you are referring to 2007, in the Draft database run this:

select p.WPROJ_LAST_PUB, p.PROJ_LAST_SAVED, p.PROJ_NAME from
MSP_PROJECTS p
where p.WPROJ_LAST_PUB < p.PROJ_LAST_SAVED

This is not accurate if you run this for the published database.


James Fraser
 
N

NZ Projects

process, process, process

This doesn't account for those plans which have been edited offline or that
are being amended as part of an agreed changed.

The published database should be the single version of the truth as far as
resources are concerned.

PM's should be educated to republish plans as and when they want their
changes to propogate to the resources.
 
Top