Work stored in the database - MSP_WEB_WORK

[Gegga]

Hi,
It seems that the actual work hours is stored in the database in a funny
way. For instance if I enter the same number of hours two days or more on a
row on the same project/task this will be stored in the database as one row.
One example:

I enter the following in my timesheet in PWA:
Task name 13/jun 14/jun 15/jun 16/jun 17/jun Total
Training 8h 8h 8h 8h 8h
40h

The following will be stored in the table MSP_WEB_WORK
wres_id wassn_id wwork_start wwork_finish wwork_type wwork_value(sec) 133 10166 13.06.2005 17.07.2005 1 2400000.00

Converting 2400000.00 sec gives 40 hours.

Can anyone tell me if actual hours is stored otherwise in the project server
database so that I can pick one row per resource/project/task/day?

 

[Kevin W Flanagan]

Can you post the query you used on the table?

 

[Edmond]

Hi,

I think that the wwork_value for your example is wrong:
For me, the record is:
wres_id wassn_id wwork_start wwork_finish wwork_type wwork_value
133 10166 13.06.2005 17.07.2005 1 480000

With 480000 gives 8H / day.
For PWA, the time unit is min divided by 1'000.

Have a Good day
Edmond

 

[Edmond]

Hi,

I think that the wwork_value for your example is wrong:
For me, the record is:
wres_id wassn_id wwork_start wwork_finish wwork_type wwork_value
133 10166 13.06.2005 17.07.2005 1 480000

With 480000 gives 8H / day.
For PWA, the time unit is min divided by 1'000.

Have a Good day
Edmond

 

[Gary L. Chefetz [MVP]]

Gegga:

This is a data storage optimization technique. Look at svrdb.htm in your
server help files. This gives you query samples for going after the data.

 

[Gegga]

Hi,
Here it is:
SELECT *, WWORK_VALUE / 1000 / 60 AS Hours
FROM MSP_WEB_WORK
WHERE (WWORK_TYPE = '1')

 

[Gegga]

Gary,
Thanks. Assum that you refer to 'Find all timephased data for....' sections.

Is there an option where I can turn this optimalization off so that actual
hours are stored as they are entered from the pwa?

 

[Gary L. Chefetz [MVP]]

Gegga:

In MSP_WEB_WORK, the data is stored as entered by the resources, but using
the same space saving algorithm. All you need is a sql query to convert it
to the format you want.

 

[Nelson]

Hi:

Any idea of how they migrated this field to PS 2007?

I've been struggling with the Project. Assignment and Task tables, but have
come out empty handed.
Appreciated!!
Nelson