Calculating % work complete from Project database tables

[KarenF]

Hi,
I'm trying to find out what database tables I can use to calculate actual
work entered per day per task . We are using timesheets to record actual hrs
per day per task. I want to create a cumulative % work complete data to
chart an s-curve per status week. I am using Access to create the queries
against the database.

I did come close using the msp_web_project; msp_web_resources;
msp_web_assignments; and msp_web_work tables. But the total actual work from
the msp_work_web did not match the total actual work column from the project
(used the msp_view_projects_tasks_std table). This was because resources
changed in the middle of the project for certain tasks with actuals already
recorded and then deleted when the resource was replaced. The msp_web_work
still keeps the original actuals recorded from the first resource, but the
other tables actual work does not. So now I'm trying to figure what tables I
can use to get the same results.

Basically I need to find actuals per day per task per project; change the
dates into what week they are in (using datepart function) and then grouping
the weeks together, totalling the actual work per week. I then use the
actual work to calculate % work complete per week and calculate cumulative %
work complete. to chart into an s-curve with my planned value vs earned value
cumulative chart.

I know this is a mouthful, but I thought I would pose this to the community
to see if others may have tried this, or if anyone knows the database tables
better than I can figure them out.

Thanks,
KarenF