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]

Table: PA_PROJ_ELEMENTS

Product:	PA - Projects
Description:	PA_PROJ_ELEMENTS stores the common non-versioned information related to tasks and structures. - For future use
Implementation/DBA Data:	PA.PA_PROJ_ELEMENTS

Primary Key: PA_PROJ_ELEMENTS_PK

PROJ_ELEMENT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_PROJ_ELEMENTS	PA_PROJECTS_ALL	PA_PROJ_ELEMENTS.PROJECT_ID
PA_PROJ_ELEMENTS	PA_PROJ_ELEMENT_VERSIONS	PA_PROJ_ELEMENTS.PHASE_VERSION_ID
PA_PROJ_ELEMENTS	PA_PROJECT_STATUSES	PA_PROJ_ELEMENTS.PHASE_CODE
PA_PROJ_ELEMENTS	PA_LOCATIONS	PA_PROJ_ELEMENTS.LOCATION_ID
PA_PROJ_ELEMENTS	HR_ALL_ORGANIZATION_UNITS	PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID
PA_PROJ_ELEMENTS	PA_PAGE_LAYOUTS	PA_PROJ_ELEMENTS.TASK_PROGRESS_ENTRY_PAGE_ID
PA_PROJ_ELEMENTS	PA_PROJ_ELEMENTS	PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID
PA_PROJ_ELEMENTS	PA_TASK_TYPES	PA_PROJ_ELEMENTS.TYPE_ID
PA_LIFECYCLE_USAGES	PA_PROJ_ELEMENTS	PA_LIFECYCLE_USAGES.LIFECYCLE_ID
PA_PERCENT_COMPLETES	PA_PROJ_ELEMENTS	PA_PERCENT_COMPLETES.OBJECT_ID
PA_PROGRESS_ROLLUP	PA_PROJ_ELEMENTS	PA_PROGRESS_ROLLUP.OBJECT_ID
PA_PROGRESS_ROLLUP	PA_PROJ_ELEMENTS	PA_PROGRESS_ROLLUP.PROJ_ELEMENT_ID
PA_PROJECTS_ERP_EXT_B	PA_PROJ_ELEMENTS	PA_PROJECTS_ERP_EXT_B.PROJ_ELEMENT_ID
PA_PROJECTS_ERP_EXT_TL	PA_PROJ_ELEMENTS	PA_PROJECTS_ERP_EXT_TL.PROJ_ELEMENT_ID
PA_PROJ_ELEMENTS	PA_PROJ_ELEMENTS	PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID
PA_PROJ_ELEMENT_VERSIONS	PA_PROJ_ELEMENTS	PA_PROJ_ELEMENT_VERSIONS.PROJ_ELEMENT_ID
PA_PROJ_ELEM_VER_SCHEDULE	PA_PROJ_ELEMENTS	PA_PROJ_ELEM_VER_SCHEDULE.PROJ_ELEMENT_ID
PA_PROJ_ELEM_VER_STRUCTURE	PA_PROJ_ELEMENTS	PA_PROJ_ELEM_VER_STRUCTURE.PROJ_ELEMENT_ID
PA_PROJ_PROGRESS_ATTR	PA_PROJ_ELEMENTS	PA_PROJ_PROGRESS_ATTR.OBJECT_ID
PA_PROJ_ROLLUP_OBJ_TEMP	PA_PROJ_ELEMENTS	PA_PROJ_ROLLUP_OBJ_TEMP.OBJECT_ID
PA_PROJ_ROLLUP_OBJ_TEMP	PA_PROJ_ELEMENTS	PA_PROJ_ROLLUP_OBJ_TEMP.PARENT_OBJECT_ID
PA_PROJ_ROLLUP_TEMP	PA_PROJ_ELEMENTS	PA_PROJ_ROLLUP_TEMP.OBJECT_ID
PA_PROJ_ROLLUP_TEMP	PA_PROJ_ELEMENTS	PA_PROJ_ROLLUP_TEMP.PARENT_OBJECT_ID
PA_PROJ_STRUCTURE_TYPES	PA_PROJ_ELEMENTS	PA_PROJ_STRUCTURE_TYPES.PROJ_ELEMENT_ID
PA_PROJ_WORKPLAN_ATTR	PA_PROJ_ELEMENTS	PA_PROJ_WORKPLAN_ATTR.PROJ_ELEMENT_ID
PA_RESOURCE_ASSIGNMENTS	PA_PROJ_ELEMENTS	PA_RESOURCE_ASSIGNMENTS.RBS_ELEMENT_ID
PA_XBS_DENORM	PA_PROJ_ELEMENTS	PA_XBS_DENORM.SUP_ID
PA_XBS_DENORM	PA_PROJ_ELEMENTS	PA_XBS_DENORM.SUB_ID
PJI_AC_XBS_ACCUM_F	PA_PROJ_ELEMENTS	PJI_AC_XBS_ACCUM_F.PROJECT_ELEMENT_ID
PJI_FM_EXTR_PLAN_LINES	PA_PROJ_ELEMENTS	PJI_FM_EXTR_PLAN_LINES.PROJECT_ELEMENT_ID
PJI_FP_XBS_ACCUM_F	PA_PROJ_ELEMENTS	PJI_FP_XBS_ACCUM_F.PROJECT_ELEMENT_ID