Reporting on timesheet approvals

[Camsaway]

Hi,

We have multiple approvers for timesheets setup on Project Server 2007.
Where timesheets are somewhere in the approval process I'd like to be able to
find out which approver the timesheet is sitting with.

For a specific timesheet, where can I find out the user that it is
specifically waiting to approve the timesheet?

Regards,
Cameron.

 

[Jonathan Sofer]

I believe that as an administrator you can see all timesheets in the
Timesheet Approval screen if you apply the correct filter there. Make sure
the checkbox is turned off in the section that shows specific resource.

You'll be able to get this information from the reporting database using SQL
Reporting Services. There are some pre-defined timesheet reports for SQL
Reporting Services available in the SDK.

Jonathan

 

[Camsaway]

Hi,

Didn't seem to be able to do that but we also want non-admins(finance, etc)
to be able to see the report.

What we have found is that in the Published(?) database not the reporting
one there is a table called "MSP_TimesheetActions" or something similar. This
appears to be the approval steps for a timesheet and we can isolate the
incomplete step.

Is this the correct data? (Couple of tests SEEM it is - but not sure). Would
also prefer if it was in Reporting DB instead of having Synonym to the other
DB.

Can anyone advise?

Cheers,
Cameron.

 

[Jonathan Sofer]

I searched the reporing database schema and used a database text search tool
on key UIDs and/or words that would indicate whether timesheet approval data
might exist in the reporting database. Neither of these came back with any
indication that this data exists in the reporting database. So I think you
are correct that you will have to use the published database to get to this
information.

Jonathan