Non Project Working time - Database Access for Reporting

C

Cynthia

Managers Question continued.

The nonworking time category is a organizational wide
category. My notes reflect a company can manipulate the
data in the database for nonworking time; however, the
nonworking time are not data fields.

Does this mean that the company may not be able to
get to the data in the database to place in another
application to generate reports?

If access to the data in the Database is possible,
what are the procedures for doing it?
 
L

Lon`

Cynthia,

You can pretty much get at any of the timephased data
records by examining the following four tables.
MSP_WEB_PROJECTS, MSP_WEB_RESOURCES, MSP_WEB_ASSIGNMENTS
and MSP_WEB_WORK. The nonproject rows will all have a
WPROJ_ID = 1. I'll leave it to you to figure out the
joins. If you have any SQL experience it all, I doubt
you'll have much trouble.
 
D

Dale Howard

Cynthia --

As you have discovered, the Nonworking Time section of PWA is not very
helpful as it is currently implemented. There is no default method from
within PWA for gathering and reporting on this information. You would have
to query the Project Server database directly (such as through Crystal
Reports) to extract this information.

An alternate method that many of us use is to create a separate project
known as an "administrative plan" to capture this information. Perhaps some
of the others would like to comment on their use of administrative plans.
Hope this helps.
 
D

David

I have tried using the tables as specified below when I
choose WPROJ_ID=1 it gives me a blank row with no data
even though I have entered non working time for different
resources. Maybe the joins are not correct. Could you
please specify the correct joins inorder to identify the
non-working time of different resources.
Regards,
David
 
Top