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
Member for
18 years 9 months
Member for18 years10 months
Submitted by Dieter Wambach on Wed, 2007-03-07 04:20
Member for
19 yearsRE: Project Status P3e
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
Member for
18 years 8 monthsRE: Project Status P3e
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
Member for
18 years 9 monthsRE: Project Status P3e
Hi Core,
maybe your question was, if a project is loaded into your PCs 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
Member for
19 yearsRE: 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