VIEW: PA.PA_PROJ_ELEM_VER_SCHEDULE#

Source

View Text - Preformatted

select PEV_SCHEDULE_ID PEV_SCHEDULE_ID, ELEMENT_VERSION_ID ELEMENT_VERSION_ID, PROJECT_ID PROJECT_ID, PROJ_ELEMENT_ID PROJ_ELEMENT_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, SCHEDULED_START_DATE SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE SCHEDULED_FINISH_DATE, OBLIGATION_START_DATE OBLIGATION_START_DATE, OBLIGATION_FINISH_DATE OBLIGATION_FINISH_DATE, ACTUAL_START_DATE ACTUAL_START_DATE, ACTUAL_FINISH_DATE ACTUAL_FINISH_DATE, ESTIMATED_START_DATE ESTIMATED_START_DATE, ESTIMATED_FINISH_DATE ESTIMATED_FINISH_DATE, DURATION DURATION, EARLY_START_DATE EARLY_START_DATE, EARLY_FINISH_DATE EARLY_FINISH_DATE, LATE_START_DATE LATE_START_DATE, LATE_FINISH_DATE LATE_FINISH_DATE, CALENDAR_ID CALENDAR_ID, MILESTONE_FLAG MILESTONE_FLAG, CRITICAL_FLAG CRITICAL_FLAG, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WQ_PLANNED_QUANTITY WQ_PLANNED_QUANTITY, PLANNED_EFFORT PLANNED_EFFORT, ACTUAL_DURATION ACTUAL_DURATION, ESTIMATED_DURATION ESTIMATED_DURATION, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, SCHEDULED_START_DATE_ROLLUP SCHEDULED_START_DATE_ROLLUP, SCHEDULED_FINISH_DATE_ROLLUP SCHEDULED_FINISH_DATE_ROLLUP, ESTIMATED_START_DATE_ROLLUP ESTIMATED_START_DATE_ROLLUP, ESTIMATED_FINISH_DATE_ROLLUP ESTIMATED_FINISH_DATE_ROLLUP, ACTUAL_START_DATE_ROLLUP ACTUAL_START_DATE_ROLLUP, ACTUAL_FINISH_DATE_ROLLUP ACTUAL_FINISH_DATE_ROLLUP, DEF_SCH_TOOL_TSK_TYPE_CODE DEF_SCH_TOOL_TSK_TYPE_CODE, CONSTRAINT_TYPE_CODE CONSTRAINT_TYPE_CODE, CONSTRAINT_DATE CONSTRAINT_DATE, FREE_SLACK FREE_SLACK, TOTAL_SLACK TOTAL_SLACK, EFFORT_DRIVEN_FLAG EFFORT_DRIVEN_FLAG, LEVEL_ASSIGNMENTS_FLAG LEVEL_ASSIGNMENTS_FLAG, EXT_ACT_DURATION EXT_ACT_DURATION, EXT_REMAIN_DURATION EXT_REMAIN_DURATION, EXT_SCH_DURATION EXT_SCH_DURATION, SOURCE_OBJECT_ID SOURCE_OBJECT_ID, SOURCE_OBJECT_TYPE SOURCE_OBJECT_TYPE from "PA"."PA_PROJ_ELEM_VER_SCHEDULE"

View Text - HTML Formatted

SELECT PEV_SCHEDULE_ID PEV_SCHEDULE_ID
, ELEMENT_VERSION_ID ELEMENT_VERSION_ID
, PROJECT_ID PROJECT_ID
, PROJ_ELEMENT_ID PROJ_ELEMENT_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, SCHEDULED_START_DATE SCHEDULED_START_DATE
, SCHEDULED_FINISH_DATE SCHEDULED_FINISH_DATE
, OBLIGATION_START_DATE OBLIGATION_START_DATE
, OBLIGATION_FINISH_DATE OBLIGATION_FINISH_DATE
, ACTUAL_START_DATE ACTUAL_START_DATE
, ACTUAL_FINISH_DATE ACTUAL_FINISH_DATE
, ESTIMATED_START_DATE ESTIMATED_START_DATE
, ESTIMATED_FINISH_DATE ESTIMATED_FINISH_DATE
, DURATION DURATION
, EARLY_START_DATE EARLY_START_DATE
, EARLY_FINISH_DATE EARLY_FINISH_DATE
, LATE_START_DATE LATE_START_DATE
, LATE_FINISH_DATE LATE_FINISH_DATE
, CALENDAR_ID CALENDAR_ID
, MILESTONE_FLAG MILESTONE_FLAG
, CRITICAL_FLAG CRITICAL_FLAG
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, WQ_PLANNED_QUANTITY WQ_PLANNED_QUANTITY
, PLANNED_EFFORT PLANNED_EFFORT
, ACTUAL_DURATION ACTUAL_DURATION
, ESTIMATED_DURATION ESTIMATED_DURATION
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, SCHEDULED_START_DATE_ROLLUP SCHEDULED_START_DATE_ROLLUP
, SCHEDULED_FINISH_DATE_ROLLUP SCHEDULED_FINISH_DATE_ROLLUP
, ESTIMATED_START_DATE_ROLLUP ESTIMATED_START_DATE_ROLLUP
, ESTIMATED_FINISH_DATE_ROLLUP ESTIMATED_FINISH_DATE_ROLLUP
, ACTUAL_START_DATE_ROLLUP ACTUAL_START_DATE_ROLLUP
, ACTUAL_FINISH_DATE_ROLLUP ACTUAL_FINISH_DATE_ROLLUP
, DEF_SCH_TOOL_TSK_TYPE_CODE DEF_SCH_TOOL_TSK_TYPE_CODE
, CONSTRAINT_TYPE_CODE CONSTRAINT_TYPE_CODE
, CONSTRAINT_DATE CONSTRAINT_DATE
, FREE_SLACK FREE_SLACK
, TOTAL_SLACK TOTAL_SLACK
, EFFORT_DRIVEN_FLAG EFFORT_DRIVEN_FLAG
, LEVEL_ASSIGNMENTS_FLAG LEVEL_ASSIGNMENTS_FLAG
, EXT_ACT_DURATION EXT_ACT_DURATION
, EXT_REMAIN_DURATION EXT_REMAIN_DURATION
, EXT_SCH_DURATION EXT_SCH_DURATION
, SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, SOURCE_OBJECT_TYPE SOURCE_OBJECT_TYPE
FROM "PA"."PA_PROJ_ELEM_VER_SCHEDULE"