 monitoring approvals
Hi All!
Where can I see in SQL database what assignments did project manager approve today?
According to my investigations, these tables couldn't answer my question:
MSP_WEB_WORK_APPROVAL - not good, because this is resource manager approval and not project manager (and completely empty).
MSP_WEB_WORK_ADJUSTED - only modifications here (adjusted actuals)
MSP_WEB_TRANSACTIONS - also seems to be only modifications
MSP_WEB_WORK - here is no time of approval.
So, I can see what changes project manager made, but what did he approve newly today?
Using Project Server 2003 and SQL 2000, scheduled work, actual work and protected actual work.
Thanks,
David
|