Results for “task_budget_line_key”

16 results




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

Overview

PA_TSK_BGT_LINES_IT_ALL is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores task-level budget lines for the Oracle Project Analysis Collection Pack. It is an interface/collection staging table (indicated by the _IT_ALL suffix), designed to hold budget data at the intersection of project task, budget period, budget type, resource list member, expenditure type, and service type so that this information can be collected and consumed by the Analysis Collection Pack business intelligence and reporting infrastructure.

Under the heuristic Data Vault classification mined from its foreign key structure, this table is modeled as a link entity. That classification is a modeling suggestion rather than a physical implementation: the table serves as an intersection resolving many-to-many relationships between tasks, periods, resources, budget types, expenditure types, service types, and operating units, and it carries descriptive measures (cost, revenue, quantity) that a pure link would normally delegate to a satellite.

The table is owned by the PA schema, is documented as VALID, and contains 35 columns with a single documented unique index, PA_TSK_BGT_LINES_IT_ALL_U1, on TASK_BUDGET_LINE_KEY.

Key Information Stored

The surrogate primary key is TASK_BUDGET_LINE_KEY, enforced by PA_TSK_BGT_LINES_IT_ALL_PK and also carried by the unique index PA_TSK_BGT_LINES_IT_ALL_U1, making it the primary business-key candidate as well. The most significant columns and their roles are: