[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 |