Extracting Time from MSP_WEB_WORK

[Tom.K]

I have a sql script that extracts the time someone has
entered on their web access time sheet. It pulls the time
from table MSP_WEB_WORK and then pulls a bunch of other
custom info to go along with it.

I am having trouble with the way project stores
consecutive entries with equal time for the same task.
For Example If you enter 8 hrs a day to the same task for
3 days in a row it will store that as one record with
different values for wwork_start and wwork_finish. This
is fine because I can use the difference in these fields
to create a record for each day in the range.

However, I am having trouble with date fields overlapping
for the same task. (see below)

The following 3 entries are from the table MSP_WEB_WORK.
It is actual time(WWORK_TYPE = 1) all for the same
Assignment.
WWORK_START WWORK_FINISH WWORK_VALUE
10/12/03 12:00 AM 10/15/03 12:00 AM 0
10/14/03 12:00 AM 10/21/03 12:00 AM 480000
10/16/03 12:00 AM 10/18/03 12:00 AM 480000

According to this the 16, 17, and 18 have 8 hours twice.
That would total 16 hours for each of these days. However,
the users timesheet only shows 8 hours.

Also, their timesheet shows 0 hours on the 12th and 13th
but not on the 14th and 15th

How does MSP break out these records to show what belongs
on a users timesheet?

 

[Guest]

tom,

based on what you've showed, below, my guess is that MS is
ignoring overlap. so you get 0 hours for the 12th and
13th, but 8 hours on the 14th and 15th because of the
second row containing those dates. Then it ignores the
3rd row entirely because it is contained within the dates
of the second row. I'm willing to bet that if the third
row went through the 22nd, it would show 8 more hours for
that date

 

[Gary Chefetz [MVP]]

Tom:

You should look at the transaction history for this user. On its face, it
looks like the user sent three separate updates on the task. The first is
for zero hours, the second two have overlapping time periods and tie in to
what you're seeing.