FND Design Data [Home] [Help]

Table: PA_PROJECT_ACCUM_HEADERS

Product: PA - Projects
Description: Project summary records for each combination of project_id, task_id, and resource_list_member_id
Implementation/DBA Data: TablePA.PA_PROJECT_ACCUM_HEADERS
Primary Key: PA_PROJECT_ACCUM_HEADERS_PK
  1. ColumnPROJECT_ACCUM_ID
Primary Key: PA_PROJECT_ACCUM_HEADERS_UK
  1. ColumnPROJECT_ID
  2. ColumnTASK_ID
  3. ColumnRESOURCE_LIST_MEMBER_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PA_PROJECT_ACCUM_HEADERS FK Joins to TablePA_TASKS PA_PROJECT_ACCUM_HEADERS.TASK_ID
PA_PROJECT_ACCUM_HEADERS FK Joins to TablePA_RESOURCE_LIST_MEMBERS PA_PROJECT_ACCUM_HEADERS.RESOURCE_LIST_MEMBER_ID
PA_PROJECT_ACCUM_HEADERS FK Joins to TablePA_PROJECTS_ALL PA_PROJECT_ACCUM_HEADERS.PROJECT_ID
PA_PROJECT_ACCUM_HEADERS FK Joins to TablePA_RESOURCE_LIST_ASSIGNMENTS PA_PROJECT_ACCUM_HEADERS.RESOURCE_LIST_ASSIGNMENT_ID
PA_PROJECT_ACCUM_HEADERS FK Joins to TablePA_RESOURCE_LISTS_ALL_BG PA_PROJECT_ACCUM_HEADERS.RESOURCE_LIST_ID
TablePA_PROJECT_ACCUM_ACTUALS FK Joins to PA_PROJECT_ACCUM_HEADERS PA_PROJECT_ACCUM_ACTUALS.PROJECT_ACCUM_ID
TablePA_PROJECT_ACCUM_BUDGETS FK Joins to PA_PROJECT_ACCUM_HEADERS PA_PROJECT_ACCUM_BUDGETS.PROJECT_ACCUM_ID
TablePA_PROJECT_ACCUM_COMMITMENTS FK Joins to PA_PROJECT_ACCUM_HEADERS PA_PROJECT_ACCUM_COMMITMENTS.PROJECT_ACCUM_ID
TablePA_RESOURCE_ACCUM_DETAILS FK Joins to PA_PROJECT_ACCUM_HEADERS PA_RESOURCE_ACCUM_DETAILS.PROJECT_ID
PA_RESOURCE_ACCUM_DETAILS.TASK_ID
PA_RESOURCE_ACCUM_DETAILS.RESOURCE_LIST_MEMBER_ID