eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PA.PA_PROJ_ROLLUP_TEMP#

Source

View Text - Preformatted


select PROCESS_NUMBER PROCESS_NUMBER, OBJECT_ID OBJECT_ID, OBJECT_TYPE OBJECT_TYPE, PARENT_OBJECT_ID PARENT_OBJECT_ID, PARENT_OBJECT_TYPE PARENT_OBJECT_TYPE, CALENDAR_ID CALENDAR_ID, CONSTRAINT_TYPE_CODE CONSTRAINT_TYPE_CODE, CONSTRAINT_DATE CONSTRAINT_DATE, WBS_LEVEL WBS_LEVEL, START_DATE START_DATE, START_DATE_OVERRIDE START_DATE_OVERRIDE, FINISH_DATE FINISH_DATE, DURATION DURATION, TASK_STATUS TASK_STATUS, PROGRESS_STATUS_WEIGHT PROGRESS_STATUS_WEIGHT, PROGRESS_OVERRIDE PROGRESS_OVERRIDE, REMAINING_EFFORT REMAINING_EFFORT, PERCENT_COMPLETE PERCENT_COMPLETE, PERCENT_OVERRIDE PERCENT_OVERRIDE, TASK_WEIGHT TASK_WEIGHT, NUMBER_FIELD NUMBER_FIELD, ROLLUP_NODE ROLLUP_NODE, DIRTY_FLAG DIRTY_FLAG, ETC_COST ETC_COST, PPL_ETC_COST PPL_ETC_COST, EQPMT_ETC_COST EQPMT_ETC_COST, PPL_UNPLAND_EFFORT PPL_UNPLAND_EFFORT, EQPMT_ETC_EFFORT EQPMT_ETC_EFFORT, SUB_PRJ_ETC_COST SUB_PRJ_ETC_COST, SUB_PRJ_PPL_ETC_COST SUB_PRJ_PPL_ETC_COST, SUB_PRJ_EQPMT_ETC_COST SUB_PRJ_EQPMT_ETC_COST, SUB_PRJ_PPL_ETC_EFFORT SUB_PRJ_PPL_ETC_EFFORT, SUB_PRJ_EQPMT_ETC_EFFORT SUB_PRJ_EQPMT_ETC_EFFORT, EARNED_VALUE EARNED_VALUE, BAC_VALUE BAC_VALUE, PERC_COMP_DERIVATIVE_CODE PERC_COMP_DERIVATIVE_CODE from "PA"."PA_PROJ_ROLLUP_TEMP"

View Text - HTML Formatted

SELECT PROCESS_NUMBER PROCESS_NUMBER
, OBJECT_ID OBJECT_ID
, OBJECT_TYPE OBJECT_TYPE
, PARENT_OBJECT_ID PARENT_OBJECT_ID
, PARENT_OBJECT_TYPE PARENT_OBJECT_TYPE
, CALENDAR_ID CALENDAR_ID
, CONSTRAINT_TYPE_CODE CONSTRAINT_TYPE_CODE
, CONSTRAINT_DATE CONSTRAINT_DATE
, WBS_LEVEL WBS_LEVEL
, START_DATE START_DATE
, START_DATE_OVERRIDE START_DATE_OVERRIDE
, FINISH_DATE FINISH_DATE
, DURATION DURATION
, TASK_STATUS TASK_STATUS
, PROGRESS_STATUS_WEIGHT PROGRESS_STATUS_WEIGHT
, PROGRESS_OVERRIDE PROGRESS_OVERRIDE
, REMAINING_EFFORT REMAINING_EFFORT
, PERCENT_COMPLETE PERCENT_COMPLETE
, PERCENT_OVERRIDE PERCENT_OVERRIDE
, TASK_WEIGHT TASK_WEIGHT
, NUMBER_FIELD NUMBER_FIELD
, ROLLUP_NODE ROLLUP_NODE
, DIRTY_FLAG DIRTY_FLAG
, ETC_COST ETC_COST
, PPL_ETC_COST PPL_ETC_COST
, EQPMT_ETC_COST EQPMT_ETC_COST
, PPL_UNPLAND_EFFORT PPL_UNPLAND_EFFORT
, EQPMT_ETC_EFFORT EQPMT_ETC_EFFORT
, SUB_PRJ_ETC_COST SUB_PRJ_ETC_COST
, SUB_PRJ_PPL_ETC_COST SUB_PRJ_PPL_ETC_COST
, SUB_PRJ_EQPMT_ETC_COST SUB_PRJ_EQPMT_ETC_COST
, SUB_PRJ_PPL_ETC_EFFORT SUB_PRJ_PPL_ETC_EFFORT
, SUB_PRJ_EQPMT_ETC_EFFORT SUB_PRJ_EQPMT_ETC_EFFORT
, EARNED_VALUE EARNED_VALUE
, BAC_VALUE BAC_VALUE
, PERC_COMP_DERIVATIVE_CODE PERC_COMP_DERIVATIVE_CODE
FROM "PA"."PA_PROJ_ROLLUP_TEMP"