Project Status P3e

Hi,

If you are referring to Project Status:

Table: PROJ_WBS
Column: status_code

If Check Out Status:

Table: PROJECT
Column: checkout_flag

Regards,
Rodel

Hi Core,
maybe your question was, if a project is loaded into your PC’s memory.

Either column "open state" under the category summary or in the top line of the Primavery window - if not too many loaded.
Regards
Dieter

It was the table names and columns thank you.

What I am trying to run is a query to get the total planned and actual hours for 2007 for active projects, but some of the projects are coming up with double what the hours should be and others are very close to what they should be. I tried using (<> WS_Closed) but that did not work. If I use (= WS_Open) some of the projects show half of the hours they should be showing.

This is comparing to the report ran in Primavera

Core

Hi Core,

You may want to include into your link the TASKRSC table and use rscs_type to filter the “RT_LABOR” only to separate from materials and equipment hrs.

Cheers,
Rodel