Where are the field and table for daily resource hours from projec

[Team Carney]

We need to find where resource's daily task hours are saved on the project
database (2002). We were able to find a resource's total task hours are in
the ASSN_WORK field of MSP_ASSIGNMENTS table, but couldn't figure out where
the daily hours information is.

Any help would be appreciated.

 

[Team Carney]

Great! Thank you Ray!

Taks a look at the MSP_VIEW_PROJ_ASSN_TP_BY_DAY this will contain the
timephase data for the assignments. In order for this to caontain the data
the project must be published and the views processing must be completed.

Hope this helps
--
Ray McCoppin

http://www.randsmanagement.com
SRS gantt charts
Project Server 2007 archive tool