Tracking Actuals

[Tom_s]

Hi,

I am attempting to pull an extract off the database of actual hours charged
to a task by project for a set period, such as 04/20/06 - 04/26/06. The only
date that I can find that updates when the user enters actual hours is the
"Submitted On" field. Unfortunately this will not work, because this date
changes every time an entry is made on that task. I cannot find any place
where I can query against the database and pull an extract on all actual
hours charged for a set period of time. Can anyone assist me with this?

 

[clin341]

My best guess is the table msp_web_works. In the where clause, you would
want to set:

wwork_type = 1
wwork_update_status = 0

Your data is in wwork_value field. You have to divide this by 60000 to
convert it to hours.

Also, there's still one more complexity. This table has a wwork_start and a
wwork_finish. This means that between wwork_start and wwork_finish, the
wwork_value is the same for each date. For example, suppose you have a row
with:

wwork_start = "1/1/2006"
wwork_end = "1/3/2006"
wwork_value = 60000

This means that on 1/1/2005, 1/2/2006, and 1/3/2006, the resource applied 1
hour of work on each of the three days.

If you need help with the query, please let us know.

Hope this helps,
CLin

 

[Tom_s]

Clin,

Thanks for the response. We will take a look at this and see if this will
solve our problem. We are currently using PlanView to capture our resources
actual hours charged to a task and then extracting a file out of Plainview on
a weekly basis to datapump into a SQL Server database. We hope to be able to
accomplish the same process using MS Project as a tool to track actual hours.

Thanks again