FND Design Data [Home] [Help]

Table: PA_PROJECT_ASSIGNMENTS

Product: PA - Projects
Description: PA_PROJECT_ASSIGNMENTS stores details of all Assignments for a project.
Implementation/DBA Data: TablePA.PA_PROJECT_ASSIGNMENTS
Primary Key: PA_PROJECT_ASSIGNMENTS_PK
  1. ColumnASSIGNMENT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PA_PROJECT_ASSIGNMENTS FK Joins to TablePA_RESOURCES PA_PROJECT_ASSIGNMENTS.RESOURCE_ID
PA_PROJECT_ASSIGNMENTS FK Joins to TablePA_PROJECT_STATUSES PA_PROJECT_ASSIGNMENTS.STATUS_CODE
PA_PROJECT_ASSIGNMENTS FK Joins to TablePA_TEAM_TEMPLATES PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TEMPLATE_ID
PA_PROJECT_ASSIGNMENTS FK Joins to TablePA_PROJECTS_ALL PA_PROJECT_ASSIGNMENTS.PROJECT_ID
PA_PROJECT_ASSIGNMENTS FK Joins to TablePA_PROJECT_ASSIGNMENTS PA_PROJECT_ASSIGNMENTS.SOURCE_ASSIGNMENT_ID
PA_PROJECT_ASSIGNMENTS FK Joins to TableFND_TERRITORIES PA_PROJECT_ASSIGNMENTS.SEARCH_COUNTRY_CODE
PA_PROJECT_ASSIGNMENTS FK Joins to TablePER_ORG_STRUCTURE_VERSIONS PA_PROJECT_ASSIGNMENTS.SEARCH_EXP_ORG_STRUCT_VER_ID
PA_PROJECT_ASSIGNMENTS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PA_PROJECT_ASSIGNMENTS.SEARCH_EXP_START_ORG_ID
PA_PROJECT_ASSIGNMENTS FK Joins to TablePA_PROJECT_PARTIES PA_PROJECT_ASSIGNMENTS.PROJECT_PARTY_ID
PA_PROJECT_ASSIGNMENTS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PA_PROJECT_ASSIGNMENTS.EXPENDITURE_ORGANIZATION_ID
PA_PROJECT_ASSIGNMENTS FK Joins to TablePER_JOB_GROUPS PA_PROJECT_ASSIGNMENTS.FCST_JOB_GROUP_ID
PA_PROJECT_ASSIGNMENTS FK Joins to TablePER_JOBS PA_PROJECT_ASSIGNMENTS.FCST_JOB_ID
PA_PROJECT_ASSIGNMENTS FK Joins to TablePA_SYSTEM_LINKAGES PA_PROJECT_ASSIGNMENTS.EXPENDITURE_TYPE_CLASS
PA_PROJECT_ASSIGNMENTS FK Joins to TablePA_EXPENDITURE_TYPES PA_PROJECT_ASSIGNMENTS.EXPENDITURE_TYPE
PA_PROJECT_ASSIGNMENTS FK Joins to TablePA_WORK_TYPES_B PA_PROJECT_ASSIGNMENTS.WORK_TYPE_ID
PA_PROJECT_ASSIGNMENTS FK Joins to TableJTF_CALENDARS_B PA_PROJECT_ASSIGNMENTS.CALENDAR_ID
PA_PROJECT_ASSIGNMENTS FK Joins to TablePA_LOCATIONS PA_PROJECT_ASSIGNMENTS.LOCATION_ID
PA_PROJECT_ASSIGNMENTS FK Joins to TableFND_CURRENCIES PA_PROJECT_ASSIGNMENTS.EXPENSE_LIMIT_CURRENCY_CODE
TablePA_ASSIGNMENTS_HISTORY FK Joins to PA_PROJECT_ASSIGNMENTS PA_ASSIGNMENTS_HISTORY.ASSIGNMENT_ID
TablePA_CANDIDATES FK Joins to PA_PROJECT_ASSIGNMENTS PA_CANDIDATES.ASSIGNMENT_ID
TablePA_EXPENDITURE_ITEMS_ALL FK Joins to PA_PROJECT_ASSIGNMENTS PA_EXPENDITURE_ITEMS_ALL.ASSIGNMENT_ID
TablePA_FORECAST_ITEMS FK Joins to PA_PROJECT_ASSIGNMENTS PA_FORECAST_ITEMS.ASSIGNMENT_ID
TablePA_OBJECTS FK Joins to PA_PROJECT_ASSIGNMENTS PA_OBJECTS.ASSIGNMENT_ID
TablePA_ORG_FCST_ELEMENTS FK Joins to PA_PROJECT_ASSIGNMENTS PA_ORG_FCST_ELEMENTS.ASSIGNMENT_ID
TablePA_PROJECT_ASSIGNMENTS FK Joins to PA_PROJECT_ASSIGNMENTS PA_PROJECT_ASSIGNMENTS.SOURCE_ASSIGNMENT_ID
TablePA_RESOURCE_ASSIGNMENTS FK Joins to PA_PROJECT_ASSIGNMENTS PA_RESOURCE_ASSIGNMENTS.PROJECT_ASSIGNMENT_ID
TablePA_SCHEDULES FK Joins to PA_PROJECT_ASSIGNMENTS PA_SCHEDULES.ASSIGNMENT_ID
TablePA_SCHEDULES_HISTORY FK Joins to PA_PROJECT_ASSIGNMENTS PA_SCHEDULES_HISTORY.ASSIGNMENT_ID
TablePA_TRANSACTION_INTERFACE_ALL FK Joins to PA_PROJECT_ASSIGNMENTS PA_TRANSACTION_INTERFACE_ALL.ASSIGNMENT_ID
TablePA_TXN_INTERFACE_AUDIT_AR FK Joins to PA_PROJECT_ASSIGNMENTS PA_TXN_INTERFACE_AUDIT_AR.ASSIGNMENT_ID
TablePA_TXN_INTERFACE_AUDIT_ALL FK Joins to PA_PROJECT_ASSIGNMENTS PA_TXN_INTERFACE_AUDIT_ALL.ASSIGNMENT_ID
TablePA_PROJECT_ROLE_TYPES_B FK Joins to PA_PROJECT_ASSIGNMENTS PA_PROJECT_ROLE_TYPES_B.PPT_ASSIGNMENT_ID