[Home] [Help]
View: PA_STRUCTURES_TASKS_V
| Product: | PA - Projects |
|---|
| Description: | PA_STRUCTURES_TASKS_V selects all the attributes of a structure version and a task version. - For future use |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT
FROM PA_PROJ_ELEM_VER_STRUCTURE PPVS
, PA_PROJ_ELEM_VER_SCHEDULE PPVSCH
, PER_ALL_PEOPLE_F PAPF
, PA_PROJECT_STATUSES PPS2
, PA_PROJECTS_ALL PPA
, PA_PROJ_STRUCTURE_TYPES PPST
, PA_STRUCTURE_TYPES PST
, PA_WORK_TYPES_TL PWT
, PA_TASK_TYPES TT
, PA_PROJECT_STATUSES PPS3
, PA_PAGE_LAYOUTS PPL
, PA_PROGRESS_ROLLUP PPRU
, PA_PERCENT_COMPLETES PPC
, PA_PROJECT_STATUSES PPS
, PA_PROJECT_STATUSES PPS5
, PA_PROJ_ELEMENTS PPE5
, PA_PROJ_ELEMENT_VERSIONS PPV5
, PA_PROJ_WORKPLAN_ATTR PPWA
, PA_PROJ_ELEMENT_VERSIONS PPEV6
, PA_PROJ_PROGRESS_ATTR PPPA
, PA_PROJ_ELEMENT_VERSIONS PPV2
, PA_TASKS PT
, PA_PROJ_ELEMENTS PPE
, PA_PROJ_ELEMENT_VERSIONS PPV
, PA_OBJECT_RELATIONSHIPS POR
, PA_PROJ_ELEMENTS PPEPH
, PA_PROJ_ELEMENT_VERSIONS PPEVPH
Columns
| Name |
| ELEMENT_NUMBER |
| ELEMENT_NAME |
| DESCRIPTION |
| OBJECT_TYPE |
| ELEMENT_VERSION_ID |
| PROJ_ELEMENT_ID |
| PROJECT_ID |
| DISPLAY_SEQUENCE |
| MILESTONE_FLAG |
| MILESTONE_FLAG_MEANING |
| CRITICAL_FLAG |
| CRITICAL_FLAG_MEANING |
| PARENT_ELEMENT_VERSION_ID |
| PARENT_OBJECT_TYPE |
| RELATIONSHIP_TYPE |
| RELATIONSHIP_SUBTYPE |
| SUMMARY_ELEMENT_FLAG |
| PROGRESS_STATUS_CODE |
| PROGRESS_STATUS_MEANING |
| PROGRESS_COMMENTS |
| PROGRESS_BRIEF_OVERVIEW |
| SCHEDULED_START_DATE |
| SCHEDULED_FINISH_DATE |
| TASK_MANAGER_ID |
| TASK_MANAGER |
| PARENT_STRUCTURE_VERSION_ID |
| WBS_LEVEL |
| WBS_NUMBER |
| ELEM_REC_VER_NUMBER |
| ELEM_VER_REC_VER_NUMBER |
| ELEM_VER_SCH_REC_VER_NUMBER |
| PARENT_VER_REC_VER_NUMBER |
| STATUS_ICON_ACTIVE_IND |
| PERCENT_COMPLETE_ID |
| STATUS_ICON_IND |
| STATUS_CODE |
| STATUS_CODE_MEANING |
| PRIORITY_CODE |
| PRIORITY_DESCRIPTION |
| ORGANIZATION_ID |
| ORGANIZATION_NAME |
| INCLUDE_IN_PROJ_PROG_RPT |
| ESTIMATED_START_DATE |
| ESTIMATED_FINISH_DATE |
| ACTUAL_START_DATE |
| ACTUAL_FINISH_DATE |
| COMPLETED_PERCENTAGE |
| OBJECT_RELATIONSHIP_ID |
| OBJECT_REC_VER_NUMBER |
| PEV_SCHEDULE_ID |
| LATEST_EFF_PUBLISHED_FLAG |
| PROJECT_NUMBER |
| PROJECT_NAME |
| PARENT_ELEMENT_ID |
| STRUCTURE_TYPE_CLASS_CODE |
| PUBLISHED_DATE |
| LINK_TASK_FLAG |
| DISPLAY_PARENT_VERSION_ID |
| AS_OF_DATE |
| REPORT_VERSION_ID |
| BASELINE_START_DATE |
| BASELINE_FINISH_DATE |
| SCH_BSL_START_VAR |
| SCH_BSL_FINISH_VAR |
| EST_SCH_START_VAR |
| EST_SCH_FINISH_VAR |
| ACT_SCH_START_VAR |
| ACT_SCH_FINISH_VAR |
| PM_SOURCE_NAME |
| PM_SOURCE_CODE |
| PM_SOURCE_REFERENCE |
| ACTIVE_TASK_FLAG |
| ACTIVE_TASK_MEANING |
| DAYS_TO_SCH_START |
| DAYS_TO_SCH_FINISH |
| WORK_TELEPHONE |
| SERVICE_TYPE_MEANING |
| SERVICE_TYPE_CODE |
| WORK_TYPE_NAME |
| WORK_TYPE_ID |
| CHARGEABLE_MEANING |
| CHARGEABLE_FLAG |
| BILLABLE_MEANING |
| BILLABLE_FLAG |
| RECEIVE_PROJECT_INVOICE_M |
| RECEIVE_PROJECT_INVOICE_FLAG |
| TRANSACTION_CTRL_START_DATE |
| TRANSACTION_CTRL_FINISH_DATE |
| PRIOR_PERCENT_COMPLETE |
| SCHEDULE_AS_OF_DATE |
| TRANSACTION_AS_OF_DATE |
| BASELINE_AS_OF_DATE |
| ESTIMATE_AS_OF_DATE |
| ACTUAL_AS_OF_DATE |
| FINANCIAL_TASK_FLAG |
| DAYS_TO_ESTIMATE_START |
| DAYS_TO_ESTIMATE_FINISH |
| DAYS_SINCE_ACT_START |
| DAYS_SINCE_ACT_FINISH |
| FINISHED_TASK_FLAG |
| FINISHED_TASK_MEANING |
| TASK_CREATION_DATE |
| LOWEST_TASK_MEANING |
| TASK_TYPE_ID |
| TASK_TYPE |
| TASK_STATUS_CODE |
| TASK_STATUS_MEANING |
| PHASE_CODE |
| PHASE_CODE_MEANING |
| PLANNED_EFFORT |
| WEIGHTING_PERCENTAGE |
| SCHEDULED_DURATION_DAYS |
| BASELINE_DURATION_DAYS |
| ESTIMATED_DURATION_DAYS |
| ACTUAL_DURATION_DAYS |
| ADDRESS_ID |
| ADDRESS1 |
| ADDRESS2 |
| ADDRESS3 |
| ADDRESS4 |
| WQ_ITEM_CODE |
| WQ_ITEM_MEANING |
| WQ_UOM_CODE |
| WQ_UOM_MEANING |
| WQ_PLANNED_QUANTITY |
| ACTUAL_WQ_ENTRY_CODE |
| ACTUAL_WQ_ENTRY_MEANING |
| PROG_ENTRY_ENABLE_FLAG |
| PERCENT_COMP_ENABLE_FLAG |
| REMAIN_EFFORT_ENABLE_FLAG |
| TASK_PROGRESS_ENTRY_PAGE_ID |
| PAGE_NAME |
| BASE_PERCENT_COMP_DERIV_CODE |
| BASE_PERCENT_COMP_DERIV_M |
| WQ_ENABLE_FLAG |
| PROG_ENTRY_REQ_FLAG |
| ESTIMATED_REMAINING_EFFORT |
| STRUCT_PUBLISHED_FLAG |
| ACTUAL_WORK_QUANTITY |
| VERSIONING_ENABLED_FLAG |
| PHASE_VERSION_ID |
| PHASE_NAME |
| SHORT_PHASE_NAME |
| ATTRIBUTE_CATEGORY |
| ATTRIBUTE1 |
| ATTRIBUTE2 |
| ATTRIBUTE3 |
| ATTRIBUTE4 |
| ATTRIBUTE5 |
| ATTRIBUTE6 |
| ATTRIBUTE7 |
| ATTRIBUTE8 |
| ATTRIBUTE9 |
| ATTRIBUTE10 |
| LIFECYCLE_VERSION_ID |
| TASK_UNPUB_VER_STATUS_CODE |
| OPEN_ISSUES |
| OPEN_CHANGE_DOCUMENTS |
| CHILD_ELEMENT_FLAG |
| DAYS_UNTIL_SCHEDULED_FINISH |
| CURRENT_PHASE_NAME |
| OPEN_CHANGE_REQUESTS |
| OPEN_CHANGE_ORDERS |
| PLANNED_EQUIP_EFFORT |
| RAW_COST |
| BURDENED_COST |
| PLANNED_COST |
| ACTUAL_EFFORT |
| ACTUAL_EQUIP_EFFORT |
| PREDECESSORS |
| PERCENT_SPENT_EFFORT |
| PERCENT_SPENT_COST |
| PERCENT_COMPLETE_EFFORT |
| PERCENT_COMPLETE_COST |
| ACTUAL_DURATION |
| REMAINING_DURATION |
| CONSTRAINT_TYPE |
| CONSTRAINT_TYPE_CODE |
| CONSTRAINT_DATE |
| EARLY_START_DATE |
| EARLY_FINISH_DATE |
| LATE_START_DATE |
| LATE_FINISH_DATE |
| FREE_SLACK |
| TOTAL_SLACK |
| LOWEST_TASK |
| ESTIMATED_BASELINE_START |
| ESTIMATED_BASELINE_FINISH |
| PLANNED_BASELINE_START |
| PLANNED_BASELINE_FINISH |
| BASELINE_EFFORT |
| ETC_EFFORT |
| ESTIMATE_AT_COMPLETION_EFFORT |
| VARIANCE_AT_COMPLETION_EFFORT |
| EFFORT_VARIANCE |
| EFFORT_VARIANCE_PERCENT |
| ACTUAL_COST |
| BASELINE_COST |
| ESTIMATE_AT_COMPLETION_COST |
| COST_VARIANCE |
| COST_VARIANCE_PERCENT |
| ETC_WORK_QUANTITY |
| PLANNED_COST_PER_UNIT |
| ACTUAL_COST_PER_UNIT |
| WORK_QUANTITY_VARIANCE |
| WORK_QUANTITY_VARIANCE_PERCENT |
| EARNED_VALUE |
| SCHEDULE_VARIANCE |
| EARNED_VALUE_COST_VARIANCE |
| EARNED_VALUE_SCHEDULE_VARIANCE |
| VARIANCE_AT_COMPLETION_COST |
| TO_COMPLETE_PERFORMANCE_INDEX |
| BUDGETED_COST_OF_WORK_SCH |
| SCHEDULE_PERFORMANCE_INDEX |
| COST_PERFORMANCE_INDEX |
| MAPPED_FINANCIAL_TASK |
| DELIVERABLES |
| ETC_SOURCE_CODE |
| ETC_SOURCE_NAME |
| WF_ITEM_TYPE |
| WF_PROCESS |
| WF_START_LEAD_DAYS |
| ENABLE_WF_FLAG |
| MAPPED_FIN_TASK_NAME |
| ETC_COST |
| PROGRESS_ROLLUP_ID |