Results for “resource_assignment_id”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GMS_RESOURCE_ASSIGNMENTS is a table within the GMS (Grants Accounting) product in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores resource assignments for a budget version at a branch of a project's work breakdown structure. In the Grants Accounting model, budget versions are prepared against a project's WBS hierarchy, and each assignment links a specific resource list member to a budget version, project, and task combination. This table therefore acts as the intersection that records which resources are budgeted against which work breakdown branches, enabling resource planning and labor distribution at the grants level.

From a Data Vault modeling perspective, the heuristic classification is satellite-leaning. The table carries descriptive attributes (such as unit of measure and labor tracking flags) that describe an association between budget versions and resource list members, suggesting a satellite-like role attached to a hub-and-link core rather than functioning as a pure hub itself.

Key Information Stored

The table contains twelve documented columns. The single-column surrogate primary key is RESOURCE_ASSIGNMENT_ID, enforced by GMS_RESOURCE_ASSIGNMENTS_PK and reinforced by the unique index GMS_RESOURCE_ASSIGNMENTS_U1. The business-key candidate is captured by the unique index GMS_RESOURCE_ASSIGNMENTS_U2, which spans BUDGET_VERSION_ID, PROJECT_ID, TASK_ID, and RESOURCE_LIST_MEMBER_ID, guaranteeing that a given resource list member appears only once per budget version/project/task branch.

  • RESOURCE_ASSIGNMENT_ID — Surrogate primary key uniquely identifying each assignment row.
  • BUDGET_VERSION_ID — Foreign key to GMS_BUDGET_VERSIONS; identifies the budget version under which the assignment is made.
  • PROJECT_ID — Foreign key to PA_PROJECTS_ALL; the project to which the assignment belongs.
  • TASK_ID — Foreign key to PA_TASKS; the WBS branch or task within the project.
  • RESOURCE_LIST_MEMBER_ID — Foreign key to PA_RESOURCE_LIST_MEMBERS; the specific resource being assigned.
  • UNIT_OF_MEASURE — The unit of measure applicable to the assigned resource quantities.
  • TRACK_AS_LABOR_FLAG — Flag indicating whether the assigned resource is tracked as labor for grants accounting purposes.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording creation and modification metadata.

Common Use Cases and Queries

Typical reporting scenarios involve reconciling budget assignments against approved budget lines, analyzing labor resources by project and task, and auditing resource allocation across budget versions. A common query joins assignments to their budget lines through the reciprocal foreign key. For example, retrieving all assignments for a given budget version typically filters on BUDGET_VERSION_ID, while a resource-utilization report groups by PROJECT_ID and TASK_ID.

Sample pattern: select ra.RESOURCE_ASSIGNMENT_ID, ra.PROJECT_ID, ra.TASK_ID, ra.RESOURCE_LIST_MEMBER_ID, ra.TRACK_AS_LABOR_FLAG from GMS_RESOURCE_ASSIGNMENTS ra where ra.BUDGET_VERSION_ID = :p_version. To link assignment detail to budgeted amounts, join GMS_BUDGET_LINES bl on bl.RESOURCE_ASSIGNMENT_ID = ra.RESOURCE_ASSIGNMENT_ID. Joining to PA_RESOURCE_LIST_MEMBERS, PA_TASKS, and PA_PROJECTS_ALL allows resource names, task names, and project numbers to be surfaced in reporting.

Related Objects

  • GMS_BUDGET_VERSIONS — Parent of BUDGET_VERSION_ID; defines the budget version context.
  • PA_PROJECTS_ALL — Parent of PROJECT_ID; supplies project master information.
  • PA_TASKS — Parent of TASK_ID; provides WBS task detail.
  • PA_RESOURCE_LIST_MEMBERS — Parent of RESOURCE_LIST_MEMBER_ID; defines the assigned resource.
  • GMS_BUDGET_LINES — Child table referencing this table via RESOURCE_ASSIGNMENT_ID, linking assignments to budgeted line amounts.