Check pending tasks to be submitted to the PM

[Frank]

Hi,

I wonder if it''s possible to have some kind of mechanism (pref. SRS report)
to check if there are pending task updates that the PM should receive.
InPS2007 we (the Timesheet Manager) can check if there are any unsubmitted
Timesheets I would b very nice to have the same kind of information available
for the Project Manager so he/she knows that all projct hours have been
submitted or not.

Rgds,

Frank Jutte
(e-mail address removed)
(e-mail address removed)

 

[Paul Conroy]

Hi Frank

I'm sure this could be done in SRS if you know what to query in SQL !

If I was doing it, I'd be asking the question "What exactly do you want
reporting?"

List of Task Updates saved but not submitted ?
List of Task Updates saved and submitted ?
List of Expected task updates, neither saved or submitted ?

Paul

 

[James Fraser]

Hi Frank

I'm sure this could be done in SRS if you know what to query in SQL !
....

"Frank" wrote: ....

....

There have been a few previous discussions on this topic. The pending
updates are stored as a binary object in the ASSN_CHANGE_DATA field in
the MSP_ASSIGNMENT_TRANSACTIONS table. They are one of the harder
pieces of data to get at in Project Server.

Molnar Tibor has a blog entry about this:
http://geekswithblogs.net/MTex/archive/2008/02/07/119379.aspx


James Fraser