Project Status P3e

C
Core Mirror 👤 Member for 19 years 3 months
Oracle Primavera - PM6
R
Rodel Marasigan 👤 Member for 19 years 7 months
· Permalink

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

C
Core Mirror 👤 Member for 19 years 3 months
· Permalink

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

D
Dieter Wambach 👤 Member for 19 years 5 months
· Permalink

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

R
Rodel Marasigan 👤 Member for 19 years 7 months
· Permalink

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

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts