FND Design Data [Home] [Help]

Table: GMS_RESOURCE_ASSIGNMENTS

Product: GMS - Grants Accounting
Description: Resource assignments for a budget version at a branch of project's work breakdown
Implementation/DBA Data: TableGMS.GMS_RESOURCE_ASSIGNMENTS
Primary Key: GMS_RESOURCE_ASSIGNMENTS_PK
  1. ColumnRESOURCE_ASSIGNMENT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
GMS_RESOURCE_ASSIGNMENTS FK Joins to TableGMS_BUDGET_VERSIONS GMS_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID
GMS_RESOURCE_ASSIGNMENTS FK Joins to TablePA_PROJECTS_ALL GMS_RESOURCE_ASSIGNMENTS.PROJECT_ID
GMS_RESOURCE_ASSIGNMENTS FK Joins to TablePA_TASKS GMS_RESOURCE_ASSIGNMENTS.TASK_ID
GMS_RESOURCE_ASSIGNMENTS FK Joins to TablePA_RESOURCE_LIST_MEMBERS GMS_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID
TableGMS_BUDGET_LINES FK Joins to GMS_RESOURCE_ASSIGNMENTS GMS_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID