Timesheet info in SQL tables

[Wesley]

Hi, I need to know where in SQL the submitted Timesheets get stored as well
as what happens to the timesheet data after it gets approved by the Manager.

Thanks alot.
Wesley

 

[Rod Gill]

As you discuss time sheet approval I assume you are using Project Server?
Look in the MSP_VIEW tables, there are time phased ones that show hours/$
per day there. In the MSP_ tables, timephased data is only visible if in
Project you select Expand time phased data under Tools, Options, Save tab.
However this information is hard to interpret and isn't accurate unless you
also integrate it with the calendar data. The 'real' data is stored in
binary blobs.

 

[Wesley]

Thanks for the reply Rod. I'll have a look in the MSP_VIEW tables. The
MSP_WEB_WORK tables also looks if it can have some usefull data that I can
use.

 

[Lars Hammarberg]

Don't forget one of the most heavily used tables in the database:
msp_web_assignments
Here you'll find the total work and remaining work as well as %complete
together with lots of other interesting data.
The web_work contains the timephased entries - both scheduled and actual.