How can I tell if PM's are doing their approvals?

[ITG_Mike]

Is there any way in PS03 to tell if Project Managers are doing their
approvals and updates of submitted time? I am looking for some summary
indiction of how much time is submitted and not approved, or how old that
time is. Solutions in the back end database are fine.

Mike

 

[Rick Roszko]

You can do several things... all in a round about way...

(a) Check to see when any user logged on last
1. Go to "Admin",
2. then "Manage Users and Groups",
3. then do a "Show Grid".

(b) Check to see when the project was last opened
1. Launch MS Project
2. Do a File, Open
3. You can see the date the project was last checked out

(c) Check if resources got accepted
1. Go to Resources,
2. then View Resource Assignments
3. Pick the resources you are interested in
4. Click on "Apply".
5. Click on "Timesheet Format" and "All Assignments" (left panel).

If there is no time, the user did not submit a timesheet.
If the numbers are *red*, time has been submitted but the PM
did not update the project.

If it's *blue*, then, hmmm. I forgot what blue was... I think it's
time was accepted but the project has not been re-published yet.

Oh, of course, you can open the Project file as "read only"
so you don't accidentally change anything and look, and
it won't alter the time stamp on the file...

 

[Ray McCoppin]

You can also run a query on the MSP_WEB_TRANSACTIONS table it will tell you
when and resource submitted time and when a PM rejected or accepted the time.

We have create some SQL reports that report on this table.

 

[ITG_Mike]

Rick, Ray,

Thanks for your replies.

Ray, your reply is closer to what I am looking for, and I have indeed looked
at the MSP_WEB_TRANSACTIONS table and can see the submissions. There is one
problem I have found in using this data. If I have a manager that is not
processing updates each week, I can look in the transation tables and see the
submissions that have not yet been processed. The problem is that resources
will continue entering time and do another update the following Friday. This
update with simply change the date of the currently open tranaction in the
MSP_WEB_TRANSACTIONS table. This manager now appears to have only
submissions from this week waiting for processing. This can continue for
many weeks.

It appears that I may need to write a proceduere that logs the ID of open
transactions and looks for IDs that are moving from week to week.